Share with us why you want to know, please. And what do you define as "better"?

To quote a good friend of mine... "A Developer must not guess... a Developer must KNOW." Be sure and take a look. 😉

I agree that dynamic SQL is the way to go here. You could concatenate the same dynamic SQL you have in your cursor using the ol' SELECT @sql =...

GSquared (1/22/2009)

---

Zip-code prefixes are state-specific. Can't span states. Lots of them span counties, but they don't span states. Even cities that span state-lines, have different Zip codes...

SELECT usually uses some form of shared lock unless it's in an explicit transaction along with one of the other statements. Inserts and Updates use anything from a rowlock...

Using a cursor in 2k5 when VARCHAR(MAX) is available? Lowell? :hehe:

Is there, by any chance, a trigger on the table that trys to "normalize" time zones?

The other part of the problem is the concatenations and the formulas on columns. No chance of an index being used for anything practical there.

Also, you're inserting into the...

Heh... you've just gotta know that any post with "RBAR" in the title is going to catch my eye. Thought I'd stop by and see what's up. Looks...

mtucker (1/22/2009)

---

If someone sees that you are doing a lot more work than them for the same salary they have a very good incentive to work harder. They would not...

Yep... I do the same thing... except I've been solving the problem and then asking for a bit of feedback. Of course, once the cat's out of the bag,...

mtucker (1/22/2009)

---

better decisions with regard to their salary and conditions...should i ask for...

I'm thinking it was a coincidence... not sure though... looks like one of those times when you "had to be there" to figure it out. I've never seen that...

Exactly... if it weren't for me asking for stuff they said they could provide, they wouldn't have...

See? That's what I mean... 😛 I'm just about that...