SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Claims(
   ClaimID            INTEGER  NOT NULL PRIMARY KEY 
  ,ClaimDetailID      INTEGER  NOT NULL
  ,ServiceID          INTEGER  NOT NULL
  ,PSID               VARCHAR(4)
  ,Notes              VARCHAR(1033) NOT NULL
  ,StartTime          VARCHAR(23) NOT NULL
  ,EndTime            VARCHAR(23) NOT NULL
  ,Duration           INTEGER  NOT NULL
  ,ProvidedBy         INTEGER  NOT NULL
  ,LocationID         INTEGER  NOT NULL
  ,PatientPaidAmt     BIT  NOT NULL
  ,Billed             BIT  NOT NULL
  ,BilledAmt          NUMERIC(5,2) NOT NULL
  ,BilledDate         VARCHAR(4)
  ,BilledBy           VARCHAR(4)
  ,ClaimStatusID      VARCHAR(4)
  ,Paid               BIT 
  ,PaidAmt            NUMERIC(4,1)
  ,PaidDate           VARCHAR(23)
  ,PaidBy             INTEGER 
  ,Created            VARCHAR(23) NOT NULL
  ,CreatedBy          INTEGER  NOT NULL
  ,Modified           VARCHAR(16)
  ,ModifiedBy         INTEGER 
  ,OutcomeNotes       VARCHAR(4)
  ,GoalNotes          VARCHAR(109) NOT NULL
  ,CommunicationNotes VARCHAR(3) NOT NULL
  ,EquipmentNotes     VARCHAR(3) NOT NULL
  ,HealthNotes        VARCHAR(3) NOT NULL
  ,GOALS              VARCHAR(4)
  ,CURRENTGOALS       VARCHAR(293) NOT NULL
  ,Signatured         VARCHAR(4)
);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263698,138283,61,NULL,'Ricky woke up late. He came downstairs around 9:30 am.  He sat down and ate breakfast.  He appeared to be in a good state, not very anxious. After eating, Ricky hung out on the couch while I cleaned up the dishes.  I packed some orange slices and bottled water for our hike. Then we went to McConnell''s Mill for an extensive hike. We were in the caves and ravines, hiking along the trail for 3 hours. We snacked on the orange slices during our rests. Ricky did fantastic. He was always eager to explore the caves. Then we ate lunch and headed back home. Once home, Ricky showered and relaxed. He was spent after the hike. We watched a movie of his liking, then ate dinner. We played some Wii sports after the dishes were clean. He hung out with me until 9:30pm before going to his room.  His light was on until 11:45 and I could hear him laughing until his light was turned off. It was a good day with no signs of anger or much anxiety. He waved his hand twice when he was on the couch, but that was it.','2018-05-19 08:00:00.000','2018-05-19 11:00:00.000',12,99999,75,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-06-14 11:18:54.000',191,'2018-06-14 11:21',191,NULL,'see general notes','n/a','na/','n/a',NULL,'RICKY IS IN NEED OF 24 HOUR RESPITE SO THAT HE AND HIS PARENTS CAN HAVE A BREAK.  THERE IS ALOT OF STRESS ON THE FAMILY AT THIS TIME DUE TO A DRASTIC DECREASE IN RICKY''S SKILLS, ESPECIALLY IN THE LAST COUPLE MONTHS.RICKY IS IN NEED OF THIS SERVICE FOR RESPITE STAYS MORE THAN 2 DAYS AT A TIME.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263699,138284,61,NULL,'John slept in until 10am.  He was extremely tired when he came down for breakfast. After eating I tried to get John to go for a walk, but he said "No, I am fine".  Therefore, we hung around the house until lunch. We played Wii and watched TV. He had a couple laughing fits, but no angry outbursts. Then we ate and I was able to get him to agree to a walk around North Park. He was good for 1.5 hours before we went back home. On the walk we stopped a lot so Ricky could stare at the woods or off in the distance. Then we went home for dinner and a movie.  Ricky wanted to watch a comedy so we watched a Jackie Chan movie.  At night, Ricky showed no signs of anger or anxiety before retiring to his room for the night at 9:30om. I heard him talking and laughing at times, but he was not yelling at anyone or seem upset.','2018-05-19 08:30:00.000','2018-05-19 12:00:00.000',12,99999,75,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-06-14 11:25:35.000',191,NULL,NULL,NULL,'see general notes','n/a','n/a','n/a',NULL,'RICKY IS IN NEED OF 24 HOUR RESPITE SO THAT HE AND HIS PARENTS CAN HAVE A BREAK.  THERE IS ALOT OF STRESS ON THE FAMILY AT THIS TIME DUE TO A DRASTIC DECREASE IN RICKY''S SKILLS, ESPECIALLY IN THE LAST COUPLE MONTHS.RICKY IS IN NEED OF THIS SERVICE FOR RESPITE STAYS MORE THAN 2 DAYS AT A TIME.',NULL);

INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263700,138285,61,NULL,'Ricky stayed up late watching the Pittsburgh Pirates the night before so he slept in until 9:30am. He was moving a little slow, but his attitude was upbeat. After eating breakfast we went for a short 1.5 hour hike around Hartwood Acre. After the hike, which Ricky took few breaks during, we ate lunch back at the house. Then we met one of his friends at the Shaler Pool.  Ricky and his friend walked around in the pool together. Ricky would separate himself from his buddy and swim on his own, always returning through.  A few hours in the sun wore Ricky out; as we headed for home he took a nap in the car. He ate dinner then watched a movie with me. He sat on the couch and his attention drifted from his feet to the window to the TV.  He sat quietly until we went to a friend''s house to watch the UFC event. Ricky hung out with everyone, silently watching and occassionally getting up and walking across the room. He wanted to stay until 11:30.  Then we went home and he went to his room for bed. He did not even put on his light.','2018-05-26 00:00:00.000','2018-05-26 23:59:00.000',1,99999,75,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-06-14 11:34:23.000',191,'2018-06-14 11:35',191,NULL,'see general notes','n/a','n/a','n/a',NULL,'RICKY IS IN NEED OF 24 HOUR RESPITE SO THAT HE AND HIS PARENTS CAN HAVE A BREAK.  THERE IS ALOT OF STRESS ON THE FAMILY AT THIS TIME DUE TO A DRASTIC DECREASE IN RICKY''S SKILLS, ESPECIALLY IN THE LAST COUPLE MONTHS.RICKY IS IN NEED OF THIS SERVICE FOR RESPITE STAYS MORE THAN 2 DAYS AT A TIME.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263701,138286,61,NULL,'Ricky was extremely tired from his late night and busy day. He slept in until 10:30 am. When he woke up he was moving real slow. After some breakfast he had no desire to go for a walk. We had decided this was going to be a rest day so our planned trip to Kennywood would be fun. So we watched a couple of movies and played Wii for most of the day. After lunch around 2:00pm Ricky and I went for a walk up his street. Ricky was quiet and distant but he was extremely clam. He had no anger outbursts or giggle fits. Today was a laid back day in preparation for his eventful Memorial Day. After eating dinner around six Ricky and I finished watching Liar Liar. Ricky went to hed when the movie ended around 9:15pm and I didn''t hear him, but his light was on until 11:15pm','2018-05-27 00:00:00.000','2018-05-27 23:59:00.000',1,99999,75,0,1,260.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-06-14 11:44:04.000',191,NULL,NULL,NULL,'see general notes','n/a','n/a','n/a',NULL,'RICKY IS IN NEED OF 24 HOUR RESPITE SO THAT HE AND HIS PARENTS CAN HAVE A BREAK.  THERE IS ALOT OF STRESS ON THE FAMILY AT THIS TIME DUE TO A DRASTIC DECREASE IN RICKY''S SKILLS, ESPECIALLY IN THE LAST COUPLE MONTHS.RICKY IS IN NEED OF THIS SERVICE FOR RESPITE STAYS MORE THAN 2 DAYS AT A TIME.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263707,138289,57,NULL,'Reality Orientation - current events, daily news, open discussion.','2018-05-01 00:00:00.000','2018-05-01 23:59:00.000',1,99999,78,0,1,58.39,NULL,NULL,NULL,1,55.2,'2018-08-20 13:18:17.000',191,'2018-06-14 13:57:28.000',191,NULL,NULL,NULL,'Practice for the talent show.','n/a','n/a','n/a',NULL,'This service will provide Valerie with a structured day program to assist her in increasing skills such as reality awareness, spelling, communication, and fine motor control by completing crafts, group activities and exercise classes.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263708,138290,57,NULL,'Reality Orientation - current events, daily news, open discussion.','2018-05-02 00:00:00.000','2018-05-02 23:59:00.000',1,99999,78,0,1,58.39,NULL,NULL,NULL,1,55.2,'2018-08-20 13:18:17.000',191,'2018-06-14 13:59:02.000',191,NULL,NULL,NULL,'Wacky Math Wednesday, paint props for the talent show, make a spring craft - paper flower','n/a','n/a','n/a',NULL,'This service will provide Valerie with a structured day program to assist her in increasing skills such as reality awareness, spelling, communication, and fine motor control by completing crafts, group activities and exercise classes.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263709,138291,57,NULL,'Reality Orientation - current events, daily news, open discussion.','2018-05-03 00:00:00.000','2018-05-03 23:59:00.000',1,99999,78,0,1,58.39,NULL,NULL,NULL,1,55.2,'2018-08-20 13:18:17.000',191,'2018-06-14 13:59:41.000',191,NULL,NULL,NULL,'Practice for the talent show','n/a','n/a','n/a',NULL,'This service will provide Valerie with a structured day program to assist her in increasing skills such as reality awareness, spelling, communication, and fine motor control by completing crafts, group activities and exercise classes.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263710,138292,57,NULL,'Reality Orientation - current events, daily news, open discussion.','2018-05-07 00:00:00.000','2018-05-07 23:59:00.000',1,99999,78,0,1,58.39,NULL,NULL,NULL,1,55.2,'2018-08-20 13:18:17.000',191,'2018-06-14 14:01:14.000',191,NULL,NULL,NULL,'Spanish word practice. Dance integrated exercise, paint musical instrument.','n/a','n/a','n/a',NULL,'This service will provide Valerie with a structured day program to assist her in increasing skills such as reality awareness, spelling, communication, and fine motor control by completing crafts, group activities and exercise classes.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263711,138293,57,NULL,'Reality Orientation - current events, daily news, open discussion.','2018-05-08 00:00:00.000','2018-05-08 23:59:00.000',1,99999,78,0,1,58.39,NULL,NULL,NULL,1,55.2,'2018-08-20 13:18:17.000',191,'2018-06-14 14:02:18.000',191,NULL,NULL,NULL,'Pet therapy - dog visits with Milo.  Talent show practice. social development opportunity. Activity planning.','n/a','n/a','n/a',NULL,'This service will provide Valerie with a structured day program to assist her in increasing skills such as reality awareness, spelling, communication, and fine motor control by completing crafts, group activities and exercise classes.',NULL);
INSERT INTO Claims(ClaimID,ClaimDetailID,ServiceID,PSID,Notes,StartTime,EndTime,Duration,ProvidedBy,LocationID,PatientPaidAmt,Billed,BilledAmt,BilledDate,BilledBy,ClaimStatusID,Paid,PaidAmt,PaidDate,PaidBy,Created,CreatedBy,Modified,ModifiedBy,OutcomeNotes,GoalNotes,CommunicationNotes,EquipmentNotes,HealthNotes,GOALS,CURRENTGOALS,Signatured) VALUES (263712,138294,57,NULL,'Reality Orientation - current events, daily news, open discussion.','2018-05-09 00:00:00.000','2018-05-09 23:59:00.000',1,99999,78,0,1,58.39,NULL,NULL,NULL,1,55.2,'2018-08-20 13:18:17.000',191,'2018-06-14 14:03:23.000',191,NULL,NULL,NULL,'Social development opportunity, Mothers day craft, movie day, birthday party, talent show practice.','n/a','n/a','n/a',NULL,'This service will provide Valerie with a structured day program to assist her in increasing skills such as reality awareness, spelling, communication, and fine motor control by completing crafts, group activities and exercise classes.',NULL);

