Project Legacy HSC CCU Loc: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 20: | Line 20: | ||
== Data Transition == | == Data Transition == | ||
* add the relevant lines to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT) | * add the relevant lines to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT) | ||
{{Discuss | who = Pagasa | {{Discuss | who = Pagasa | | ||
* Please transition this data from the [[R_Filter Field]] field. The following query should do it. | * Please transition this data from the [[R_Filter Field]] field. The following query should do it. [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT) | ||
}} | |||
INSERT INTO L_TmpV2 ( D_ID, Project, Item ) | INSERT INTO L_TmpV2 ( D_ID, Project, Item ) | ||
SELECT L_Log.D_ID, "Legacy HSC CCU Location" AS Project, L_Log.R_Filter AS Item | SELECT L_Log.D_ID, "Legacy HSC CCU Location" AS Project, L_Log.R_Filter AS Item | ||
FROM L_Log | FROM L_Log | ||
WHERE (((L_Log.R_Filter) In ("H", "B", "HB", "BH"))); | WHERE (((L_Log.R_Filter) In ("H", "B", "HB", "BH"))); | ||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||