Viewing 15 posts - 7,111 through 7,125 (of 18,926 total)
You can't use group by in an update.
You have to precompile the data in a derived table and then join back to the base table for the update.
February 23, 2011 at 10:56 am
Start with this. It should shed a lot of light (if not all of it) on what's wrong with your code.
http://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/
February 23, 2011 at 9:27 am
Assuming it's not a global temp table, then you'll have to kill the spid that holds the table alive.
Once the connection closes, the temp table will self destruct.
February 22, 2011 at 1:29 pm
Hey Jessica, I've just been tasked to make all our reports work on iphones. Any hints on how I can accomplish this?
The users will need to access an interface to...
February 22, 2011 at 11:06 am
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
but I think I'm right on this one if implicit transactions are on.
I also thought that if you executed a procedure on a connection with implicit...
February 16, 2011 at 7:16 am
GilaMonster (2/16/2011)
February 16, 2011 at 7:13 am
Lowell (2/16/2011)
to do the top 20 of the top 90%, it's just nested selects....
select TOP 20 * FROM
(
SELECT TOP 90 PERCENT *...
February 16, 2011 at 6:35 am
Why can't you do all of the processing in 1 batch (create, populate, select, drop)?
February 16, 2011 at 5:59 am
Paula-196779 (2/15/2011)
February 15, 2011 at 7:50 am
GilaMonster (2/14/2011)
Ninja's_RGR'us (2/14/2011)
But I'd still run checkdb TODAY on your latest backup.
If that was the only error that the integrity check maintenance task picked up, then there's no need. That...
February 14, 2011 at 11:52 am
GilaMonster (2/14/2011)
Rather run it during a maintenance window. That error's not critical, it doesn't have to be fixed immediately.
Ok then, what she said (she's much better than I at this).
But...
February 14, 2011 at 11:23 am
I'd go 1 step further. I'd run checkdb as soon as possible.
There are errors missed in 2000 that are detected in 2005.
Make sure you have a valid backup as...
February 14, 2011 at 11:22 am
I don't see anything for sql 4, 5... would be a nice historical research!
BTW congrats on the shortest article ever!
February 14, 2011 at 7:19 am
Viewing 15 posts - 7,111 through 7,125 (of 18,926 total)