Project Legacy HSC CCU Loc: Difference between revisions
Ttenbergen (talk | contribs) m Ttenbergen moved page Project Legacy Filter H B to Project Legacy HSC CCU Location without leaving a redirect: name as suggested by Julie |
Ttenbergen (talk | contribs) |
||
| Line 24: | Line 24: | ||
* transition this data from the [[R_Filter Field]] field. The following query should do it. | * transition this data from the [[R_Filter Field]] field. The following query should do it. | ||
INSERT INTO L_TmpV2 ( D_ID, Project, Item ) | INSERT INTO L_TmpV2 ( D_ID, Project, Item ) | ||
SELECT L_Log.D_ID, "Legacy | 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 (" | WHERE (((L_Log.R_Filter) In ("H", "B", "HB", "BH"))); | ||
}} | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||