Thank you 🙂

Yes the MAX(ID) does do that, thanks.

This code does not...

SELECT t1.*,

PrevId = t2.ID,

PrevSub = t2.Sub,

...

IF OBJECT_ID('tempdb..#Data') IS NOT NULL DROP TABLE #Data;

create table #Data([ID] [Int],[Sub][Int], [Data][Int])

INSERT INTO #Data ([ID], [Sub],[Data]) VALUES (1,1,102)

INSERT INTO #Data ([ID], [Sub],[Data]) VALUES (2,1,65)

INSERT INTO #Data ([ID], [Sub],[Data]) VALUES (3,1,85)

INSERT...

Thanks

What I am after is a date that has day, month, year, hour, minutes and secound in it that goes from an tSQL export to a "," csv file,...

This is the format that a report I have exports to excel. I am just try to replicate it.

How do I get .AM or .PM ??

Do i have to...

wow Thanks !:-)

Thanks Ho:-) ho:-D ho:-)

Thanks good advice..:-)

How does one rebuild an index..??

and YEs the symbols are out of order, but dates are not !

thanks 😀

Thanks Jeff..

Progress has been good since our last chat !:-):-D:-)

IF OBJECT_ID('tempdb..#Data') IS NOT NULL DROP TABLE #Data;

create table #Data([ID] [Int],[Sub][Int], [Data][Int])

INSERT INTO #Data ([ID], [Sub],[Data]) VALUES (1,1,102)

INSERT INTO #Data ([ID], [Sub],[Data]) VALUES (2,1,65)

INSERT INTO #Data ([ID], [Sub],[Data]) VALUES (3,1,85)

INSERT...

I remember the more friendly days...I am sure as hell NOT doing home work, I am an old fart struggle with TSQL !:cool:

Come on be kind !

What for... I have ID as a count down, How's ROW_NUMBER() gonna make a diff ???

All I need is a guru to spend 1 sec of his time to post...

Thanks again , just save me a 40 minute run !:-)