select distinct name,salary

into #temptab

from tablename

truncate table tablename

insert into tablename

select name,salary from #temptab

regards

1. If you take the full backup and truncate the transaction log  without taking its backup you can recover your database only to the point of full backup and not...

Thanks for your suggestions

Best regards

Try this:

select sum(col1) as sum from

(select [Net P&L] as col1 from tblTraderPnL union select Fee as col1 from tblTraderFees)  as dertab

regards

Sanjay, India

When a customer does a partial payment of an invoice we generate a second invoice for remaining amount.And if again he pays partially a third invoice is generated and process...

No there is no maximum level of depth.

Ive gone through Microsoft article and it seems theres no way to do it by a single query.

Thanks for your reply, bytheway