Timeline for Help with my SQL Query
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 9, 2022 at 13:38 | vote | accept | GS65 | ||
| Aug 9, 2022 at 13:38 | comment | added | GS65 | THanks for the help I appreciate it! | |
| Aug 9, 2022 at 11:55 | comment | added | François Perret | @GS65 : Made some enhancements and added a test result : you should be good to go with this one. Also, you may not actually need a join on All Subscribers, except maybe to insert only existing subscribers. | |
| Aug 9, 2022 at 11:53 | history | edited | François Perret | CC BY-SA 4.0 |
added 196 characters in body
|
| Aug 9, 2022 at 7:59 | comment | added | GS65 | Only today which is weird (for my query) | |
| Aug 9, 2022 at 7:06 | comment | added | François Perret | Do you get timestamps from today and yesterday now ? | |
| Aug 8, 2022 at 22:47 | comment | added | GS65 | THanks - your query seems to look good. I actually wrote the below it returned more than double your query - both seem to have the same logic, have any idea why? SELECT DISTINCT O.subscriber_key, O.timestamp, O.data from abandoned_browse_1643376986 O JOIN ENT._Subscribers s ON O.subscriber_key = s.SubscriberKey WHERE cast(O.timestamp As Date) >= cast(DATEADD(day,-1,getdate() )As Date) | |
| Aug 8, 2022 at 20:42 | history | edited | François Perret | CC BY-SA 4.0 |
added 26 characters in body
|
| Aug 8, 2022 at 20:25 | history | answered | François Perret | CC BY-SA 4.0 |