Very disappointing. This is a fairly basic question. A little proofreading could have prevented this from becoming a bad question.

Kanaka (7/19/2010)

---

I am not sure why sql server 2008 returned 1, inspite of not giving the variable length.

I knew this would give a syntax error, however, I tried this and...

Thanks for all of the feedback. I definitely should have considered case-sensitivity, especially since we have several case-sensitive database here. In hind sight, I should have made everything...

This is straight from the link supplied in the answer.

SQL Server 2008 introduces several extensions to the GROUP BY clause that enable you to define multiple groupings in the same...

I'm a big fan of using surrogate keys when designing databases, but they are not intended to enforce data integrity. They should be used to simplify joins and used...

You can't use a variable to pass in that DATEADD parameter. The only way I know of to do what you're attempting is to use dynamic SQL like this:

DECLARE...

They're not being used, so they shouldn't affect it at all.

Greg

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...