-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path00. All Shop List Term 1620.sql
33 lines (29 loc) · 1.52 KB
/
00. All Shop List Term 1620.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
/*
====================================================================================================
Import Mark Related Tables 1620
====================================================================================================
*//*
----- Ingredient Branch 1610
SELECT * FROM [DeepSeaKingdom].[WE].[MarkIngredient_Branch_1610]
----- Ingredient Branch 1620
SELECT * FROM [DeepSeaKingdom].[WE].[MarkIngredient_Branch_1620]
----- Ingredient Branch 1630
SELECT * FROM [DeepSeaKingdom].[WE].[MarkIngredient_Branch_1630]
----- Family Loan 1610
SELECT * FROM [DeepSeaKingdom].[WE].[FamilyInLoan_1610]
----- Family Loan 1620
SELECT * FROM [DeepSeaKingdom].[WE].[FamilyInLoan_1620]
/* SELECT TOP 1 *
INTO [DeepSeaKingdom].[WE].[FamilyInLoan_1630]
FROM OPENQUERY([OPRO],'SELECT DISTINCT o.External_SYSTEM_id, o.NAME_DISPLAY FROM PS_N_SF_OUTSTAND o WHERE o.Department = ''YYS01'' AND o.Position = ''RS1'' AND o.ITEM_TERM = ''1630''')*/
*//*
====================================================================================================
Import Mark Tables 1620 -- Belum ada yang diimport
====================================================================================================
*//*
--Firmware
SELECT * FROM [Temporary].[WE].[Firmware_GalaxionMark_1620]
SELECT * FROM [Temporary].[WE].[Firmware_FamilyMarkZeroingCheating_1620]
SELECT * FROM [Temporary].[WE].[Firmware_FamilyMarkZeroingPresenceLab_1620]
SELECT * FROM [Temporary].[WE].[Firmware_FamilyMarkZeroingPresenceTheory_1620]
*/