>Hi Yew,
>
>in addition to James' suggestion of using datepart in the query, SQL2008 does in fact have a date column type:
http://www.sqlteam.com/article/using-the-date-data-type-in-sql-server-2008. Since you are using SPT, you are probably not updating the cursor (by setting the cursor properties to support buffering, etc.), so datepart ought to work for you.
>
>hth,
>
>Hank
>
Hank,
How are you suggesting to use datepart in this query?
If it's not broken, fix it until it is.
My Blog