problem solved by changing the date format

thanks

Thanks a lot for the replies..

The problem is solved . I just run the script of database from 2008 and run it on 2005 by using the magical Sqlcommand...

Hi,

this migh help

Select distinct * from table

Where Date =DATEADD(minute,-120,getdate())

Hi mike ,

I use dhte query u suggested and got the output

A_DATE CODE B_DATE CODE

JuneAJulyA

JulyANULLNULL

JuneBJulyB

JulyBNULLNULL

JuneCNULLNULL

Is it need the out put as

A_DATE ...

Thanks for all replies

i m new to sql queries. would u plz explain what is

cte

for what purpose it is used for..

Thanks