Great thanks ..

ColumnName , need to extract the names  For  NAME="Table2 Col1" not the local-name(.)'
<C0 NAME="Table1 Col1" TYPE="String" />
<C1 NAME="Table1 Col2" TYPE="String" />
<C2 NAME="Table1 Col3" TYPE="String"...

Great thanks ..

Its useful to start with .,rather looking on each proc ..

Sorry, My mistake ..

it would be 20~50 sec , but it should be considered as one group

if greater than 3 min then the next group

The 1st group the date increments by~20-25 sec , and other by 4~5 min

DateS ...

Try http://sqlfiddle.com/

You can run SQL queries and get result on the fly

What was the logic for order 2 with all cancelled in detail , but overall as shipped

;WITH CTEStatusPriority (StatusPriority,StatusDesc)

AS

(

SELECT '1','NO STATUS' UNION

SELECT '2','CANCELLED' UNION

SELECT '3','BACKORDERED' UNION...

What was the Status Priority ?

say if an order details has

BACKORDERED

CANCELLED

SHIPPED

NO STATUS ., wat should be the overall ?

need some thing like

StatusPriorityStatusDesc

1NO STATUS

2CANCELLED

3BACKORDERED

4SHIPPED

That's clear to me now.. Thanks Chris

here was one of the way

CREATE table #temptable

(

id int,

PayCode char(2) null,

Amount decimal(15,2) null,

CDate date,

TranSeq int null

)

declare @C int,@max int

set

Thats Perfect Mark ..Thanks

Thanks for this update Jeff. Yeah I got exactly what you have expressed.

I have an question ,is there any alternative way to get all child in self referencing table....

Check this

http://beyondrelational.com/blogs/tc/archive/2009/08/30/tsql-challenge-13-break-a-batch-of-invoices-into-multiple-parts-based-on-rules.aspx

Perfect 🙂 ..Kudos Mark

WITH RECURSIVE CTE

CREATE TABLE #TestTable ([Index] int,[StartNumber] int,[Endnumber] int)

INSERT INTO #TestTable

SELECT 1,1000,1002 UNION ALL

SELECT 2,1550,1555

;WITH TableCte

AS

(

SELECT [Index],[StartNumber] ,[Endnumber] FROM #TestTable

UNION ALL

SELECT [Index],[StartNumber]+1 ,[Endnumber] FROM TableCte...

CREATE TABLE CustActivity

(CustNo INT ,

ActivityStartDate DATETIME ,

ActivityEndDate DATETIME ,

DiffHours INT ,

ActivityEnd INT )

INSERT INTO CustActivity (CustNo,ActivityStartDate,ActivityEndDate,DiffHours,ActivityEnd )

SELECT'42','12/21/2006 11:35','12/21/2006 13:40','1','0'UNION

SELECT'42','12/21/2006 14:10','12/21/2006 16:30','1','0'UNION

SELECT'42','12/21/2006 17:00','12/21/2006 18:15','0','0'UNION

SELECT'42','12/21/2006 18:45','12/21/2006 20:00','33','1'UNION

SELECT'42','12/23/2006 07:00','12/23/2006 10:00','0','0'UNION

SELECT'42','12/23/2006 10:30','12/23/2006 13:35','15','1'UNION

SELECT'42','12/24/2006...