>>>>Is there a way to convert datetime to date fields in SPT cursor?
>>>
>>>Would TTOD() do what you want?
>>>
>>>SELECT TTOD(tMyDateTime) AS dMyDate...
>>
>>You can only use functions that the back end will understand for SPT. I think CONVERT() may be what's needed here.
>
>CONVERT() doesn't work either because SQL Server doesn't have a date datatype. I posted the same question a couple of days ago and the answer seems to be NO. You can do it with Remote Views, but not SPT cursors.
How many records in your result set? Would an extra SELECT with the TTOD() from the SPT result cursor into a new cursor be prohibitive?