12 rows affected

ProvidedBy	ServiceStart	ServiceEnd	claimid	(No column name)	ClaimIDs	ClaimDetailIDs	serviceids
99999	2018-05-01 00:00:00.000	2018-05-01 23:59:00.000	263707	138289	263707	138289	57
99999	2018-05-02 00:00:00.000	2018-05-02 23:59:00.000	263708	138290	263708	138290	57
99999	2018-05-03 00:00:00.000	2018-05-03 23:59:00.000	263709	138291	263709	138291	57
99999	2018-05-07 00:00:00.000	2018-05-07 23:59:00.000	263710	138292	263710	138292	57
99999	2018-05-08 00:00:00.000	2018-05-08 23:59:00.000	263711	138293	263711	138293	57
99999	2018-05-09 00:00:00.000	2018-05-09 23:59:00.000	263712	138294	263712	138294	57
99999	2018-05-19 08:00:00.000	2018-05-19 12:00:00.000	263698	138283	263698,263699	138283,138284	61,61
99999	2018-05-19 14:00:00.000	2018-05-19 15:30:00.000	3363698	138283	3363698,4463699	138283,138284	61,61
99999	2018-05-26 00:00:00.000	2018-05-26 23:59:00.000	263700	138285	263700	138285	61
99999	2018-05-27 00:00:00.000	2018-05-27 23:59:00.000	263701	138286	263701	138286	61