Ok I think I did this correct.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

--===== Create the test table with

CREATE TABLE #mytable

(

GrpID INT,

GrpName TEXT,

PrvID INT,

PrvName TEXT,

Spc TEXT,

)

--===== Setup any special required conditions especially where dates are concerned

--===== All Inserts into the IDENTITY column

SET IDENTITY_INSERT #mytable ON

--===== Insert the test data into the test table

INSERT INTO #mytable

(GrpID, GrpName, PrvID, PrvName, Spc)

SELECT ‘1234’,‘Med Associates’,‘’,‘’,‘Mixed’ UNION ALL

SELECT ‘1234’,‘Med Associates’,‘6875’,‘Bill Ham’,‘Cardiology’ UNION ALL

SELECT ‘1234’,‘Med Associates’,‘3274’,‘Sarah Jones’,‘Cardiology’ UNION ALL

SELECT ‘8975’,‘Pulm Associates’,‘’,‘’,‘Mixed’ UNION ALL

SELECT ‘5781’,‘Babies Inc’,‘’,‘’,‘Pediatrics’ UNION ALL

SELECT ‘6321’,‘ABC Therapy’,‘’,‘’,‘Mixed’ UNION ALL

SELECT ‘6321’,‘ABC Therapy’,‘4925’,‘Tate Silverman’,‘Physical Therapy’ UNION ALL

SELECT ‘6321’,‘ABC Therapy’,‘3274’,‘Sarah Jones’,‘Occupational Therapy’ UNION ALL

--===== Set the identity insert back to normal

SET IDENTITY_INSERT #mytable OFF