Created
January 28, 2020 23:40
Star
You must be signed in to star a gist
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET deadlock_priority low | |
UPDATE bdtriggerauditiminvloc_sql | |
SET syncflag = 1 | |
WHERE ( auditid IN ( '7caa0b66-c3ec-4e33-9706-71c98ed01a30', | |
'fd6d2c24-8eb2-4dde-9a47-71c9bbc7f9d6' | |
, | |
'9d693302-dad5-4f3d-a33e-71c9c28d4bc1' | |
, | |
'4f8567c3-054f-4f77-b4ad-71ca16a18d89' | |
, | |
'e4d3893b-1b19-4bf3-8e18-71cae3ae8cbe', | |
'daadfc63-f48f-4426-851d-71cb278bdb21' | |
, | |
'19e71a18-847c-49b6-aa6e-71cb468b9781', | |
'0309fac8-1040-4fe8-82ec-71cbd609a63c' | |
, | |
'12a2314f-ecde-4e70-b75e-71cbe090616f', | |
'5ec73309-d817-46c4-9e30-71cbfa1f69c1' | |
, | |
'44743e9b-bd67-41dd-972d-71cc06f25d6e', | |
'cb2d2c93-9eaa-4e3a-917c-71cc0a4bc5e0' | |
, | |
'5e470ae4-1348-4867-9497-71cc6c972d80', | |
'1dc7c231-1422-4a08-925f-71cc82dbc1f5' | |
, | |
'6d80e4c8-6951-4912-88a7-71cc8a22e61e', | |
'2d0b7de3-f3cc-4a8b-8feb-71cca379158d' | |
, | |
'ea26410d-6180-41ca-8504-71ccca3efbe6', | |
'af22393b-130f-4a37-9c53-71cd2c6aa91a' | |
, | |
'2c112f23-9af7-4b6d-ad9b-71cd2dfd3793', | |
'54795c15-919e-48f7-b28e-71cd4ee258fd' | |
, | |
'fbcd1ec8-4108-4a31-ad45-71cd6b4ee8af', | |
'08b8f817-d760-42ee-9bd1-71cd8fb70e94' | |
, | |
'35afd65e-c966-49c5-8e92-71cdec06a11a', | |
'f574c0bb-8084-49e1-aa0b-71ce10ee644b' | |
, | |
'434b091a-52e3-4c60-80ca-71ce11b00b44', | |
'4272f7db-7987-40d3-864a-71ce22ef442c' | |
, | |
'79f84efc-55e3-407c-8e24-71ce3e4cfb03', | |
'5da4fc77-cf97-41ac-b604-71ce847a7a41' | |
, | |
'16d196cc-f92b-4b24-9ccd-71ce8eeab128', | |
'48fa8916-d4c0-4a9d-be22-71ce9b1cc82c' | |
, | |
'a632a6d0-d3ec-42b5-895d-71cf2b232594', | |
'2fb99ce3-b2b6-4daa-958e-71cf3a72e0f3' | |
, | |
'44ee2c8f-2f6b-4495-b6d8-71cf4fc93562', | |
'6c9614a6-0870-4b54-9a49-71cf5a2ceeff' | |
, | |
'890bdbc9-fa86-4ca4-b51f-71cf5c5a4028', | |
'f9112bd9-e22c-4be3-b369-71cf7923f5b8' | |
, | |
'49319474-4818-4821-8a7c-71cfa6ab3c13', | |
'e68ca41b-ee78-4a49-914c-71cfe5a84602' | |
, | |
'4ce429ba-6aec-4268-ac07-71d015960f23', | |
'5f25d74b-9598-48c6-9f08-71d0a0276706' | |
, | |
'65b490e1-8ff0-40c3-ad25-71d0b756e3be', | |
'1830bdb3-3f1e-4543-8ba7-71d0bc4f8569' | |
, | |
'347733b3-ebb8-4713-92e1-71d0bc725b65', | |
'e27b1e75-1648-4ad5-bf9e-71d0e2b7bf0e' | |
, | |
'ee180612-ff62-4ff4-8b83-71d0e703d16c', | |
'186fdb7e-2c29-46ad-80ee-71d0fb551448' | |
, | |
'9d7e6df0-7ed9-4948-be73-71d101b5f8d7', | |
'e2c65eff-3367-4b12-be9a-71d1436c9a6b' | |
, | |
'8731c9fb-2c20-4a3d-8d0e-71d176c09822', | |
'e6e645c9-accb-48ae-985a-71d18bb64b7b' | |
, | |
'04d990ab-25b0-4cf9-93a9-71d18c174c9e', | |
'd91f354d-029a-453f-9de4-71d2458de0c4' | |
, | |
'679c6939-f83e-457a-8ee9-71d284520de6', | |
'73da8173-8b3a-43cd-9c44-71d2a0c73ed2' | |
, | |
'67c5526d-d655-43e1-86e1-71d2a2eecbcb', | |
'7bf794ac-36f6-4bf8-b07c-71d2ca972e7c' | |
, | |
'df1b6e5a-e612-4f26-9551-71d2f5038a52', | |
'14bb4640-bc37-4cef-8bf3-71d2f6e9aa43' | |
, | |
'dbe2f233-b1f6-4b87-bcd4-71d30830e723', | |
'3e37ed21-07fa-4774-8df4-71d3282621f4' | |
, | |
'10440bab-ef62-4b7f-9ccb-71d36712b433', | |
'211ba861-f012-4841-bb8a-71d3f8dc8cb4' | |
, | |
'a3e4697e-d201-4e2b-ab00-71d3f940d336', | |
'f1cc295e-78f4-4434-8f52-71d41f5ecbf5' | |
, | |
'032792e2-532f-4140-9865-71d438c2484f', | |
'96005625-146c-49ed-8012-71d44e0a68f2' | |
, | |
'4d8d9754-8cbe-4d4c-a1b2-71d45076497c', | |
'f0788bf0-b80a-42f8-9481-71d46fc59e97' | |
, | |
'd4c6a94b-599b-427a-9fd5-71d48c1da84c', | |
'20be06a4-3e29-47d4-94fb-71d49fea71da' | |
, | |
'f78819e1-17fe-45e5-938e-71d4acead794', | |
'28d4bb48-c9b4-4ba5-92db-71d516bbccdb' | |
, | |
'9373692c-a3cc-4ba3-b5e5-71d51a8c2332', | |
'51a2c23c-0ce3-4af0-ad25-71d5412b1fe8' | |
, | |
'cc43c0b0-d60f-4bf3-9d0d-71d55a33f6e3', | |
'beced421-491f-4a88-b26e-71d56b0169c1' | |
, | |
'f9ad773f-a5ca-41a7-969d-71d5884dd16b', | |
'8cc1f472-bc73-45ec-b086-71d5c4035951' | |
, | |
'132a27b3-1a98-4a38-9978-71d60ee6612d', | |
'e07e89bb-1ba9-42a2-9dfe-71d618db4e00' | |
, | |
'6c2a6d9b-013e-4673-98bd-71d6239ef563', | |
'cb9adb36-ec91-404a-816f-71d639c4a81d' | |
, | |
'f7a17c98-2f48-4684-b6be-71d644e89047', | |
'b7acb9ee-e0fc-4de8-9cc5-71d64f875df6' | |
, | |
'ccc269f4-d70d-4fd6-bfb5-71d6511f3537', | |
'c48b8dd2-8365-4744-afe8-71d6537a91ba' | |
, | |
'1433cb8e-ad8c-49ee-b976-71d65d989f54', | |
'0131dcd2-be7e-47e0-9735-71d69a625a28' | |
, | |
'0c830859-4b30-4bab-a30c-71d6c082b938', | |
'5aceb369-b446-41ad-816f-71d6ccfe0c22' | |
, | |
'5ec20fc7-a0fe-456a-bee5-71d6eadfc79d', | |
'e518960e-7c34-46bf-aaa5-71d7155f3078' | |
, | |
'a5576f53-2b5e-4157-af58-71d73cfc14d5', | |
'575da3b0-04c9-4907-8a2e-71d7427ca987' | |
, | |
'95d3a27e-05f6-4887-a838-71d77b8bbc14', | |
'd3cce1a6-6306-445e-af92-71d7873480cd' | |
, | |
'fe7fdb19-3af6-40a0-a856-71d78982ca96', | |
'093a7cf8-c69a-41d2-882d-71d7ca5cbbba' | |
, | |
'3f085d14-bc3c-4fbe-9cbe-71d7ceb7fa2d', | |
'17b1907e-370c-4ec7-bc8d-71d8194df34f' | |
) ) | |
OR ( a4glidentity IN ( '437548', '490837', '370747', '497687', | |
'58745', '476617', '309170', '347994', | |
'407468', '485942', '76776', '1090', | |
'17565', '345646', '479023', '283589', | |
'328638', '78572', '447896', '19575', | |
'719482', '321039', '318422', '43967', | |
'461580', '454272', '6687', '353187', | |
'389789', '147088', '465073', '416941', | |
'456672', '494963', '435546', '106120', | |
'367788', '471540', '438223', '323207', | |
'461341', '452859', '496804', '298229', | |
'122497', '241419', '414622', '3447', | |
'449243', '445185', '42413', '443979', | |
'301797', '13582', '399248', '430353', | |
'442279', '313348', '502937', '474962', | |
'348672', '386328', '397520', '487303', | |
'65114', '72333', '391433', '386789', | |
'4508', '289431', '30146', '300474', | |
'488140', '468393', '43261', '329603', | |
'298446', '61324', '445735', '307473', | |
'13150', '756', '349997', '501522', | |
'72978', '368959', '458846', '442433', | |
'379063', '95351', '406557', '498024', | |
'409491', '322466', '471684', '311818', | |
'504942', '352074', '24713', '297225' ) ) | |
OPTION (maxdop 1) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment