Robert brought up some very good points and I just wanted to expound on them.  There are two keys to good performance... one, of course, is the code folks write......

Pop, I agree with Serqiy... I don't think you need to break the source information into "by the minute" rows.  If you could post some T/A rows for a couple of...

Thanks, Aders, Steve, and Michael!

Sohil...

You do realize that UTC is based on the time at the Prime Meridian and that you need to subtract some hours from that to get Eastern Time, right?

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