Skip to content

Instantly share code, notes, and snippets.

@alaawahbah

alaawahbah/Sql Technique.sql

Created August 16, 2019 13:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alaawahbah/52f83b18f4b2466117ec464111f2f863 to your computer and use it in GitHub Desktop.
Save alaawahbah/52f83b18f4b2466117ec464111f2f863 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Sql Technique.sql
-- SELECT * FROM Filters WHERE JSON_VALUE(FilterParameters, '$.Name') = N'PaymentType'
SELECT * FROM Filters f CROSS APPLY OPENJSON (FilterParameters) with (
[name] VARCHAR(Max),
[value] VARCHAR(Max)) j
--where j.name = 'PaymentType'
--WHERE JSON_VALUE(FilterParameters, '$.Name') = N'PaymentType'
select * from Ads CROSS APPLY STRING_SPLIT(CategoryPath, ',')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment