Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Multiple values in some columns single value in another Expand / Collapse
Posted Monday, September 17, 2012 4:58 AM



Group: General Forum Members
Last Login: Yesterday @ 3:08 PM
Points: 21,187, Visits: 33,689
eamonn.byrne (9/17/2012)
Jeff Moden (9/16/2012)
eamonn.byrne (9/14/2012)
Yep that definately works. It took you 5 seconds to fix what had me scratching my head for a couple of hours.


Before you use it, Joe is right.

1. What is the key here? Is it just EmgID or is it EmgID and Reference together.

2. Regardless of what the answer to 1 is, is there anything special you want done for an EmgID with multiple Reference values?

Thanks for the further replies gus and apologies if I wasn't clear. Yes the key is the combined EMGID and Reference fields. Lynn was on the money though and I was able to work out the rest of what I needed from what she provided.


Glad I could help. One small thing, I am not a she, I am a he.

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1360101
Posted Monday, September 17, 2012 5:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 2:30 AM
Points: 5, Visits: 45
Oops. Sorry!
Post #1360121
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse