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

need help with a query Expand / Collapse
Author
Message
Posted Sunday, February 9, 2014 1:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 9, 2014 1:53 PM
Points: 5, Visits: 8
So i ended up going with a union query that syncs grouped by carbon_copy_id and one without and it seems to be doing the job.

Thanks guys for getting me this far.
Post #1539589
Posted Sunday, February 9, 2014 1:43 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 1,074, Visits: 6,360
youresoshain (2/9/2014)
So i ended up going with a union query that syncs grouped by carbon_copy_id and one without and it seems to be doing the job.

Thanks guys for getting me this far.


You have some of the finest TSQL developers in the world trying to figure out your problem for you in the sustained absence of sample data and expected output from that data.
They've done their best (and they've made some astonishingly good guesses given the scant information they've been provided with).
Have you?
Think on this, the next time you're handed a spec with vital information missing. It's a two-way street.



Low-hanging fruit picker and defender of the moggies





For better assistance in answering your questions, please read this.




Understanding and using APPLY, (I) and (II) Paul White

Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Post #1539590
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse