Viewing 15 posts - 56,101 through 56,115 (of 59,078 total)
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
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
Well, not really... if you have a hundred million row table and you isolate a million of those rows in a temp table for some SQL prestidigitation, for example...
Or you...
June 15, 2007 at 9:43 pm
Are you storing numbers that you will calculate with in that column??? World of hurt getting ready to happen there... $ won't let you do calcs unless you first convert to...
June 15, 2007 at 8:41 pm
How's 'bout running Steve's riding lawnmower underwater?
I'm the luckiest guy in the world… my Dad made the coolest "gadget" I've ever seen except it's...
June 15, 2007 at 8:23 pm
Viewing 15 posts - 56,101 through 56,115 (of 59,078 total)