pathuripr (9/18/2011)

---

The output should be the total quantity sold for each product and return a print statement that reads (as an example) a total of 7 monitor(s) were sold you...

suggestion...read up on GROUP BY / SUM et al

Hello

you have asked a sensible question....you have been asked to provide suitable scripts that willl assist someone on here to hopefully provide a solution to your pronlem.

At the moment only...

to help us help you...please post table creation / insert data /query scripts that will provide a representative sample of the data...based on the sample dat you provide, please provide...

deleted....think I may have misunderstood your requirements :ermm:

Hi simflex

to help us help you...please post table creation / insert data scripts that will provide a representative sample of the data...and allow us to use the query you...

😀

good luck.....post back if you get problems

SQL_Surfer (9/16/2011)

---

I need to traverse through each record in table and compare between the two records of the same table? Is there a better way of doing this instead of...

Jason

now you are spoon feeding .....:-P:-P:-P:-P

not sure why you are using SSIS...a TSQL possible solution below.

have a play around with this code.....seems therre are several posts recently relating to "fruit"....are you all on the same...

So Long, and Thanks for All the Fish

...sorry 😀

ok...so we now have some clarifcation on what you require.

Given this table of results, what...

zaleeu (9/12/2011)

---

Sorry for being ambigious ....

Ignore the | characters , that was just to seperate the data.

So, I need it to be

Paul Oranges ...

Hi Zaleeu

can you please clarify....do the results have to be in separate...

many thanks for clarification....