Viewing 15 posts - 56,086 through 56,100 (of 59,067 total)
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......
June 19, 2007 at 4:58 am
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...
June 18, 2007 at 6:14 pm
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?
June 18, 2007 at 6:00 pm
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...
June 18, 2007 at 7:09 am
USE GMT and pass the hour offset to do the correction.
June 18, 2007 at 7:05 am
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...
June 18, 2007 at 6:24 am
Ummm... upgrade to Enterprise Edition??? Why have a muscle car if you're just going to use if for a golf cart?
June 18, 2007 at 6:10 am
Yep... I know that... you're saying you want 20 new rows with the same SN?
June 17, 2007 at 7:19 pm
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
June 17, 2007 at 7:18 pm
Thanks for the feedback and for not taking it the wrong way, Mark.
You have exactly the right frame of mind to...
June 17, 2007 at 10:01 am
So, you want 20 identical rows? And the "SN" doesn't change?
June 17, 2007 at 8:34 am
James,
You forgot to ask, "What have you tried?"
and I think you just did someone's homework for him
......
June 16, 2007 at 1:49 pm
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...
June 16, 2007 at 1:44 pm
Viewing 15 posts - 56,086 through 56,100 (of 59,067 total)