That is an excellent methodology.  Thanks

I just used the #TempTable for an example.  You should be able to use the ALTER statement directly upon your existing table.  One note:  you can do this in Enterprise...

If records are deleted, the consecutive integers will have gaps.  Will this still fit your needs? 

If gaps are not a problem, you can run ALTER TABLE. ...

Obviously there is too much to even act like you know it all beforehand.  Only a handful of the guru's on this site know enough that they rarely get stumped. ...

Where's sushila when I need her?  She's much better at giving you a hard time than I am....   

(btw: do you not "care"...

Heheeheeee.  Noel called you a chicken.  heheeee 

OMG!  That post made me an addict.  More than coincidence? 

I know.  This is for one of those situations in which you are not sure of the data and need to test various scenarios, so I may keep #TempTable around...

You can output a value to a @Variable as one example... 

(In this instance, I have created a #TempTable called #Variables and loop through it for each transaction.  I populate...

We do exactly this process.  We have one report for many stored procedures. 

We wrote a standard stored procedure which accepts information from a web page.  That information then references...

Divesting herself of her assets is NOT breaking the law!  My ex-wife had cancer and that was the ONLY way to get SSN and other payments for her treatments.  It...

Is your mother a US resident?  If so, check into Social Security.  You may be surprised at what they can offer.   

(I...

I HATE ADMITTING MY IGNORANCE, BUT I HATE NOT KNOWING SOMETHING EVEN MORE.   

Please explain why you call your query "set based" versus...

Two things... 

1)  I am grateful we "elected" this President.  Kerry would have sued the terrorists and gotten them into therapy.  Actually, I am even more conservative than Bush portrays...

SQL Server has a week function, but you may find it rather odd to work with.   

Try the following and see what you...