abd (3/5/2008)

---

Thank you Andras and Nisha for your replies

In fact Andras, yes, this is a short example of my sp

but the problem here i can not use the IF statement,...

This may come as a bit of a shock, but the usual method of performance tuning is not to try to eliminate the use of an index, but rather to...

In addition to what everyone else says, be sure to focus on carefulling picking the clustered index. Because you only get one, you want to be sure it's storing the...

The man was a legend. I was never a huge fan of D&D, preferring Call of Cthulhu & war games. While I didn't spend lots of time with his game...

Just a guess, but are there multiple transactions within the query?

Is that ELSE clause a documented standard? I clearly need to update my documents.

Almost too accurate to be funny.

Thanks for sharing.

Yeah, you should be able to employee a CASE statement, but it depends on where you mean to employee it.

I think, note that key word, it's because of a rounding error when doing an implicit conversion from the string to the float. The other two can do the implicit...

Jack's right.

The table you asked about is where SQL Server tries to maintain the dependency chain between objects (although it doesn't do a great job at it). It's important...

wtipton (3/3/2008)

---

Howdy. I have a customer table rm00101 that has a field userdef2 that needs to be updated with the data in a response code field from a credit card...

I was just going to post the exact same link. Cool!

Oh come on, it'll have an effect. You're inserts will be faster because you're not maintaining a useless index.

😀

As everyone else has already pointed out, if you pass in brackets, you can make a table named almost anything, including [].

But, if we assume you either strip the brackets...

I definately recommend you NOT use a function for this type of query. It's a straight select statement. It should be done within a stored procedure or a parameterized query....