Human beings do not look at 200000 rows worth of data... ever. So, you need to identify the data that is actually needed for the report, the last day's worth...

Also, rather than have one of use write the entire query for you, show the work that you've tried, even if it doesn't work, and then we can help correct...

stratergib_77 (12/16/2008)

---

Hi, I'm building a web application that uses sql server for my database. This database holds student information, course information, student grades, etc. Currently I have my student table,...

Jeff Moden (12/15/2008)

---

Must be something else... I raised two kids... even did the Cub Scout and Boy Scout thing and a whole bunch of other things that gave me a...

At least he made it easy for you:

Wait, wait... I'm confused.

We had tracks?

Itzik Ben Gan's new one, SQL Server 2008 T-SQL Fundamentals. Almost all of it will be applicable to 2005. After you finish that one, pick up his older book Inside...

Well, I didn't just tumble out of a Vault, you know.

I agree with Jack on this. SSMS is a pretty good tool, but you don't have to use it. As a matter of fact, you might be much better off...

It means the process itself still has work to do, but it's waiting on something. BOL refers to blocking as a possible cause.

Is the field a number field, int, bigint, numeric, decimal. If not, it won't allow you to create an identity.

I'd strongly suggest you use Matt's solution. The one you have is going to perform pretty badly.

Then you're just a little bit stuck. You can't refer to objects that don't exist in the query, even if it's just in an IF statement. Why couldn't you use...

Depending on the data types in question, there's nothing inherently wrong with a compound natural key. I'm not sure why it would matter to the end user though.

If I understand the problem, then I'd suggest instead of having three queries for the three version, have three procedures and then, depending on the version, using your IF statement,...