Dynamically Build SQL Insert, Update and Delete Statements with Excel
In this article we look at how we can generate SQL Server INSERT, UPDATE and DELETE statements by dynamically building the statements using data and formulas within Excel.
Ohad Srur is the Managing Director of Data-Best based in Sydney, Australia, which is a consulting company that focuses on assisting to K-12 independent schools to improve their use of their technology systems. Ohad loves to develop database solutions, and wrangle with code and data to automate processes as much as possible. Ohad is a Microsoft Solution Expert (MCSE) Data Platform since 2016 and has been working with the SQL Server stack since 2011. Other than SQL Server stack, he likes to work with PowerShell and Python.
Use Excel Parameters to Dynamically Export SQL Server Data
In this article we look at how to load data into Excel from SQL Server using parameters to fetch the data to dynamically build the dataset.
SSRS Empty Report from a Data Driven Subscription
In this article we look at how to control not sending blank SSRS reports for data driven subscriptions.