TSQL Sudoku II
Learn how to solve Sudoku puzzles quickly with a TSQL Script.
Related Posts:
Puzzles and Daily Trivia May 14, 2019
Summiting that Technical Challenge Part II July 6, 2018
Passion, Challenges,...
2011-08-23
7 reads
Jason Brimhall
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes...
2011-08-22
683 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
6 reads
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing...
2011-08-19
1,598 reads
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing a follow-up to that. Alas the opportunity has passed...
2011-08-19
5 reads
Derived Table Column Alias
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know...
2011-08-18
915 reads
Derived Table Column Alias
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know what a derived table is and that you get...
2011-08-18
37 reads
TSQL Sudoku
I am a big Sudoku fan. Typically if I need a break, I will break out a Sudoku puzzle from...
2011-08-17
1,037 reads
TSQL Sudoku
I am a big Sudoku fan. Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android...
2011-08-17
10 reads
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,115 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
Forums
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
The string_agg function
Comments posted to this topic are about the item The string_agg function
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers