quote:

---

Originally posted by arkiboys

Hi,
I looked at the link. thanks
This is what i have now but the last part where there is a delete seems to be incorrect.
Can you see anything wrong with my steps please?

the error is:
The multi-part identifier "##t.Pricing_Source" could not be bound.

create table ##t(Pricing_Source nvarchar(10),VaR_Identifier nvarchar(50),Price_Date datetime,PX_Last float,id int not null identity) on [primary]
go

insert into ##t(Pricing_Source,VaR_Identifier,Price_Date,PX_Last)
select
Pricing_Source,
VaR_Identifier,
Price_Date,
PX_Last--,
--Count(*) as 'count'
from
tblPricesClean
group by
Pricing_Source,
VaR_Identifier,
Price_Date,
PX_Last
having count(*) > 1
--order by
--count desc
go
select * from ##t
go
Delete from ##t where id <
(Select Max(id) from ##t t
where t.Pricing_Source = t.Pricing_Source and
t.VaR_Identifier = t.VaR_Identifier and
t.Price_Date = t.Price_Date and
t.PX_Last = t.PX_Last)

---