hi jeff 

My reasons ..

1)  For small amounts of data

2)  something different

3)  easy to understand .. how to  code ... 

HI 

THIS IS A DIFFERENT WAY OF DOING THIS
EXPERTS CORRECT ME IF I AM MISSING ANYTHING

🙂
🙂

DROP TABLE EMP_CLIENT
GO
CREATE TABLE EMP_CLIENT(
ID INT  NOT NULL,
NAME...

hi 

 A DIFFERENT WAY OF DOING THIS .....

HOPE IT HELPS
🙂
🙂

drop TABLE SampleTable
go

CREATE TABLE SampleTable(
Id int,
Diagnosis1 int,
Diagnosis2 int,
...

HI 

ANOTHER WAY OF RESOLVING THIS

USING RECURSIVE CTE
-- GENERALLY RECURSIVE CTE IS NOT GOOD FOR PERFORMANCE

IF IT HELPS GREAT
🙂
🙂

DROP TABLE #SampleData
go

CREATE...