Viewing 15 posts - 5,536 through 5,550 (of 9,722 total)
It does. Just so long as you're aware of your particular needs and code it so that it doesn't use an existing value, you should be able to use it...
July 21, 2011 at 10:34 am
Yes, I'm aware of that issue. I should have been more clear in my earlier reply.
When using ISNULL() this way, you need to make sure you're using a new value...
July 21, 2011 at 10:13 am
Philip Yale-193937 (7/21/2011)
Brandie Tarvin (7/20/2011)
July 21, 2011 at 8:00 am
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...
July 21, 2011 at 7:00 am
Kit G (7/20/2011)
Revenant (7/20/2011)
MousketeersAnnette Funicello
Gidget
July 21, 2011 at 4:43 am
hor_netuk (7/21/2011)
I know times are hard, but a job alert email subscription delivered me the attached vacancy today. For the record, I won't be applying. 😛
That salary can't be...
July 21, 2011 at 4:40 am
Stefan Krzywicki (7/20/2011)
I think that's just Steve's warning to people presenting at PASS to take care of their voices. He's showing what happens when you get a little hoarse.
Oi! That...
July 20, 2011 at 12:36 pm
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....
July 20, 2011 at 12:34 pm
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...
July 20, 2011 at 12:18 pm
Ninja's_RGR'us (7/20/2011)
Brandie Tarvin (7/20/2011)
July 20, 2011 at 11:32 am
AndrewSQLDBA (7/20/2011)
I forgot to mention this, but the column is a text data type, and replace is not working with Text data type.
Can you update it to VARCHAR(MAX) without breaking...
July 20, 2011 at 11:30 am
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.
July 20, 2011 at 11:24 am
Thanks, Gail. I appreciate you verifying that for me.
July 20, 2011 at 11:10 am
Viewing 15 posts - 5,536 through 5,550 (of 9,722 total)