Grant Fritchey (5/12/2009)

---

OK. I get it. You can't open Books Online or do a search there. And you can't possibly connect to Google and do a search there. But you're...

Declaritive Referential Integrity. Using FK's instead of the application or triggers.

I wouldn't have an issue being presented an environment where I had to troubleshoot something, write a query, or create a data model. Several people have mentioned how this...

Thanks, now I am pounding my head on...

Check out the RANK function in BOL. Something like this might work (Uses adventureworks):

;WITH cteRank AS

(

SELECT

...

You cannot enforce Foreign Keys across databases using DRI, you would have to do it in a trigger or check constraint (would have to be a UDF).

Lynn Pettis (5/12/2009)

---

Jack Corbett (5/12/2009)

---

Sometimes I wonder why I post full solutions including test data when the OP doesn't run the test code.

http://www.sqlservercentral.com/Forums/Topic714364-8-2.aspx

Then complains that I didn't provide a solution...

Here is another option which I think is a little easier to read than Atif's, but in my simple tests between the 2 does not perform quite as well and...

I don't see any reason for an infinite loop here, but I could be missing something.

I also think you can probably do this without a cursor which will...

Sometimes I wonder why I post full solutions including test data when the OP doesn't run the test code.

http://www.sqlservercentral.com/Forums/Topic714364-8-2.aspx

Then complains that I didn't provide a solution that meets their need....

I included DepartmentID in the output assuming it is a unique key so you could include it in the join criteria because of the possibility, however slight, that duplicate checksums...

"Select *" is not one column it is all the columns,

I agree with Gail. Post as she has asked as your requirements are more complex than just using a CASE statement as your case statement will return all combinations...

How about something like this for a start (I'm using AdventureWorks for SQL Server 2005, but the code is valid for SQL 2000):

-- create a copy of a table in...

I agree with the calendar table idea, but I still think you should answer the questions I posted on the other thread you started with the same question, http://www.sqlservercentral.com/Forums/Topic714216-9-1.aspx. ...