Lowell,

could you please give me suggestion for..

if seconds=999999

then we can convert to time the result must be 277:46:39(hr:min:sec) ..

like that the earlier mail mentioned formula

DECLARE @seconds INT

SELECT @seconds =...

hi,

Thanks for replying ...

It is not working in all cases suppose the seconds is more than 100 hours its showing wrong .

Thanks,

Dastagiri.

delete from talbe where id not in (select max(column_id) from talbe group by column_name)

hi,

Thanks ..alot.....for u r reply...........Its working ........fine

hi,

my table data is ...

id Profesenalism Communication Customerservice profileid

1001 ...

thanks for helping ...it is working....

Thanks Lot...............

working fine

Thanks lot for all for replying this.

Dastagiri.D

hi,

I opened u r link and used script server roles code .its showing error at bellow code.

WHILE @@FETCH_STATUS = 0

BEGIN

????SET @SQLCmd = 'exec sp_addsrvrolemember...