Thanks Nate, thats exactly what i want.

Thanks John, that's exactly the kind of result i'm looking for. I tried using Jo's convertion in the code, but it still gives me the same error. This is how...

Thanks John, but it brought this error: Arithmetic overflow error converting expression to data type datetime.

The adtime is nvarchar(8). please what can i do?

Thanks

thanks so much for your reply, it actually brought some of the records that has duplicate time, but it did not bring all of them, because i have so much...

may be i did not give you the full structure of the table, let me put it like this:

insert into tbl_radio (station, addate, adtime, duration, fk_stateid, fk_productid, fk_brandid) values

select 'b104',...

Thanks so much for your help Nate, it works so nicely. Please i have another chalenge, i have this data:

insert into tbl_radio (AdDate, AdTime, Station, Duration) Values (

select '12-12-2010', '09:08:05',...

Thanks so much nate, you solved the problem, Thanks, I was wondering if i can use the case inside the join such as

Select o.location, o.boardnumber, o.secs, o.amount

from tbl_outdoor o

...

Hi, your query runs well, but u did not put into consideration the else case for the 5000 amount

let me repost the code

update convertr$ set Amount = CASE convertr$.lenght

WHEN...

Hi Stewartc, thanks for your reply, my internet connection is misbehaving, but i'll get back to you later.

Thanks

Timotech

Hi Stewartc, thanks so much it worked. I appreciate.

I want to try some more experiment, i let u know if that works, then i want to ask, how do i...

Hi Chris thanks for all your help. please if i want to add a percentage column to the whole show, how do i do it, for example, for this inner...

Thanks so much, i've been able to discover my mistake, your codes formating were very helpful.

Thanks

Timotech

Hi Chris thanks for your previous help, please i tried this:

SELECT TOP (100) PERCENT

...

Hi All, Thanks all for your contributions, after trying some other experiments, i want to conclude that COALESCE does wonders.

Thanks all

Timotech

Hi bteraberry, after a few editing, it worked nicely, i'm trying some other experiment on it, if anything bumps up, i'll let you know.

Thanks so much.

Timotech.