mgalgey (1/20/2009)

---

Thanks Steveb,

I want to capture any custom code that is in the stored proc that is not auto generated and insert it into the new stored proc.

Eg

Old ...

Oh, and it goes before the ORDER BY clause.

Try using the HAVING clause. Look it up in Books Online for details, but it would look something like this:

SELECT...

FROM...

WHERE..

GROUP BY...

HAVING SUM(MyValue) > 0

It's sort of like a WHERE clause...

I'm not aware of a good, all encompassing SQL Server 2005 tutorial. I'm with Jack. You'll need to hit JumpstartTV, Simple-Talk, and of course, here at SSC, to get the...

Jack Corbett (1/19/2009)

---

Grant Fritchey (1/19/2009)

---

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in...

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in here to protect us...

I'm sorry, but I don't understand the structure. What relates one table to another? How would you join table1 to table2 to get the results you want. What does table3...

I don't see why you both couldn't write an article on the same topic. With your different backgrounds, knowledge sets and approaches I'll bet both would offer up unique information....

rferguson (1/18/2009)

---

Hi Grant, the stored procedure already uses the sp_executesql function. What I'm essentially trying to acheive is to create a dynamic SQL statement, but in which the WHERE clause...

office (1/18/2009)

---

Hello -- I'm working with much smaller databases for web-based database applications using SQL Server Express 2005. I've been very pleased with it for the last few years...

Jack Corbett (1/18/2009)

---

I've got a series on Profiler/Trace in process, building from real basic to a little more advanced (server-side traces, etc...). I was waiting on getting a new...

In fact, you'd probably hurt performance with just an index on Event, depending on where the cluster index is on the table (if there's a clustered index) because you're likely...

In addition to the web sites Gail provided (and the storage engine web site from Microsoft is just fantastic), you might want to read through Kalen Delany's book on the...

Steve Jones - Editor (1/18/2009)

---

Sue moved over to PM'ing full time, not really much SQL Server last year. I actually was thinking to send her an email and see how...

Wow! That is good. I must have missed it the first time round. I agree with the herd on this one Steve, you...