For each selection SQL 2005

Question

The following query is used to fill a cursor. I only want one row in the cursor for each PlmName

I need the fields to process data within the cursor.

How do I load the cursor with one row of data related to PlmName?

SELECT DISTINCT  

           PNT.PlmName, 
           PNT.PlmEmail, 

FROM         OEM_PLM_TH_NOTE AS PNT INNER JOIN
                      OEM_PLM_OPRICE AS PPR ON PNT.PartID = PPR.PartID INNER JOIN
                      OEM_PLM_THRESHHOLD ON PNT.LicenseCode = OEM_PLM_THRESHHOLD.License_Code AND 
                      PPR.TotalCompPrice > OEM_PLM_THRESHHOLD.Threshhold_amt

Answer 1

0

It seems to me that the simplest way is to just take the email out of the select distinct clause. That should give you 1 row per name. Then to get the email, you can do a sub-select.

answered Sep 19 '12 at 07:32 PM

jjaroska
170 ● 2

(comments are locked)

For each selection SQL 2005

Follow this question

Related Questions