Centralized data.accdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) m →2015-Nov-18: m |
Ttenbergen (talk | contribs) m →2016-Mar-03: m |
||
| Line 3: | Line 3: | ||
==2016-Mar-03== | ==2016-Mar-03== | ||
not rolled yet Ttenbergen 10:51, 2016 March 3 (CST) | not rolled yet Ttenbergen 10:51, 2016 March 3 (CST) | ||
* ran following to fix blank ids in | * ran following to fix blank ids in [[L_TmpV2]]: | ||
UPDATE L_TmpV2 SET L_TmpV2.D_Tmp_ID = [d_id] & "_ccusrvman" & Minute([obstime]) & Second([obstime]) | UPDATE L_TmpV2 SET L_TmpV2.D_Tmp_ID = [d_id] & "_ccusrvman" & Minute([obstime]) & Second([obstime]) | ||
WHERE (((L_TmpV2.D_Tmp_ID) Is Null) AND ((L_TmpV2.Project)="CCU_Service")); | WHERE (((L_TmpV2.D_Tmp_ID) Is Null) AND ((L_TmpV2.Project)="CCU_Service")); | ||