This will give you a new row for each XML FormItem element.

SELECT TicketAssessors.Name AS [Assessors Name], TicketAssessors.Designation AS [Assessors Designation],

...

Very likely. You'll need to post more details though.

These will be returned as NULLs in the query. Have you tried it?

See if this helps

DECLARE @T TABLE(ID INT, XMLCol XML)

INSERT INTO @T(ID,XMLCol)

VALUES(1,

'<ArrayOfFormItem xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<FormItem>

<ControlId>Club_Licensed</ControlId>

<ItemValue>y</ItemValue>

<ItemText>Yes</ItemText>

</FormItem>

...

Naomi N (11/30/2011)

---

How will you expand the solution when you have StartDate EndDate fields in your table and you want continuous intervals, e.g.

01/01/2010 - 01/15/2010

01/16/2010 - 02/10/2010

The above two...

You're welcome!

Try this

DECLARE @x XML

SET @x=@invoer

SELECT r.value('1+count(for $a in . return $a/../ *[. << $a])','int') AS nr,

r.value('(./customernumber)[1]','VARCHAR(15)') AS customernumber,

...

Thanks...

Is this what you're after?

select XOrder as [OrderHeader/XOrder],[CustomerPoNumber] as [OrderHeader/CustomerPoNumber],

Customer as [OrderHeader/Customer],

CONVERT(VARCHAR(10),OrderDate,120) as [OrderHeader/OrderDate],

CONVERT(VARCHAR(10),RequestedShipDate,120) as [OrderHeader/RequestedShipDate],

(Select

(select case when LineType = 1 then CustomerPoLine end as...

Use this

http://www.sqlservercentral.com/articles/Best+Practices/61537

Can you post some sample data for the source tables?

This sort of construct won't work

IF 'abc' in (@Selection) -- If abc is in @selection then we are taking bank

You could try

IF @Selection LIKE '%,abc,%'

instead

I think this is known as a directed graph

DECLARE @Start VARCHAR(50)

DECLARE @End VARCHAR(50)

DECLARE @MaxLevels INT

SET @Start='G9'

SET @End='BIN200'

SET @MaxLevels=7;

WITH CTE AS (

SELECT c.DeviceID AS Start,CAST(d.DeviceName AS VARCHAR(1000)) AS Path, c.ConnectedDeviceID, 1...

What are your expected results?

See if this helps

WITH CTE AS (

SELECT [Date],StaffId,ClientId,

ROW_NUMBER() OVER(PARTITION BY StaffId,ClientId ORDER BY [Date]) AS rn

FROM dbo.Visits)

SELECT a.StaffId,a.ClientId

FROM CTE...

Cadavre (11/14/2011)

---

Let me start again, because I'm sure that I'm attempting to over-complicate this with my lack of XML knowledge.

Take this XML: -

<Message>

...