[font="Verdana"]It's the wave of the future. Get in touch with your inner Excel. Who needs SQL Server when you can have... dum dum...

[font="Verdana"]:w00t: Welcome back![/font]

Tom.Thomson (4/30/2009)

---

Samuel Vella (4/27/2009)

---

Jeff Moden (4/27/2009)

---

Heh... in SQL Server 2005, even that can be done without a cursor. We're just gonna have to wait for it in Barry's series...

[font="Verdana"]I think it's best to qualify it from the security point of view as well (thinks of potential object injection attacks). If you need to move things around at...

sharad sinha (4/29/2009)

---

Approach 2:

Use separate queries ...1 for each database...and then return the union of these resultsets...The problem with this approach is that the number of history databases keep...

[font="Verdana"]Well done, Roy! International Star Wars day... "May...

[font="Verdana"]It sure did. Today I...

[font="Verdana"]Hey Flo,

A series of articles won't hurt. Then you can do a separate articles around...

[font="Verdana"]Dammit Bob! Now I need to wrap my head around CROSS APPLY... that looks useful![/font]

[font="Verdana"]There's a point I'd like to raise.

When you are looking at something like a cursor and seeing how well it performs over a small number of rows, it's easy to...

[font="Verdana"]This morning I had an idea. After I had had a bit of a sit down to recover from that novel feeling, and to reassure myself that I'd soon...

[font="Verdana"]You know? I am really looking forward to Flo's final article. :-D[/font]

[font="Verdana"]So what is the nature of the logic such that it requires cursors? I think the more you can tell us about what you actually need the stored procedure...

GSquared (4/28/2009)

---

There are times when it's more efficient to do batches like...

Jack Corbett (4/27/2009)

---

It depends on what the stored procedure is doing. In instances like this I have read the vendor code and if possible, write my own set-based process that...