Viewing 15 posts - 56,746 through 56,760 (of 59,072 total)
No... it only get's updated on INSERT... like any default, it WILL NOT BE APPLIED DURING UPDATES... for example...
USE TEMP
CREATE TABLE ModifyTest(SomeCol INT, ModifiedDate DATETIME)
GO
CREATE...
March 16, 2007 at 4:29 am
First, I think the use of global (##) temp tables, as you have, will eventually burn you with a "table already exists" error. Recommend you change them to local (#) temp...
March 16, 2007 at 4:03 am
There are about a thousand posts about this on this forum. Please do a search on "crosstab" and "pivot".
March 16, 2007 at 3:47 am
Ah... got it, David... thought you were talking about something else.
March 15, 2007 at 8:11 pm
| BTW, the order of columns defined in create table statement has no impact on the way the data... |
March 15, 2007 at 5:13 pm
Thanks for the feedback, NorVid.
March 15, 2007 at 5:10 pm
That would be Hawaii...
In the same vein, which state observes both Central Daylight Time AND Eastern Daylight Time?
March 15, 2007 at 5:08 pm
Can you post what you used? We can all learn a new trick or two....
March 15, 2007 at 5:03 pm
Find wherever sysinfo.exe is on the C: drive and execute it from a cmd window... more information will appear than you could possibly use including the number, make, model, revision,...
March 15, 2007 at 4:19 pm
I'd likely make it use a few more CASE statements to keep from having to dip the Status table 3 times in the FROM clause... crosstab code is VERY fast if...
March 15, 2007 at 7:19 am
Heh... going back to the other posts, I see that now...
Hope things are going well for Mother and Child.
March 15, 2007 at 6:59 am
Can you post a line of the troublesome data?
March 14, 2007 at 7:36 pm
Viewing 15 posts - 56,746 through 56,760 (of 59,072 total)