Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select * from APIResponse Where CAST(CreatedDate AS DATE)=CAST('29 Jan 2020' as DAte)
- AND SubscriptionsResponse NOT LIKE '%"number":%'
- Select * from APIResponse Where CAST(CreatedDate AS DATE)=CAST('29 Jan 2020' as DAte)
- AND SubscriptionsResponse LIKE '%"accounts_receivable":{"number":%' AND ReferenceId IS NULL
- Select * from APIResponse Where CAST(CreatedDate AS DATE)=CAST('29 Jan 2020' as DAte)
- AND SubscriptionsResponse LIKE '%"number":null%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
