Skip to content

Instantly share code, notes, and snippets.

@thecopy

thecopy/gist:45a63533707392c21eef948ce862abf6

Created June 12, 2016 16:29
Show Gist options
  • Save thecopy/45a63533707392c21eef948ce862abf6 to your computer and use it in GitHub Desktop.
Save thecopy/45a63533707392c21eef948ce862abf6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
USE "Server=localhost;Database=KardaNorm;Trusted_Connection=True;" as norm;
USE "Server=localhost;Database=KardaManual;Trusted_Connection=True;" as manual;
SOURCE s FROM manual.vbv.VBV_MATT_STYRKORT as matt
CHOOSE Namn, Falt
LOOKUP Namn as AggEnhetNamn, Id as AggId FROM INNER JOIN manual.vbv.AggregeringsEnhet as aggenhet ON aggenhet.AggregeringsEnhetID = matt.AggregeringsEnhetID
;
TARGET norm.vbv.Matt t
IDENTIFY USING s.Falt = t.Falt
MAP
(
Namn <- Namn,
AggregeringsTyp <- AggEnhetNamn
)
ALLOW: INSERT, UPDATE
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment