add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name)
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64)
Jul 25 2020 11:26:55
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
7 rows affected
3 rows affected
Event_Day Member_ID CV1 CV2 CV3 CV4
2021-11-05 183300 APP camp1 Trigger APP-camp1-Trigger
2021-11-14 183300 SEARCH camp4 Search SEARCH-camp4-Search
2021-11-04 193320 SEARCH camp5 Search SEARCH-camp5-Search
2021-11-08 193320 SEARCH9 camp5 Search SEARCH-camp5-Search
2021-11-06 193320 SEARCH2 camp6 Search SEARCH-camp6-Search
2021-11-07 193320 SEARCH1 camp7 Search SEARCH-camp7-Search
2021-11-10 141542 SEARCH1 camp7 Search SEARCH-camp7-Search
Date Purchase_Order_ID Membership_Number Order_Value
2021-12-07 0088 183300 29.34
2021-12-18 0180 193320 132.51
2021-12-04 0050 141542 24.35
Event_Day Member_ID CV1 CV2 CV3 CV4 Date Purchase_Order_ID Membership_Number Order_Value rnk
2021-11-10 141542 SEARCH1 camp7 Search SEARCH-camp7-Search 2021-12-04 0050 141542 24.35 1
2021-11-05 183300 APP camp1 Trigger APP-camp1-Trigger 2021-12-07 0088 183300 29.34 1
2021-11-04 193320 SEARCH camp5 Search SEARCH-camp5-Search 2021-12-18 0180 193320 132.51 1
Event_Day Member_ID CV1 CV2 CV3 CV4 Date Purchase_Order_ID Membership_Number Order_Value
2021-11-10 141542 SEARCH1 camp7 Search SEARCH-camp7-Search 2021-12-04 0050 141542 24.35
2021-11-05 183300 APP camp1 Trigger APP-camp1-Trigger 2021-12-07 0088 183300 29.34
2021-11-04 193320 SEARCH camp5 Search SEARCH-camp5-Search 2021-12-18 0180 193320 132.51