Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO [DEV_BI].dbo.[DimAktivitet]([Beskrivning],[företag],[Projektnummer],[Aktivitet],
- loaddate)
- SELECT NULL,
- a.DATAAREAID,
- a.PROJID,
- a.MID_ACTIVITYNUMBER,
- GETDATE()
- FROM [?].dbo.[v_ProjCostTrans_ProjEmplTrans] a
- LEFT OUTER JOIN [DEV_BI] .dbo.[DimAktivitet] b ON a.MID_ACTIVITYNUMBER = b.Aktivitet
- AND a.DataAreaID = b.företag
- AND a.ProjID = b.Projektnummer
- WHERE b.Aktivitet_key IS NULL
- insert into [DEV_BI].dbo.[DimAktivitet]([Beskrivning],[företag],[Projektnummer],[Aktivitet],loaddate)
- select null,a.DATAAREAID,a.PROJID,a.MID_ACTIVITYNUMBER,GETDATE() from
- [DEV_BI].dbo.[v_ProjCostTrans_ProjEmplTrans] a
- left outer join
- [DEV_BI] .dbo.[DimAktivitet] b
- on a.MID_ACTIVITYNUMBER = b.Aktivitet AND a.DataAreaID = b.företag AND a.ProjID = b.Projektnummer
- where b.Aktivitet_key is null
- AND b.SomeFilterCriteria = ?;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement