Thank you so much!!

That's what i always thought, from a users perspective speed is the only factor.

During an interview I was asked apart from reducing speed, what else does a developer need...

Thank you so much for the reply! I was able to reduce the time to 1 second with the following query. I am not sure why this takes 1 second...

Thank you for the reply!! the execution plan has real table names, which is why i did not post the full plan earlier. The image attached is the only...

The number of duplicates can go to a number sometimes greater than 50.

Could you please let me know how to build a comma separated list of names that share the...

Thank you so much for the reply!! that did work but Could you please let me know a way to display the output in the following way:

I am not...

I added the order by clause at the end, it worked.. but plz check the code and let me know of any more changes if required.

Thank you all so much for your replies, it really helped me a lot!!!!!

I added more conditions to the code, I am getting the correct result, but could you please...

I apologize for not being clear; yes i do want the code to execute with the commented lines;

--cast( (Insumpo / InSum ) as decimal (20,4)) as sp,

--CAST(incountpo/invcount)as decimal(20,4))as tp

but...

Hello shield_21

Thank you for your reply and time; but it is only showing the output for walmart and doesnt show macys in the output after inserting the row as you...

First of all thanx of the quick reply.

Could someone please let me know how would I get the following result;

Table clientvendor

clientid vendorid (composite primarykey)

1 1

1 2

1 3

1 4

1 5

2...