Please note that the query in the apply from cphites excellent solution is using TOP 1 but it also needs to have an order by so you know which row...

You didn't make this much clearer so I am making some assumptions here. Please notice how I posted a table and sample data. This is something you should do in...

tcronin 95651 (4/17/2015)

---

i have a table that has defined as xml. I would like to parse out one of the values, as a row by row I can figure...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1677466-202-1.aspx

That's pretty awesome!!!

I didn't post a link to Gail's articles but here it is. Please notice that there are links in that article to parts 2 & 3.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

Removing the cursor and while loop really should be the first step here. Given that you have two updates that update the same row can you just combine them into...

When you upgraded from 2008 to 2012 did you do any maintenance? Stats and indexes need to be rebuilt as the way the engine handles those things is very different...

Eirikur Eiriksson (4/14/2015)

---

Sean Lange (4/14/2015)

---

Eirikur Eiriksson (4/14/2015)

---

ztoddw (4/14/2015)

---

This way is probably more efficient-

declare @STRING varchar(1000);set @STRING='100010111100010001';

select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))

from (select n=number, sub=substring(@STRING,number,len(@STRING))

from master.dbo.spt_values where type='P'

and (number between 1 and...

It is almost certainly going to do with parameter sniffing or poor indexing. With no details we can't do much to help.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

Eirikur Eiriksson (4/14/2015)

---

ztoddw (4/14/2015)

---

This way is probably more efficient-

declare @STRING varchar(1000);set @STRING='100010111100010001';

select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))

from (select n=number, sub=substring(@STRING,number,len(@STRING))

from master.dbo.spt_values where type='P'

and (number between 1 and len(@STRING))) t

where (n=1 or...

SQLCurious (4/14/2015)

---

I have a table that has the following data

ID

---

101

102

105

108

124

189

I need to call a stored proc for each of the IDs above. Our existing code which has a cursor to...

NHS Baz (4/14/2015)

---

Can anyone tell me what I've done wrong with the following function? I suspect it's something obvious that I just cant see.

CREATE FUNCTION [dbo].[CheckLoginDetails_Username](@SuppliedUsername nvarchar(150), @SuppliedPassword nvarchar(150))...

And to further my point, the cross tab approach would work for a whole slew of employees in one pass. The insert and multiple update approach you would have to...

And buy one for me...