I've just searched...

😀

Agreed. The trick is to replace all...

I guess your google is broken.

"A recursive query is one in which a CTE references itself."

http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/%5B/url%5D

-- Data

declare @x xml

set @x = '<ROOT>

<Customers>

<CustomerID>1111</CustomerID>

<CompanyName>Sean Chai</CompanyName>

<City>NY</City>

<Order OrderID="1" />

<Order OrderID="2" />

</Customers>

<Customers>

...

Nice feedback - thank you 🙂

Hi vsjayashri

Can't see your xml 🙁

Try replacing every < with &lt; and repost...

Can't see your example, but this works...

DECLARE @x XML

SET @x = '<root><a><b /></a><c d="e" /></root>'

SET @x = @x.query('root/*')

SELECT @x

/* Results

<a><b /></a><c d="e" />

*/

Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100959

It's a bit tricky to tell what's what, but try something like this...

c.reportrundate as Day1

,a.MaterialNumber

,a.MaterialDescription

,a.MaterialGroup

,max(Case

When a.plant = 'DC15' then a.unrestrictedstock

end) as Day1LDCStock

,max(Case

...

Yep - you need something to identify the order. An identity field will do it, for example...

-- Data

CREATE TABLE MyTable (

ident int identity(1, 1), --<----- you need this

...

Using DATALENGTH rather then LEN will fix this 🙂

Something like this...

declare @d1 datetime

declare @d2 datetime

declare @d3 datetime

declare @d4 datetime

set @d1 = '02/Nov/06 9:14:21 AM'

set @d2 = '19/Apr/07 11:52:31 AM'

set @d3 = '02/dec/07 12:14:21 AM'

set @d4 = '19/jan/08 5:52:31...

It looks like you're happy, so just to mention in passing that there are circumstances where 'ON DELETE CASCADE' would be an alternative. Here's an example...

--Structure

CREATE TABLE t1 (Id INT...

Or...

select dateadd(hour, datediff(hour, 0, acc_dt), 0) as dt, sum(acc_count) as total_cnt

from Acc_count group by dateadd(hour, datediff(hour, 0, acc_dt), 0)