Okey it seems working and also in a very fast way. But I have a another question. In section With ordered as( ) I have some values declared... and now I dont know where can I put Declare and Set variable.. Ah Ok I didnt have ";".. before With or after declarations So now it is perfect;)

modified on Monday, March 28, 2011 4:59 AM

Oh it is working;) thx.. but it is working for to long.... maybe another way? something like:

....
Datediff(seconds, datecolumn, (Delete first row from datecolumn and add at the end null))

Is there any possibility to do that? Because now I have almost the same searching in main query and subquery, and I think this main issue for this long working.

It isnt good solution. subquery returns one record for example first one. and Each record in datecolumn1 is compared to only one record from datecolumn2. I want to create some query that I will have data from datecolumn from ID 1 to 10, then create subquery to have data from the same datecolumn from ID 2 to 11, and then use datediff to obtain time delta between following records.

Hi I have a column where are values regarding to time. And In my query I want to add additional column where I will have delta between each record. So e.g. between one record and another remain 34 seconds. For this one I was trying to use DateDiff function, and compare my column with times to the same column but offset by one record. And there is the problem. It looks like date DateDIFF(seconds, column, [subquery]) and I have error that subquery return more than 1 value and it its not appropriate where are following; =, != or something like that. Do you have any ideas? how to manage this problem? Dnorus