I don't disagree that it would be nice addition, but there is a work-around. Also it would be nice if people would use the IFCodes period. How many...

On the top right hand...

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",...