Okay, a non-cursor way to accomplish this same task:

declare @SQLCmd varchar(max);

select @SQLCmd = (select 'exec insert_sp ' + cast(md.sid as varchar) + ';' + char(13) + char(10)

...

jwillbanks (9/20/2012)

---

I get the above message with this query:

select a.deliverydate, count (distinct (a.orderno)) as Orders, count (distinct(a.sku)) as Lines,

SUM(a.QuantityShipped/b.UoM) as Cases, SUM(a.QuantityShipped*b.length*b.width*b.height/12/12/12) as CubicFeet

from dbo.COI a, dbo.IM b

where

a.sku =...

The bit bucket? I don't think the PRINT statement will actually print any where, but I could be wrong.

SomewhereSomehow (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

SomewhereSomehow (9/20/2012)

---

CELKO (9/20/2012)

---

don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin...

David Moutray (9/20/2012)

---

Somehow I think SELECT LEN('a') is too simple for Dave's competition. There must be some really obscure way of returning a 1.

I'm wracking my brain trying to...

You could use a tool like Redgate's Data Compare.

Sean Lange (9/20/2012)

---

The other possible query I can think of is SELECT INTO. This wont guarantee Atomicity and Consistency as the INTO table might still be created even if the...

Okay, these people should be disqualified.

YSLGuru (9/20/2012)

---

Lynn Pettis (9/19/2012)

---

Bump. Have you tried my latest change? You know, not including the [ ] around the server name and instance name with the -S parameter...

2ndHelping (9/20/2012)

---

Lots of folks have posted informative replies; but at the end of the day, the only way to know for sure in your own situation is to gather the...

SomewhereSomehow (9/20/2012)

---

CELKO (9/20/2012)

---

don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin skin, but assume...

CELKO (9/20/2012)

---

don't think you'll scare him. Maybe offend, but not scare. He comes across as one of those borderline sociopathy cases that have very thin skin, but assume everyone...

You may need to drop and recreate.

xinli923 (9/20/2012)

---

And message include,cannot find default browser

I named my SQL server : SQL 2012. If cannot connect to it,it means cannot find SQL 2012. But why say cannot find default...

Fail to connect. Depends, what is the actual error message you are getting?