Sean Lange (7/21/2011)

---

You can't pass a stored procedure to a function. You could pass the results of a stored procedure to a function if you wanted. Based on what you...

Elliott Whitlow (7/21/2011)

---

How many records are we talking about here?

You certainly can do this row by row, however that method of processing is substantially slower than a set based solution....

Steve Jones - SSC Editor (7/20/2011)

---

Rod at work (7/20/2011)

---

I appreciate this article, Steve, as it's something I have faced for the last 3 years. No training, no conferences, etc....

I appreciate this article, Steve, as it's something I have faced for the last 3 years. No training, no conferences, etc. However, in my situation it isn't so much...

I totally agree with you, Andy. I'm one of those accidental DBA's. We're a small IT shop (used to be 4 of us, but we've lost 1 recently...

Boy, Steve, you nailed this one! I work in an industry closely related to healthcare (it isn't really, but there are similarities), and our budget is shrinking constantly (20%...

Ron Porter (6/8/2011)

---

I have a question related to the fact that there seems to be a lot of demand that programmers have a bunch of their own work to show...

This is a tough question. I work for a university, and when I've been involved in interviewing people for open positions I've learned how hard that is. For...

Good points, Steve.

I agree. Some other word would probably have done...

Really?! Man, I'm amazed, about rich text and what we've stored in our varchar(max) fields. WOW. That's like an epithany, at least on a small scale. ...

Steve,...

Ninja's_RGR'us (5/24/2011)

---

If you really want to transfer everything I'd look into access based upsizing wizards. I don't have any recommandations, but those will be built by and for people...

Eddie Wuerch (5/16/2011)

---

Are you running the RTM version of SSMS 2005? That was the case with the original version, to present 'look, we're more secure this way', but after everyone...

Steve Jones - SSC Editor (5/16/2011)

---

If you have an active connection, you can open all of them without issue. Is there a reason you can't make one connection and leave...