zapouk (7/21/2011)

---

....

declare @B1 char(1) --could be null

declare @B2 char(1) --could be null

....

select @B1 = 'x'

select @B2 = null

....

@B1 = @B2

....

select @B1 = null

select @B2 = null

...

@B1 = @B2

--Ans:...

Philip Yale-193937 (7/21/2011)

---

Brandie Tarvin (7/20/2011)

---

This code will most likely NOT use the index because the index only works if your WHERE clause has Col3 listed and if it references Col3...

I'm curious. How many people subscribe to a job service (or keep in touch with job sites / recruiters) because they're currently looking?

Or do you just keep in touch just...

Gidget

That salary can't be...

Oi! That...

We do not have enough information to fully answer your questions. We would need create table statements, create index statements, and sample data insert statements in order to test ourselves....

Without seeing your DDL, I can't be sure, but it sounds like your non-clustered index doesn't use tran1 in the first column.

I heard a lecture at a SQL Saturday that...

Ninja's_RGR'us (7/20/2011)

---

Brandie Tarvin (7/20/2011)

---

On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the...

Can you update it to VARCHAR(MAX) without breaking...

Why would a combination of REPLACE(), LIKE() and PATINDEX() not work here?

EDIT: Like in Lowell's example? It's set based, no looping. Looping bad if you don't need to do it.

Thanks, Gail. I appreciate you verifying that for me.

So just restore over the exist rather than delete first?

My advice would be to use Dynamic SQL. Declare a variable, set the variable's value to the sql command above (with the date / time info concated into the string),...

Have you tried the REPLACE() function?