Viewing 8 posts - 31 through 38 (of 38 total)
I prefer "IN" for readability and maintenance. Haven't checked performance though.
January 19, 2004 at 9:10 pm
According to Books on Line ...
DEFAULT
Is a keyword that specifies the default value for the column. DEFAULT definitions can be used to provide values for a new column in...
January 18, 2004 at 6:04 pm
Can be done by using same technique as in my reply to the thread
Flattening several rows into one row
Just replace the comma as a separator with a tab -...
January 15, 2004 at 4:49 pm
Try adapting this bit of skeleton code .... should be OK providing your tables are small enough.
declare @t1 table (claim char(1), cust char(1), report char(1))
insert into @t1 values ('a','x','1')
insert into @t1... January 15, 2004 at 4:05 pm
The where not exists should be changed ...
January 12, 2004 at 1:24 pm
... or use one convert statement, and use substring to extract the part you want.
eg select substring(convert(char(20),getdate(),113),13,8)
November 10, 2003 at 6:58 pm
For another possibility, see my code in "xp_sendmail problem". Uses a text column to generate the required string. Has the advantage that the string can grow longer than...
November 9, 2003 at 1:49 am
DTS would have probably been a bit more awkward for the requirements - csv with quotes around headings as well as data - plus having to have a timestamp as...
November 9, 2003 at 1:30 am
Viewing 8 posts - 31 through 38 (of 38 total)