Actually, you are a tiny bit off.  Week two starts on Sunday, January 2, 2005. 

SELECT DATEPART( week, '01/01/2005')

SELECT DATEPART( week, '01/02/2005')

SELECT DATEPART( week, '01/03/2005')

Either way, this...

Trees, schmees... You can easily regrow those.  My first degree was in environmental science and you would not believe the pollucka we have bought into regarding MOST environmental issues...

I have seen a number of examples using Row Identifiers for sending the first 50, then the next 50, etc. records to an asp output page.  I know of no...

Beautiful!  Thank you. 

What about #TempTables?  Especially ones which do not contain any indexes, contraints, etc.  One of our folks insists that SELECT INTO is far more inefficient than building the table ahead...

Can you be more specific?  What doesn't work?  No insert? 

Why is @MaxDate less than StartTime? 

You can also do it this way...

FROM        

 dbo.OccMain ocm

 INNER JOIN dbo.OccMalignant omg ON( ocm.AilmentID = omg.AilmentID)

 LEFT JOIN dbo.CodeLookUp c ON( c.Code=omg.SentNode AND c.CType = 65)

Thanks, David!  I can't spell worth a poop.   

My son had colic and it was a living hell!  That is the most blood...

SELECT MAX( Date) and GROUP ON Code and Item Name, (if you need Item Name).  You said the Item Name might change, so you may want to get that value...

I am not sure how you are including table T2 in this by your Business Rules. 

I have put together this little script; maybe you can give me more information. ...

I think PhilM99 hit it right with the following: "In order to avoid wild goose chases, it is best if you improve the stored proc to give you back any...

No, that is not how it works.  Within your code, you Create #Table.  Then call function and within the function make it Return @Table (same table structure) as the #Table.  Then insert...

You can insert into one.  You need to create it ahead of time.  Then call your function. 

I, personally, like the pivot table as it is easier to look at and understand.  What would concern me is, are you having to ALTER TABLE to add more key's? ...

What if you populated a @TableVariable with the names of the new tables and then simply looped through those records? 

SELECT name AS TableName

INTO @TableVariable

FROM sysobjects

WHERE xtype...