Year would be another column and the query is looking for 2008.

Greg

It looks like DTYPE is the column name. IN refers to the values inside the parenthesis. Basically it could be rewritten as DTYPE = 'DEPR' OR DTYPE =...

Although I never figured out why the same stored procedure was behaving differently in the two different environments, I did resolve this issue. I decided to take a completely...

Here are the two execution plans.

You can attach the .mdf file without the .ldf file. When you go to attach it, the interface may say log file not found in the lower pane. ...

GSquared (2/25/2009)

matt stockham (2/25/2009)

You mean...

If I understand correctly, you want one total result set instead all of the individual ones. If your iteration is happening in the stored procedure, you can insert them...

One of the main reasons to use a join is to get data from more than one table. The above query should work assuming that the columns specified are...

Your open parenthesis is in the wrong place. (exec @sql) should be exec (@sql).

Greg

You can query across database using three part naming. For example:

SELECT * FROM Database.Schema.Table

Greg

Max and min server memory is in MB, so your setting is way too high.

Greg

Because it's not the only correct answer. Without giving away the answer, the answers were check boxes. You needed to select more than one.

Greg

I agree with Matt. The pseudo code that you posted doesn't tell us what tables the three columns are from or what the relationships between the tables are, etc....

Yes. RTRIM(LTRIM(columnname))

Greg

Try using ISNULL(COUNT(col2), 0). That should replace the NULL values with a zero.

Greg