TSQL Challenge 14 - Logic Testing
Wed, 12/16/2009 - 18:03 — jacob
Here is the data used for the logic testing of the solutions (The credit goes to Brad Schulz)
declare @t table (Data varchar(40)) insert @t SELECT '9992EDC6-D117-4DEE-B410-4E5FAE46AE97' UNION ALL SELECT '0BFC936B-BD9A-4C6A-AFB2-CF3F1752F8B1' UNION ALL SELECT '4A73E7EB-7777-4A04-9258-F1E75097977C' UNION ALL SELECT '5AAF477C-274D-400D-9067-035968F33B19' UNION ALL SELECT '725DA718-30D0-44A9-B36A-89F27CDFEEDE' UNION ALL SELECT '8083ED5A-D3B9-4694-BB04-F0B09C588888' union all select '07777770-BAAB-CDDC-EFFE-553553553553' union all select 'AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF' union all select '00000000-0000-0000-0000-000000000000' union all select '01234567-89AB-CDEF-0123-4567890ABCDE' union all select '33333331-FEEE-FEEE-FEEE-1234567890AB' union all select '00000001-2223-4445-6667-888888888889' union all select '01010101-0101-0101-0101-777777777701' union all select 'EDDDDDDD-1234-5678-9876-ABC555555555' union all select 'FEDCBA98-7654-3219-ABCD-0123456789AA' ; /* Data ---------------------------------------- 9992EDC6-D117-4DEE-B410-4E5FAE46AE97 0BFC936B-BD9A-4C6A-AFB2-CF3F1752F8B1 4A73E7EB-7777-4A04-9258-F1E75097977C 5AAF477C-274D-400D-9067-035968F33B19 725DA718-30D0-44A9-B36A-89F27CDFEEDE 8083ED5A-D3B9-4694-BB04-F0B09C588888 07777770-BAAB-CDDC-EFFE-553553553553 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF 00000000-0000-0000-0000-000000000000 01234567-89AB-CDEF-0123-4567890ABCDE 33333331-FEEE-FEEE-FEEE-1234567890AB 00000001-2223-4445-6667-888888888889 01010101-0101-0101-0101-777777777701 EDDDDDDD-1234-5678-9876-ABC555555555 FEDCBA98-7654-3219-ABCD-0123456789AA */
Here is the output expected from the above input data
data char pos len ---------------------------------------- ---- ---- ---- 00000000-0000-0000-0000-000000000000 0 1 8 00000000-0000-0000-0000-000000000000 0 10 4 00000000-0000-0000-0000-000000000000 0 15 4 00000000-0000-0000-0000-000000000000 0 20 4 00000000-0000-0000-0000-000000000000 0 25 12 00000001-2223-4445-6667-888888888889 0 1 7 00000001-2223-4445-6667-888888888889 2 10 3 00000001-2223-4445-6667-888888888889 4 15 3 00000001-2223-4445-6667-888888888889 6 20 3 00000001-2223-4445-6667-888888888889 8 25 11 01010101-0101-0101-0101-777777777701 7 25 10 EDDDDDDD-1234-5678-9876-ABC555555555 D 2 7 EDDDDDDD-1234-5678-9876-ABC555555555 5 28 9 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF A 1 8 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF B 10 4 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF C 15 4 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF D 20 4 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF E 25 6 AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEFFFFFF F 31 6 33333331-FEEE-FEEE-FEEE-1234567890AB 3 1 7 33333331-FEEE-FEEE-FEEE-1234567890AB E 11 3 33333331-FEEE-FEEE-FEEE-1234567890AB E 16 3 33333331-FEEE-FEEE-FEEE-1234567890AB E 21 3 07777770-BAAB-CDDC-EFFE-553553553553 7 2 6 07777770-BAAB-CDDC-EFFE-553553553553 A 11 2 07777770-BAAB-CDDC-EFFE-553553553553 D 16 2 07777770-BAAB-CDDC-EFFE-553553553553 F 21 2 07777770-BAAB-CDDC-EFFE-553553553553 5 25 2 07777770-BAAB-CDDC-EFFE-553553553553 5 28 2 07777770-BAAB-CDDC-EFFE-553553553553 5 31 2 07777770-BAAB-CDDC-EFFE-553553553553 5 34 2 8083ED5A-D3B9-4694-BB04-F0B09C588888 B 20 2 8083ED5A-D3B9-4694-BB04-F0B09C588888 8 32 5 4A73E7EB-7777-4A04-9258-F1E75097977C 7 10 4 4A73E7EB-7777-4A04-9258-F1E75097977C 7 34 2 9992EDC6-D117-4DEE-B410-4E5FAE46AE97 9 1 3 9992EDC6-D117-4DEE-B410-4E5FAE46AE97 1 11 2 9992EDC6-D117-4DEE-B410-4E5FAE46AE97 E 17 2 5AAF477C-274D-400D-9067-035968F33B19 A 2 2 5AAF477C-274D-400D-9067-035968F33B19 7 6 2 5AAF477C-274D-400D-9067-035968F33B19 0 16 2 5AAF477C-274D-400D-9067-035968F33B19 3 32 2 725DA718-30D0-44A9-B36A-89F27CDFEEDE 4 15 2 725DA718-30D0-44A9-B36A-89F27CDFEEDE E 33 2 FEDCBA98-7654-3219-ABCD-0123456789AA A 35 2
Subscribe
