DC (4/27/2009)

---

I will say, one Cursor I haven't quite figured out how to eliminate, is when a vendor requires that something be done via a Stored Proc, and you want...

greatheep (4/27/2009)

---

So, the gauntlet is down - any suggestions on how to achieve the same benefits using set processing?

In summary, we want:

- If there is an error in a row,...

[font="Verdana"]You're welcome, Michelle. 😀 I'm glad it worked.

[/font]

[font="Verdana"]Hi Michelle,

The trick here is that you need to actually convert the number to a datetime, not just treat it as a datetime and hope for the best. SQL...

aaronxramirez (4/27/2009)

---

the only time I have ever needed a cursor is to achieve some sort of lookahead in the result set, such that data in in row 1 depended on...

[font="Verdana"]Aha!

I have to say I enjoyed this more than the first article, largely because the first article was really just an introduction to the topic.

I like your use of examples...

[font="Verdana"]I like the southern cross, and I like the silver fern and I like the kiwi. They're all our national symbols. I don't see why the flag need...

RBarryYoung (4/26/2009)

---

(copied from my blog):

For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...

[font="Verdana"]The worst "novel solution" for a report I have ever seen was a canned standard report delivered as part of a banking solution to a small bank I did some...

[font="Tahoma"]Using a left join is one way, but the code will progressively slow down (er, that doesn't mean it's invalid, and sometimes it's still the best performing solution because other...

[font="Verdana"]"Are the posted questions getting worse?" Point's people in the direction of Flo's discussion question.[/font]

[font="Verdana"]There are some excellent examples already posted. What have you tried? ...

[font="Verdana"]Do you need to call the stored procedure to insert the data, or can you insert directly into underlying tables?[/font]

[font="Verdana"]May well be.

My concern with the RegEx stuff is the temptation...

[font="Verdana"]Only if you use code to generate the lookup table. 😀 Go on, list all...