-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path18. Overview Epitome Term 1620.sql
44 lines (38 loc) · 2.29 KB
/
18. Overview Epitome 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
34
35
36
37
38
39
40
41
42
43
44
;------------------------------
DECLARE @Term NVARCHAR(MAX) = N'1620'
,@WorkshopName NVARCHAR(MAX) = N'Firmware'
;------------------------------
DECLARE @QuarterSessionId NVARCHAR(MAX), @WorkshopId NVARCHAR(MAX)
;------------------------------
SELECT @QuarterSessionId = QuarterSessions.QuarterSessionId FROM Seaweed.dbo.QuarterSessions WHERE QuarterSessions.Period = @Term
;------------------------------
/**********************************************************************
* Update Final OnsiteTest Status
* Yang tampil atau diupdate datanya dari OnsiteTestPresenceVerification (View Pertama) dan AppendixSchedule (View Kedua)
* @WorkshopName kalau dikosongin check semua lab
* @UpdateRepeat = 1, kalau mau diupdate
* @UpdateRepeat = 0, kalau tidak mau diupdate
**********************************************************************//*
EXECUTE [WE].[SP_UpdateOnsiteTestPresencePresenceOnManualMarkSummary] @Term = @Term
--,@WorkshopName = 'Firmware'
,@Update = 1
*/
/******************************************************************************************
* Generate Required Data
******************************************************************************************//*
EXECUTE [WE].[SP_GenerateFamilyMarkSummaryGalaxy] @Term
EXECUTE [WE].[SP_GenerateFamilyPresenceSummary] @Term
*/
/******************************************************************************************
* Generate Mark Epitome Appendix (Lampiran)
******************************************************************************************/
/**********************************************************************
* Ambil Filenya di Drive D: [Atlantis]
\\DeepSeaKingdom\d$
* Check di Tab 'Messages' (Sebelah Kanan Tab Result - Grid Result)
-- Kalo misalnya length-nya = 8000, berarti udah mencapai batas string query-nya jadi ga ke export, maka store procedurenya jalanin execute query (copy hasil select terus masukin ke excel)
-- Kalo misalnya ada error di hasil tampilan select-nya ada row ke 8 biasanya. kalo berhasil cuman sampai 7 dan isinya null di row ke 7-nya
**********************************************************************//*
EXECUTE [WE].[SP_ExportOverviewReportLovelySiteIngredient] @Term
EXECUTE [WE].[SP_ExportOverviewReportGalaxyIngredient] @Term
*/