Viewing 15 posts - 47,461 through 47,475 (of 59,064 total)
jack_hc (10/30/2008)
I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now what i am...
October 31, 2008 at 7:45 pm
Mark Rissmann (1/30/2007)
IF UPDATE(VendorCode)
BEGIN
UPDATE vendor SET vendorcode=inserted.vendorcode
FROM inserted JOIN deleted ON inserted.vendorID=deleted.vendorID
WHERE (inserted.vendorcode <> deleted.vendorcode) AND (inserted.iscopy=0) AND (inserted.ID =...
October 31, 2008 at 7:37 pm
It's a good thing to have, anyway... make a Calendar table based on the user inputs.
October 31, 2008 at 7:25 pm
sam (10/31/2008)
e.g. row 4 and 5 have a common custnumber, amount and semester so i want...
October 31, 2008 at 7:18 pm
dlongnecker (10/31/2008)
Hey everyone,I've got a table with a column of ints and I need to remove any discontinuity between them...
Although PW's post is spot on, I suspect there's a bigger...
October 31, 2008 at 7:09 pm
anupamabr (10/31/2008)
thanks for your quick response ..eventhogh i changed the code it didnt work
Do you mean that you changed it to T-SQL?
October 31, 2008 at 7:07 pm
dbaInTraining (10/31/2008)
October 31, 2008 at 6:58 pm
john.steinbeck (10/31/2008)
I'm a bit confused, but check out my post I just posted and my other post, "Recursive"; I think that may be what you want...
Please post the correct URL.
October 31, 2008 at 6:57 pm
clive (10/31/2008)
What is the preferred option, if exists or if @@rowcount.
What is the preferred option, temporary table or derived table.
What is the preferred...
October 31, 2008 at 6:48 pm
Garadin (10/31/2008)
October 31, 2008 at 6:44 pm
Jorge,
I flattered that you've mimiced the format I use for comments. And, they're pretty much what I would expect to see in a code review.
There are, however, a couple...
October 31, 2008 at 5:52 pm
jlcampos71 (10/31/2008)
I'll do that Jeff... but please let me know... where can I found information about it?
Yeaup... start by looking up "temporary tables [SQL Server]" (without the quotes) in Books...
October 31, 2008 at 5:29 pm
stacik (10/30/2008)
October 31, 2008 at 11:06 am
Heh... here's just some of the problems you can run into if you mess around with dates, times, and durations...
October 31, 2008 at 10:48 am
Viewing 15 posts - 47,461 through 47,475 (of 59,064 total)