Geez!!! All this talk about whoops and guess what happens???

I was moving two new stored procedures from dev to prod.  I usually use query analyzer to do this, but I...

I've made this mistake before as well.  I've thought about using a template like the one Chopeen showed, but I haven't really brought myself up to speed on transactions.  Is...

Thanks for that bit of code Remi!  I've got a ranking working now for the league teams and the response is very fast.  Since the largest that table will ever...

To be more specific, I'd like to figure out a way to do the ranking portion.  I can build everything else but was wondering if someone had done something like...

You might have a chance if you do two things:

1.  Buy her a big multi-caret rock on a ring for her

2.  Tell her that you'll get a different monitor stand...

I've figured it out using a combination of Substring and Charindex!

I've always given thought on how this could be done, but never followed through. This is definately going into our best practices documentation!

Are there any other nifty things (clues)...

I ran into this before. Sometimes wrapping the Oracle query with OpenQuery seemed to help. Look up OpenQuery in the Transact-SQL Reference.

Brian