By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2017 (RTM-CU9) (KB4341265) - 14.0.3030.27 (X64) Jun 29 2018 18:02:47 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) |
25 rows affected
24 rows affected
id | mon | tue | wed | thu | fri | sat | sun | MtgPat |
---|---|---|---|---|---|---|---|---|
1 | Y | Y | Y | Y | Y | Y | Y | M\T\W\T\F\S\S |
2 | N | Y | Y | N | N | Y | N | Tue\Wed\Sat |
3 | Y | N | Y | N | Y | N | N | Mon\Wed\Fri |
4 | N | N | N | Y | Y | Y | Y | Thu\Fri\Sat\Sun |
5 | Y | Y | Y | Y | N | Y | Y | Mon\Tue\Wed\Thu\Sat\Sun |
6 | N | N | Y | N | Y | Y | N | Wed\Fri\Sat |
7 | Y | N | Y | Y | Y | N | Y | Mon\Wed\Thu\Fri\Sun |
8 | Y | N | Y | Y | N | Y | N | Mon\Wed\Thu\Sat |
9 | Y | N | N | N | N | Y | N | Mon\Sat |
10 | N | N | Y | Y | N | N | N | Wed\Thu |
11 | N | N | N | Y | N | Y | N | Thu\Sat |
12 | Y | N | Y | Y | Y | Y | N | Mon\Wed\Thu\Fri\Sat |
13 | Y | Y | Y | N | N | Y | N | Mon\Tue\Wed\Sat |
14 | Y | Y | N | Y | Y | N | N | Mon\Tue\Thu\Fri |
15 | N | N | Y | N | N | Y | N | Wed\Sat |
16 | Y | Y | N | Y | Y | Y | N | Mon\Tue\Thu\Fri\Sat |
17 | N | Y | Y | Y | Y | N | N | Tue\Wed\Thu\Fri |
18 | N | N | Y | N | Y | N | Y | Wed\Fri\Sun |
19 | N | Y | Y | N | N | N | Y | Tue\Wed\Sun |
20 | Y | Y | Y | N | N | Y | N | Mon\Tue\Wed\Sat |
21 | Y | Y | N | N | Y | N | N | Mon\Tue\Fri |
22 | Y | N | Y | Y | N | Y | N | Mon\Wed\Thu\Sat |
23 | N | Y | N | N | N | N | Y | Tue\Sun |
24 | N | N | N | N | N | N | N | null |
25 | Y | Y | Y | N | Y | N | Y | Mon\Tue\Wed\Fri\Sun |