Ok... whatever... that's still not the way to do it... the $ sign should be added in a SELECT (if you've gotta do it that way)... in truth, the formatting...

USE GMT and pass the hour offset to do the correction.

Pop,

How many rows are we talking about?

Midan,

Answer the question and I can help... do you want the SN to be the same for all 20 new rows?  This is an easy problem... I just need the...

Ummm... upgrade to Enterprise Edition???  Why have a muscle car if you're just going to use if for a golf cart?

Yep... I know that... you're saying you want 20 new rows with the same SN?

For some pretty good info on the differences between Temp Tables and Table Variables, check out the following URL... Q3/A3 and Q4/A4 seem to be the most valuable...

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

Thanks for the feedback and for not taking it the wrong way, Mark.    You have exactly the right frame of mind to...

So, you want 20 identical rows?  And the "SN" doesn't change? 

James,

You forgot to ask, "What have you tried?"  and I think you just did someone's homework for him ......

Hopefully, your Amount column is one of the numeric datatypes and not character based... your query should work fine as is but the WHERE clause does not have the same...

The error is correct... Since you want to use the CURRENT_TIMESTAMP as the DATE column, you need to create a column alias... like this...

 INSERT INTO Employees

June 16, 2007 at 1:32 pm