MrBaseball34,

You do make some good points. There is way to get your SQL Code to look better and it is available on this site, http://extras.sqlservercentral.com/prettifier/prettifier.aspx, just not well-known. ...

Mark Harr (7/30/2008)

---

Regarding performance: I just don't see why or how these luddite DBA do not see that "dynamic SQL" and "stored procedures" are compiled exactly the same. ALL...

Michael Taylor (7/30/2008)

---

I would tend to disagree with this editorial in almost every way. The only real argument I saw as viable was the point about creating 4 sprocs...

Oh yeah, it really is a good editorial because it has sparked debate. Just because I don't agree with the opinion in the editorial doesn't mean I didn't enjoy...

I'll admit I'm in the "USE stored procedures camp" and one of the main reasons is this quote from your editorial which you use as a reason to NOT use...

g.raghunathan (7/29/2008)

---

Hi Thank you for teh update.But still O am facing the same problem.

My main table XXX_FLOW has : 125638737 records in it and

My SP : Billing_Completed_Flow access a...

You can add them to the SQLAgentUserRole in msdb.

The authentication method is Instance based not Server based so if I have 2 instances 1 can be Windows only and 1 can be mixed.

I like it:D

Select @Count = @@ROWCOUNT

GSquared (7/29/2008)

---

Jack Corbett (7/29/2008)

---

I assume this will work on a server as it works on my PC. Right-Click on My Computer -> Properties and on mine it says Intel...

Thanks guys. I thought about messing with the scripting options. I'll have to compare them on both machines.

In a situation where I only want to sum cd sales for cd's in the Opera and Classical categories you could do something like:

SUM(IIF(category = "Opera" Or category = "Classical",...

Yeah, this could...

The With IGNORE_DUP_KEY only ignores duplicates on insert operations. From BOL:

IGNORE_DUP_KEY = { ON | OFF }

Specifies the error response to duplicate key values in a multiple-row insert...