Guys, I too agreee that re-inventing the wheel is never a good option but then consider this where there are millions of historic transactions and the only way to cut...

--Sorry , here it is :

Create Table Invoice (InvoiceId nvarchar(10), SeqNo smallint, Product nvarchar(10), Amount int)

Go

Insert into Invoice

Values ('I1',1,'P1',10),('I1',2,'P2',15),('I1',3,'P3',25),('I2',1,'P1',15),('I2',2,'P1',35)

Create Table Payment (InvoiceId nvarchar(10), ReceiptId nvarchar(10), Amount int)

Go

Insert...

This is just a ExecuteSQLAgent task in SSIS which selects the job in the server which has that job . The task succeeds even thought the job fails. This...

Yeah agree.. but imagine if we have almost 500K pictures to convert .. What would be the best approach then ?

I am afraid I dont know .. thats the legacy data ..

Hi ,

Thanks , it does give the right results .

However, just to understand the code , what does the n%2 in the Where condition signify ?

thanks

It doesn't work this way !

Cheers Paul !! This is what I expected !

Cheers Paul ! This is what I expected !

I think you have not understood the requirement. Your CTE will give the difference between previous and current time. But the requirement is to get the time difference from the...

The logic seems to be to always select the first row (10:22 here), skip the second row because 12:15 is within 2 hours of 10:22, select 13:22 because it is...

Yes your analysis is right .

My SQL version is - SQL 2008 R2 - Enterprise

My real table has several million MID and the time type is currently varchar...