Hello Marty,

You still on the thread ? Did the code i sent work for you?

Thanks, Jeff..

You can use SELECT INTO also , to insert the result set into a table

SELECT INV_NO

,BLANK = SUM ( CASE WHEN...

Here is how you must present data so that people viewing the thread will hop on to it asap

Sample data:

IF OBJECT_ID('TempDB..#TempData') IS NOT NULL

DROP...

Mark, i know of a easy way to do that .

First, your visual representation of the data is good. But it would greatly help if you had provided the data...

Jeff is 100% right on his assessment of my code. There can be MANY tweaks. As a humble student of his, i wanted to impress my mentor. Jeff if u...

Added more details in code and optimized it.

DECLARE @StartDATE DATETIME

,@EndDate ...

And coming to my code, a 0-based will throw the CASE statement out of sync. That's why i din't use it 🙂

Thanks Rozema for "bettering" it out. If zero based tally table will make it cleaner, we can do something like

Tally...

Thank you Welsh!

Wooshy tooshy 🙂 i was in love with the requirement so i got coding for this in my flight to North Carolina 🙂 hows that for dedication 😛

First Part of...

How will this do?

; WITH ConvertedValues AS

(

SELECT [account]

, DATEADD( MM , DATEDIFF( MM , 0, CONVERT( DATETIME ,...

How about this?

DECLARE @Table Table

(

RecordNum INT IDENTITY(1,1)

,strDomainName VARCHAR(255)

,strShortName VARCHAR(255)

)

INSERT INTO @Table ( strDomainName)

...

Depends on SET IMPLICIT_TRANSACTIONS setting in the connection/database level property.

But generally , if u wont want to auto-commit , u can have something like this

BEGIN TRAN

insert

update

delete

and once you confrm...

All of the 4 books are great 🙂 No prejudice , i just love all of 'em 😛