Hi guys

I have a table with some data
eg

       dtime | dat1 | dat2 | dat3
2000-12-12 12:23:45.777 | 0.66 | 0.544| 7
2000-12-12 12:23:47.777 | 54 | 56 | 0.99
2000-12-12 12:23:50.777 | 210 | 44 | 212
2000-12-12 12:23:52.777 | 0.21 | 45 | 0.11
2000-12-12 12:23:58.777 | 12 | 0.24 | 75
2000-12-12 12:24:01.777 | 34 | 4 | 0.22
2000-12-12 12:24:05.777 | 54 | 785 | 45
2000-12-12 12:24:08.777 | 2 | 20 | 21
...


lets say i want to SELECT all the data in an interval of
5sec. not evrything in between but every 5seconds
can anyone help me

Look at the DATEPART function. It will take a little work but it is doable. For example, grab the first value, then use the DATEPART function to add 5 minutes to that value. Then loop through the results looking for that value. When found, use the DATEPART function again to add 5 minutes and loop again, repeating the process. There is probably a way to do this without looping, but this is just the first thing that came to mind.