InCode Like A GirlbyLuchiana Dumitrescu·Aug 13Table-Valued Functions in SQL: Turning Requests Into Data TablesI’m pretty sure all of us know how going out for dinner works. And no, I’m not talking about all the preparations before leaving the house…
InCode Like A GirlbyLuchiana Dumitrescu·Jul 9SQL Cross Apply — When SQL Thinks Like a Recommendation EngineAh, online shopping is a blessing for us and a nightmare for our bank accounts (which is also ours, but the temptation is stronger🙃)A response icon1A response icon1
Mike K·Oct 10, 2024Querying Nested JSON Arrays in Synapse SQLUsing CROSS APPLY to evaluate arrays of arrays in JSON documents using Azure Synapse SQL
DotNet Full Stack Dev·Oct 8, 202420+ SQL Concepts with MS SQL Server CodeRevisit your SQL BasicsA response icon2A response icon2
Pavan Krishna·May 9, 2022Intermediate SQL FunctionsReal time work on sql some times demands functions beyond simple statements and these days my work is demanding sql functions beyond simple…
Glenn Herpoelaert·Aug 23, 2021Putting SQL Benchmarking to the Next Level with Cross ApplyExtending PERCENT_Rank() logic via Cross Apply
InSQL Lessons with Bert WagnerbyBert Wagner·Aug 15, 2017How to Eliminate Ugly Nested REPLACE() FunctionsSQL in 60 Seconds #4A response icon2A response icon2