Ok, I'll try to correct this problem at the end (Excel), and see what they think.

Thanks a lot both.

Luigi

Is a script task in a SSIS package, where from a datatable I create an output csv file.
And the user does not want to see 0,00 in this...

For example, if I have the value 1,23 I still have 1,23, but if I get 0,00 I should show 0.

Perfect, thank you very much Chris.

Luigi

I need to put everything (values for next and previous) in only one row, if possible.

Luigi

For example, if I pass the date '2012-07-02 10:00:00'

(more recent than any other record) I'd like to obtain something like this:

PreviousID - PreviousDateRef - NetxID - NextDateRef

25 2012-07-01...

In the case of one result set:

select id, dateref, groupid from

(

select top 1 id, dateref, groupid from test1 where dateref <= @testvar order by dateref desc

) prev

union all

select id,...

Thank you Koen, I'll try to disable the cache.

Luigi

Ah ok, so I have to re-format everything.

Thanks a lot.

Luigi

Ok, thanks you all.

Luigi

Thank you so much Grant

Luigi