Skip to content

Instantly share code, notes, and snippets.

@xavierzwirtz
Created January 28, 2020 23:40
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save xavierzwirtz/c9fdb25d048b92a8fb5c9cf6973ca0f8 to your computer and use it in GitHub Desktop.
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