Did you try putting SET NOCOUNT ON before the stored procedure is executed?

MarkusB (11/3/2011)

---

I agree with Philip, non of the given answers is correct.

The question explicitly says 2005 or higher, but the result on a 2005 server is different from a 2008...

Carla Wilson-484785 (10/24/2011)

---

Hugo Kornelis (10/24/2011)

---

PS: There's even one more way to achieve the intended change:

UPDATE TOP(1) Table1

SET Column1 = 0

WHERE Column1 = 1;

Since row order in...

hakan.winther (10/24/2011)

---

charlietuna (10/23/2011)

---

The solution seems a bit opaque. Something like this is (to me) much more straightforward for the next person who has to read it:

update #t

set col1 = case...

Sorry, but yes. UNION ALL, UNION except when actually needed is bad ju-ju 🙂

Rather than copy/pasting into excel, why not use Excel's Microsoft Query option and have Excel run the query and do the import?

When that happens Excel will blank out the NULL...

rajiv.varma (10/20/2011)

---

Thats a design issue that I need to take up with my boss. He wants all the data (Yes, the entire 7 years) ready to be reported. No archival....

DugyC (10/20/2011)

---

I knew we were in trouble with this one when it asked for 3 answers but I could find only 2 that were clearly true.

Went with 2 answers hoping...

L' Eomot Inversé (10/6/2011)

---

I find...

L' Eomot Inversé (10/6/2011)

---

I was pretty sure that...

L' Eomot Inversé (10/5/2011)

---

I'm not particularly upset, just a bit worried that people don't appear to remember this stuff. And if there is a better known terminology that the...

Good question,

I had it right, then I thought to double check myself and searched out rebuildm.exe

didn't realize I hit the Msdn article for SQL 2000 and picked the wrong answer...

Thomas Abraham (10/3/2011)

---

I got it wrong, so I tested it on my own system. (2008 R2 - 2005 not available)

Results for table variable, in ms: 80800, 80203, & 79523

Results for...

He calls himself an “Accidental DBA.” His title at DiscoverReady is Lead Application DBA and Data Architect. He’s known as a writer for SQLServerCentral.com whose articles are often...

I finally solved this...

After all my attempts using an OLE DB Data Source,

I changed the data source for the queries that gave me this trouble to ado.net data sources,...