not according to my required result:

20100,0

20200,0

30100,50

3000400,165

i think i might haven't made it clear, what i need is:

book_code,price where book_code of 1 resellerid has same price among all resellerid

in mySampleData only...

With mySampleData (id,resellerid,book_code,price,price_fixed,dis_perc,block_by)

AS

(

SELECT 1,44,20100,0,0,100,43 UNION ALL

SELECT 2,45,20100,0,0,100,0 UNION ALL

SELECT 3,46,20100,0,0,100,43 UNION ALL

SELECT 4,44,20200,0,0,100,43 UNION ALL

SELECT 5,45,20200,0,0,100,0 UNION ALL

SELECT 6,46,20200,0,0,100,43 UNION ALL

SELECT 7,44,30100,50,0,0,43 UNION ALL

SELECT 8,45,30100,50,0,0,43 UNION ALL

SELECT 9,46,30100,50,0,0,43 UNION ALL

SELECT...

thanks for your response, problem is still not solved with my actual data,

can you please give your email, so i can send you my actual data...

VSP (10/12/2011)

---

I may have misunderstood...

thanx for reply...i tried it for two resellers but it didn't successful, i have two resellerid ('10','15') both hav a book_code='40100', for resellerid=10 its price is 100, for resellerid=15 its...