Viewing 15 posts - 7,906 through 7,920 (of 10,143 total)
bodhilove (5/16/2010)
When I backup and restore the database on the same instance and run the query it works.
So, after you backup and restore, it works. Then what? It's working, then...
May 19, 2010 at 5:44 am
Dave Ballantyne (5/18/2010)
Reporting a single post in a thread seems to report the whole thread as spamexample
Reported as spam.
May 18, 2010 at 2:18 am
jcrawf02 (5/14/2010)
Chris Morris-439714 (5/14/2010)
Paul White NZ (5/14/2010)
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably bright...
May 14, 2010 at 9:46 am
Hi Peter
Have a look at the output from this SELECT. If the row containing 1 for ChosenRow is the row you want to keep, then rewrite the SELECT including only...
May 14, 2010 at 9:17 am
Paul White NZ (5/14/2010)
Chris Morris-439714 (5/14/2010)
May 14, 2010 at 7:50 am
GilaMonster (5/14/2010)
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit.
Apparently he's actually a very nice guy and...
May 14, 2010 at 7:46 am
Paul White NZ (5/14/2010)
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably bright individual, but his...
May 14, 2010 at 7:07 am
sabarish (5/14/2010)
I need to insert about 20 records to a database table.... Which is the better approach -
1) inserting one record at a time
2)...
May 14, 2010 at 4:38 am
CREATE PROCEDURE USP_UPDATESAL
@DPID INT
AS
UPDATE Humans
SET SAL = CASE deptid
WHEN 10 THEN 40000
WHEN 20 THEN 38000
WHEN 30 THEN 10000
WHEN 40 THEN 0
WHEN 50 THEN -1
END
WHERE deptid...
May 14, 2010 at 3:43 am
Viewing 15 posts - 7,906 through 7,920 (of 10,143 total)