SQL Server Stem Words

We needed to find related words using the SQL Server FORMSOF function. Although it is used mainly to find related words in bodies of text, we wanted to use it to find related words in a table of just words. Initial approaches focused on finding a SQL Function or table that contained the database of […]

Sql Cross Apply

I found out about a feature in SQL Server 2005 I didn’t know about (having come from a SQL Server 2000 shop). Cross Apply! It’s for when you want to feed the value of a table row into a function and join on the results. This is different than a cross join, because you cannot […]

Drupal Module: Org Chart

I created an org chart module. It interacts with the profile module to display an organizational hierarchy. From the project description: An organizational chart that uses the profile.module. Install in your modules directory. Currently, it uses profile fields to build the chart. It assumes that there will be two fields that hold the following data: […]

SQL Pivot

A co-worker asked me about transposing a question response table. I came from a SQL 2000 background, so I was excited to play with the PIVOT command which is available in SQL 2005 and 2008. It’s a common use case to transpose row-based data into columns. Sometimes it just makes more sense to people to […]

StackOverflow: How to insert into a table with just one IDENTITY column

I had a problem at work today, and this post on Stack Overflow resolved it. //stackoverflow.com/questions/850327/how-to-insert-into-a-table-with-just-one-identity-column

T-SQL Export Table Data

Here’s a quick script to export table data:

SQL Joins

CS/IS/Computer-Related FAQ Topic: SQL QuestionWhat are joins? What is the difference between all of the different types of joins? AnswerA join is the combination of columsn across multiple tables. This differs from a union, in that unions are combinations of rows. The join syntax looks something like:SELECT * FROM tbl1 [LEFT | RIGHT | INNER […]

SQL Assist?

I NEED SQL help! Is there a way to syntatically join these two ideas?? var1=select conference_id from table1 where conference_name=’Trauma’; var2=select conference_date from table2 where conference_id.table2=var1; Answer: select conference_date from table2,table1 where conference_id.table1=conference_id.table2 and conference_name.table1=’trauma’; I want to find the corresponding primary key to the first table using “conference name” and then look up the […]

Jamie Ly

Developer, student, person

sql