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...

Tania Mofflin (6/3/2014)

---

This comes back with the following error -

Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to numeric.

Seems to be an issue with how...

Second that but then again that's pondering on the...

Thank you Andy for a good question.

Quite certain I checked the right answer but still came as wrong. Either a bug or lack of industrial strength tanker sized espresso in...

This should get you started. In order to produce a complete answer, a order must be specified for the set, as it is, it is not possible. A hint for...

Using the automatic settings for the...

Not without dissecting the code as only CLR procedure parameter defaults are listed in sys.parameters. More can be found here http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=234143%5B/b].

😎

vasuarjula (6/2/2014)

---

Hi,

I have a procedure (a) where i call another procedure (b) passing @message as a parameter to procedure B.

Ex:

Create procedure a

as

Begin

declare @prevyear

exec b @message = 'avvasdva' + cast(@prevyear as...

Is something like this what you are looking for?

😎

USE tempdb;

GO

;WITH XMLNAMESPACES (DEFAULT 'http://tempuri.org/Ultimate')

,XML_DATA AS

(

SELECT

EX.ID

...