Ok, I'm not Jeff but I'm gonna take a shot at this anyway

First the question

WeekStart = DATEADD(dd,DATEDIFF(dd,-1,Date)/7*7,-1),

The /7*7 gives you a different number because the 7's are integers....

Grumpy DBA (11/12/2007)

---

I guess Henry found a way around paying the posting fee... ha ha...

J Moden - Where in Michigan are you located? I heard about a possible opening...

Using the "code" and "/code" tags (you need to include square brackets around those words instead of the double quotes... ). Still sucks for the end user, though, because...

Thanks for the feedback on your solution, Juan...

Heh... it's a great analogy... An unhealthy bit of code will make your database sick or...

I couldn't have come up with a better analogy if I tried... there are so many that are absolute rubbish when...

No, no... I believe a checksum of each row would allow you to check for uniqueness across the 24 columns. Lookup CHECKSUM in BOL...

Is this a separate request or added requirements to what has been done already?

... and NVL is ORACLE... the equivelant in SQL Server is ISNULL... but why would you not...

Just a different slant on things...

-- DROP TABLE #T

GO

--===== Create a table to store the results in

CREATE TABLE #T

(

...

And, please don't post duplicate posts.... we'll find ya...

http://www.sqlservercentral.com/Forums/Topic420902-145-1.aspx

Duplicate post...

http://www.sqlservercentral.com/Forums/Topic420896-146-1.aspx

Lordy, I hate setting up test data for payroll examples... whatever...

Here's some code that generates 100,000 entries for 200 employes for a year's worth of payroll following your rules...

So, double check one more time...

All indexes (indluding primary keys) on the test box are also available on the production box.

All tables have the same row count on both boxes.

All...

You didn't listen to me... lookup "expanding hierarchies" in Books Online and adapt it. It WILL do as you ask.

Oh, little nuances like will there ever be more than 2 names in a class? If so, do all the scores have to be the same or just 2?...