ramana3327 (6/4/2014)

---

Ok.

If we forget about mine and come to the general situation. In usually what could be the possible reasons causes of high execution time if we execute SP immediately...

SQLRNNR (6/4/2014)

---

LightVader (6/4/2014)

---

I hooked up my old SNES to...

Unfortunately the situation leaves us purely guessing, as far as we can tell, the first execution bulk loads million records and the next writes engraves them in Sanskrit.

😎

It is an OS scope threat, as I said...

The plural makes it sound like polygamy

😎

+1 Nice!

😎

Why not use the Split function?

😎

rahulabhinav15 (6/3/2014)

---

I have a Excel sheet as destination.But i need to name that file dynamically from the value from sql query.Can anyone please help.

Actually the excel sheet gets createdin the...

Quick thought, think FOR XML PATH with TYPE is better suited for this than EXPLICIT.

😎

muthyala_51 (6/3/2014)

---

Eirikur Eiriksson (6/3/2014)

---

muthyala_51 (6/3/2014)

---

3.Microsoft XML Editor Information Disclosure Vulnerability (MS11-049)

-- This security patch is released on Feb 2012 before of the SQL Server 2008 R2 SP2(june 2012). DO i...

muthyala_51 (6/3/2014)

---

3.Microsoft XML Editor Information Disclosure Vulnerability (MS11-049)

-- This security patch is released on Feb 2012 before of the SQL Server 2008 R2 SP2(june 2012). DO i need to still...

Lynn Pettis (6/3/2014)

---

Eirikur Eiriksson (5/30/2014)

---

Since this is a 2012 thread, how about the window functions?

😎

create table #sampledata

(

userId int,

BaseYear int,

...

gbritton1 (6/3/2014)

---

Here's a variant using FLOWR. I think it's a bit more readable but YMMV:

;with xmlnamespaces(DEFAULT 'http://tempuri.org/Ultimate')

select ex.xml.query('

for $x in /Entity

where $x/Person/Last_Name = "Hillier"

...

FunkyDexter (6/3/2014)

---

Not really. It brings the Element and Person parts of the path back together but now the First_Name is out in the breeze. The objective is to...

You could use modulus/remainder of the number

😎

;WITH TN(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS...