Hi Chat,

Thanks a lot...

you simply solved. my brain not worked at that moment 🙁

Thanks & Cheers.

Hi,

That's amazing... its working ... thanks a lot...

Thanks a lot for all your suggestions.

My management planned to get the license from Oracle. So if they implement the oracle i need to migrate the SQL to Oracle. SO...

Thanks Andrew.

Your script more helpful. Your answer reaching nearer.

I need to merge only particular hour. ie i need to merge everyday 2330 hrs data with 2300 hrs data and summed...

Hi,

here i'm giving in detail

create table dbo.tblCount

(

ctID int(3) not null,

ctDate DateTime,

CtCount int

)

Insert into tblCount (ctId, CtDate, CtCount) Values (1,'20110210 10:00:00', 23)

Insert into tblCount (ctId, CtDate, CtCount) Values (1,'20110210 10:30:00', 40)

Insert...

HI,

Thanks for reply and sorry for late reply, Here the DDL

Update tblCount SET count=(select count from tblCount where id='10' and date='20110229 10:00:00') WHERE id='10' and date='20110220 10:00:00'

the output is...

HI,

Thanks for reply,

I got the result

Here i used to convert dateandtime from character string.

Select [highlight=#ffff11]CONVERT(DATETIME[/highlight],CONVERT(varchar(8), ctdate, 112)+

convert(varchar(2), Datepart(hh, CtDate))+'00'+'00' ,[highlight=#ffff11]102)[/highlight]as CtDate ,

from Testing

group by CONVERT(varchar(8), ctdate, 112),...

HI,

Thanks for your kind reply.

Still i find difficult to get out the output.

Any other ideas,

Thanks

HI,

Thank you so much. i got the result.

And one more help.

i want to update the same table to Hour slot

For eg,

1/20/2011 12:00 and 1/20/2011 12:30 this need to...

Hi,

sorry i'm new to this... i dono that much.

Could you kindly explian little more

Thanks