The textbooks say writing your own loops in relational database code is something to be avoided.  Are you sure it's necessary to write loops?

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update...

To generate sample data you could use a Tally table and calculate a datetime column.  This generates 400 rows and calculates a column 'sample_dt' which starts with the current...

• This reply was modified 3 years ago by Steve Collins.
• This reply was modified 3 years ago by Steve Collins.

Interesting and much appreciated.  Happy Thanksgiving!

If you load up one of the strings with a bunch of commas it causes an error afaik.  JSON doesn't care how many commas in a row.  A tiny point...

Comma is not an escape character in JSON (towards the bottom of the page) 😉

https://www.json.org/json-en.html

The "application" is out of support and yet the database is separate and updatable?  If at all possible I wouldn't touch a single thing.   If something breaks... better to treat...

Jeff's code seems to generate primary keys and produces the correct output afaik.  Creating foreign keys should be straightforward for the OP.  The split could be accomplished with OPENJSON without...

Why does this make sense?  CONVERT using style 2 seems to convert to text and removes the leading '0x'

select Modelnameid origignal
      ,cast(SUBSTRING(Modelnameid...

A good first step could be to run this code

select datepart(weekday, cast(getdate()+nums.n as date)) day_of_week_number, 
       datename(weekday, cast(getdate()+nums.n as date)) day_of_week
from...

Maybe you're looking for the SUM OVER the volume partitioned by the 'parent_id' column but which column is appropriate to ORDER BY?  If ORDER BY the 'filter_path' column it causes...

It's true.  It's available in Azure SQL compatibility level 150 (and above) and SQL Server 2022.  There are alternatives such...

drop table if exists #some_table;
go
create table #some_table (
  input_string varchar(200) not null);

insert #some_table(input_string) values
('5,1,6,1,69,1'),
('5,1,6,1,3,2,5,3,69,1');

select string_agg(iif((ss.ordinal-1)%2=0, concat('''', ss.[value], ''''), ss.[value]), ',')
      ...

Maybe something like this

drop table if exists #some_table;
go
create table #some_table (
  full_name_proper varchar(200) not null);

insert into #some_table values
('A'),
('A B'),
('A B C'),
('A B C D'),
('A B C...

You could try OPENJSON and provide the 2 column schema definition

declare @json           nvarchar(max)=N'[{"display":"Section1","value":"1"},{"display":"Section2","value":"2"}]';

select oj.[value], oj.display
from openjson(@json) 
...