Script to bulk Modify on account On-Test Status
NOTE: Make sure to Save Table before executing
/****** Script to SELECT AND UPDATE BULK ON TEST TO REMOVE ******/
-- SELECT * INTO TEMPTABLES..OUTSRVsv FROM OUTSRV
SELECT
C.[CONTID] AS 'CUSTOMER ID'
, O.*
FROM [MANITOU].[dbo].[OUTSRV] O
JOIN [MANITOU].[dbo].[CUSTOMER] C ON C.[SERIALNO] = O.[SERIALNO]
ORDER BY
O.[LSEQNO] ASC
/*
UPDATE O
SET [SRVEND] = GETDATE()
, [GSRVEND] = GETDATE()
FROM [MANITOU].[dbo].[OUTSRV] O
WHERE
-- [LSEQNO] < 9268 -- ENTER THE LSEQNO TO UPDATE EVERYTHING LESS THAN THE NUMBER
-- [SERIALNO] = 392 -- ENTER THE SERIALNO ASSOCIATED WITH THE CUSTOMER ID THAT CAN BE USED
*/
-- FIND OUT IF NOT IN GMT TIME
-- SELECT * FROM CONTACT WHERE CONTTYPE = 1 AND TIMEZONE <> 'GMT'
