The worst way possible! They didn't even take the time to use parameters, which isn't hard at all to do in .Net.

I could go on a rant for hours...but...

Gila,

Ha ha!!! If only it were in an SP. This is a system I was hired to "fix" just 10 months ago. There are numerous issues with the system including...

OK, I'll post the query...but it's not pretty. I've made a little progress adding one index, but it's still running great and then it runs long. I've been running it...

Max,

Unfortunately we're a split shop here so I don't have access to the server and OS. I even have to request traces to be run for me. It definitely makes...

kevriley,

Interesting. So I can test this using the examples from the traces I have? If I inspect the execution plan of the fast running query and compare it to the...

Well, what I ended up doing is created a new role in the master db, then added my app's login to that role, then gave that role only select permissions...

I have to agree with everyone else who posted above. The answers weren't very precise.

I thought DOB referred to "Date of Birth" so I didn't select that answer. I also...

You know, actually this is what I love about SQL programming...it's always a challenge.

Wow...that's a lot of info. I'm starting to think I don't have the experience/know-how to rewrite this. For one, I probably would have made the same mistake by using nested...

dragos_sv,

I'm not familiar with semaphores.

However, I thought of 2 similar ideas. The link Torsten supplied had code for a function that can check if an SP is running or not....

Torsten, thanks for the excellent link.

I guess is explained my problem poorly - what I really want to know is how can you run a SP with multiple instances without...

Wait...I meant I've never heard of BOHICA before!

LOL...I've never heard of TARFU before, that's classic.

I know you guys are right, but I'm afraid to open that Pandora's box right now. I will keep it in mind for...

Matt,

Thanks for the input.

The problem is that they set this column up as a varchar(15) and often replicate 0's to the front of it. So a cagecard id can be...

Wow...that's insane. So it's not the select or insert statement at all that's doing it.

OK, so now for a super newbie question...how do I figure out the "real" line numbers...