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,777 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,265 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,438 reads
Blogs
Daily Coping 17 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Migration of Data from one Database to Multiple Databases
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
AWS Beginner questions
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
How to get weekly and Monthly view from daily in sql server
Hello All, I have a table like below. I need to get daily,weekly and...
Ask SSC