Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
2,841 reads
bevan ward
Solve Sudoku with T-SQL - Part 1
A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.
2018-02-20
3,555 reads
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
2018-01-18
2,697 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Error message in launching web service url in sql report server
I am getting the following error when I launch web service url in sql...
Report server login issue
Trying to deploy reports in visual studio 2022, reporting service login is asking for...
Opening and closing with date filter is not giving me correctly output
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...
Ask SSC