That would be part of the inconsistency... procs recompile when certain amounts of data...

I can't prove it, but apparently you have... I've heard that the sp_OA* procs have a "connection leak"...

Real key here is what do you think you need an sp_AO* string...

I don't see any similarity, either, except for the fact that Alicia has, again, not shown anything that she's tried (not to mention the double post).

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