February 7, 2017 at 8:37 am
I need to find records based on this identifier, IDXMRN, that have a NoteName='PCCP' with subsequent NoteNames='Care Coordination Note'. I need to know the number of days between the PCCP EncDttm and the 'Care Coordination Note' EncDttm. The results should look something like this.........
Sorry about the SQL code. I'm not sure that I did that correctly.
">
create table #T(IDXMRN varchar(10),NoteCode varchar(3),NoteName varchar(100),EncDttm datetime)insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('223115','712','Care Coordination Note','2016-08-26 12:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('679585','712','Care Coordination Note','2016-08-26 15:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('805815','805','PCCP','2016-08-26 17:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('839020','712','Care Coordination Note','2016-08-30 12:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00088672','712','Care Coordination Note','2016-08-30 10:12:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('666679','712','Care Coordination Note','2016-08-30 13:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('743462','712','Care Coordination Note','2016-08-30 11:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-08-30 11:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689968','805','PCCP','2016-08-30 13:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('344825','805','PCCP','2016-12-29 14:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00362853','805','PCCP','2016-08-31 10:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('783450','712','Care Coordination Note','2016-08-31 14:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('839020','712','Care Coordination Note','2016-09-01 13:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00570034','712','Care Coordination Note','2016-09-01 10:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','712','Care Coordination Note','2016-09-01 10:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00595078','805','PCCP','2016-09-01 15:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('891956','712','Care Coordination Note','2016-09-06 10:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-09-06 10:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('730527','712','Care Coordination Note','2016-09-06 13:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('762006','712','Care Coordination Note','2016-09-06 13:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('879221','778','Care Coordination Note (phone)','2016-09-06 15:57:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('743462','712','Care Coordination Note','2016-09-06 13:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('754749','712','Care Coordination Note','2016-09-06 15:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00574820','712','Care Coordination Note','2016-09-08 10:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('890377','778','Care Coordination Note (phone)','2016-09-08 13:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('742355','712','Care Coordination Note','2016-09-08 11:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-09-08 14:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00387042','712','Care Coordination Note','2016-09-09 15:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('822180','712','Care Coordination Note','2016-09-13 09:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('732446','712','Care Coordination Note','2016-09-13 16:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('732446','712','Care Coordination Note','2016-09-14 16:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-09-15 16:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('342492','712','Care Coordination Note','2016-09-16 13:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00556050','712','Care Coordination Note','2016-09-16 15:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('730527','712','Care Coordination Note','2016-09-22 10:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-09-22 11:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00014345','712','Care Coordination Note','2016-09-23 11:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('654916','712','Care Coordination Note','2016-09-23 12:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('330686','712','Care Coordination Note','2016-09-26 13:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('307925','712','Care Coordination Note','2016-09-26 13:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00086350','712','Care Coordination Note','2016-09-27 09:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('759476','712','Care Coordination Note','2016-09-27 10:12:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00539295','712','Care Coordination Note','2016-09-27 09:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00578740','805','PCCP','2016-09-26 14:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-09-27 13:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00035817','712','Care Coordination Note','2016-09-27 16:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','712','Care Coordination Note','2016-09-28 09:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689865','712','Care Coordination Note','2016-09-28 14:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00544339','712','Care Coordination Note','2016-09-28 15:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00544339','712','Care Coordination Note','2016-09-29 11:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00080747','805','PCCP','2016-09-29 13:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('759476','712','Care Coordination Note','2016-09-30 11:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00628728','712','Care Coordination Note','2016-09-30 13:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('654916','712','Care Coordination Note','2016-09-30 11:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00521638','805','PCCP','2016-09-30 15:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','712','Care Coordination Note','2016-09-30 13:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00544339','712','Care Coordination Note','2016-10-03 12:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00539295','712','Care Coordination Note','2016-10-04 13:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00020651','712','Care Coordination Note','2016-10-04 14:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00620541','712','Care Coordination Note','2016-10-04 15:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','805','PCCP','2016-10-13 09:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('732446','712','Care Coordination Note','2016-10-06 11:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('713174','712','Care Coordination Note','2016-10-06 13:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('340704','712','Care Coordination Note','2016-10-06 14:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00035817','805','PCCP','2016-10-07 08:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00544339','712','Care Coordination Note','2016-10-10 10:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('713174','712','Care Coordination Note','2016-10-10 15:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-10-10 11:57:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00078987','712','Care Coordination Note','2016-10-11 11:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00078987','805','PCCP','2016-10-11 11:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('713174','712','Care Coordination Note','2016-10-11 11:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('832614','805','PCCP','2017-01-12 08:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00122311','805','PCCP','2016-10-14 10:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00024106','712','Care Coordination Note','2016-10-14 10:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('330759','805','PCCP','2016-10-14 11:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-10-14 11:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('751693','778','Care Coordination Note (phone)','2016-10-15 10:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('697045','778','Care Coordination Note (phone)','2016-10-15 11:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826382','805','PCCP','2016-10-17 09:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00024315','805','PCCP','2016-10-17 13:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-10-18 09:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00570034','712','Care Coordination Note','2016-10-18 12:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2016-10-19 13:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('XID641008','712','Care Coordination Note','2016-10-20 09:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00024106','712','Care Coordination Note','2016-10-20 10:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('782919','778','Care Coordination Note (phone)','2016-10-20 14:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00035817','712','Care Coordination Note','2016-10-20 13:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826881','805','PCCP','2016-10-20 14:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00024142','805','PCCP','2016-10-21 12:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00022962','712','Care Coordination Note','2016-10-21 13:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00126175','712','Care Coordination Note','2016-12-09 11:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('805360','805','PCCP','2016-10-21 14:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00539295','712','Care Coordination Note','2016-10-21 14:05:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00574647','805','PCCP','2016-10-21 17:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('799607','805','PCCP','2016-10-24 09:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-10-24 10:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826348','805','PCCP','2016-10-24 13:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('865023','712','Care Coordination Note','2016-10-24 10:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00100734','805','PCCP','2016-10-24 10:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('679585','712','Care Coordination Note','2016-10-24 15:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('806104','805','PCCP','2016-10-21 09:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00080747','712','Care Coordination Note','2016-10-25 14:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00516185','805','PCCP','2016-10-25 16:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('772141','712','Care Coordination Note','2016-10-25 13:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('779905','805','PCCP','2016-10-26 10:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00011191','805','PCCP','2016-10-26 12:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('804757','805','PCCP','2016-10-26 12:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00562987','805','PCCP','2016-10-26 12:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826952','805','PCCP','2016-10-27 10:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('854791','805','PCCP','2016-10-27 11:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('891956','712','Care Coordination Note','2016-10-27 11:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('777466','712','Care Coordination Note','2016-10-31 11:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00587995','712','Care Coordination Note','2016-10-27 11:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00509850','712','Care Coordination Note','2016-10-27 13:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('886968','778','Care Coordination Note (phone)','2016-10-28 11:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('221609','805','PCCP','2016-10-31 09:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('805256','805','PCCP','2016-10-31 13:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00088325','805','PCCP','2016-10-31 15:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('830058','712','Care Coordination Note','2016-10-31 14:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('691677','712','Care Coordination Note','2016-10-31 17:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826264','805','PCCP','2016-10-31 13:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00084964','805','PCCP','2016-11-01 09:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00040905','805','PCCP','2016-10-31 14:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('786619','712','Care Coordination Note','2016-10-31 15:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('751805','805','PCCP','2016-11-01 11:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('357618','805','PCCP','2016-10-27 11:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('891956','712','Care Coordination Note','2016-10-31 16:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('714007','712','Care Coordination Note','2016-10-31 17:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00587554','805','PCCP','2016-11-01 12:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00061014','805','PCCP','2016-11-01 13:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00032132','805','PCCP','2016-11-01 14:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('848443','805','PCCP','2016-11-01 15:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('806227','805','PCCP','2016-11-01 16:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('803342','805','PCCP','2016-11-01 13:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00587995','805','PCCP','2016-11-01 15:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('708245','805','PCCP','2016-11-02 10:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('641480','805','PCCP','2016-11-02 11:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('861927','805','PCCP','2016-11-02 10:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('326176','712','Care Coordination Note','2016-11-02 16:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('648353','805','PCCP','2016-11-02 11:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00103339','712','Care Coordination Note','2016-11-03 10:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('779210','712','Care Coordination Note','2016-11-02 15:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00054169','805','PCCP','2016-11-03 11:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('336489','805','PCCP','2016-11-03 08:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00531707','805','PCCP','2016-11-03 10:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725178','805','PCCP','2016-11-03 14:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('772141','805','PCCP','2016-11-03 16:16:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','805','PCCP','2016-11-03 17:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2016-11-04 11:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('713174','712','Care Coordination Note','2016-11-04 13:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('808458','805','PCCP','2016-11-04 11:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00089944','712','Care Coordination Note','2016-11-04 10:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00016655','712','Care Coordination Note','2016-11-04 11:57:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('810807','805','PCCP','2016-11-04 14:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('673501','805','PCCP','2016-11-07 09:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('792690','805','PCCP','2016-11-07 09:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('330986','805','PCCP','2016-11-07 12:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('866025','805','PCCP','2016-11-07 12:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('865948','805','PCCP','2016-11-07 14:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00547167','805','PCCP','2016-11-07 15:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('821254','805','PCCP','2016-11-07 14:12:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('855837','805','PCCP','2016-11-07 14:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00618151','805','PCCP','2016-11-07 14:37:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('805823','805','PCCP','2016-11-07 14:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('869722','805','PCCP','2016-11-08 10:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00509132','805','PCCP','2016-11-08 10:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('806501','805','PCCP','2016-11-08 15:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('857148','805','PCCP','2016-11-08 11:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('843968','805','PCCP','2016-11-08 16:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('829890','805','PCCP','2016-11-09 10:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('862639','805','PCCP','2016-11-09 09:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00090591','805','PCCP','2016-11-10 08:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-11-10 11:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00081016','805','PCCP','2016-11-10 09:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('805517','805','PCCP','2016-11-10 09:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00102560','805','PCCP','2016-11-10 10:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('712693','805','PCCP','2016-11-10 10:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00035817','712','Care Coordination Note','2016-11-10 10:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('329408','805','PCCP','2016-11-10 15:04:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('732723','805','PCCP','2016-11-10 11:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('343009','805','PCCP','2016-11-10 14:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('792393','805','PCCP','2016-11-10 13:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00081534','805','PCCP','2016-11-10 14:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689968','712','Care Coordination Note','2016-11-10 14:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('842192','805','PCCP','2016-11-11 10:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00119326','805','PCCP','2016-11-11 11:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('746572','805','PCCP','2016-11-11 14:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00012537','712','Care Coordination Note','2016-11-14 10:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('773549','778','Care Coordination Note (phone)','2016-11-14 11:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00576561','805','PCCP','2016-11-14 14:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('880111','805','PCCP','2016-11-14 15:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('864824','805','PCCP','2016-11-14 16:04:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('808212','805','PCCP','2016-11-14 18:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('760731','805','PCCP','2016-11-15 10:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('822054','805','PCCP','2016-11-15 10:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('813549','805','PCCP','2016-11-15 11:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('830058','805','PCCP','2016-11-15 13:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00541080','712','Care Coordination Note','2016-11-15 12:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00612074','805','PCCP','2016-11-15 13:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('832358','805','PCCP','2016-11-16 10:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00559276','712','Care Coordination Note','2016-11-16 14:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00514722','712','Care Coordination Note','2016-11-16 14:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00515412','805','PCCP','2016-11-17 13:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00553385','712','Care Coordination Note','2016-11-17 11:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00587995','712','Care Coordination Note','2016-11-17 15:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00541080','712','Care Coordination Note','2016-11-17 16:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('861631','805','PCCP','2016-11-18 08:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','805','PCCP','2016-12-21 08:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','712','Care Coordination Note','2016-11-21 15:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('830094','778','Care Coordination Note (phone)','2016-11-21 15:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00109925','712','Care Coordination Note','2016-11-21 17:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('677520','778','Care Coordination Note (phone)','2016-11-22 08:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00553385','712','Care Coordination Note','2016-11-21 14:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('873267','712','Care Coordination Note','2016-11-22 09:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00028069','712','Care Coordination Note','2016-11-21 16:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('865023','712','Care Coordination Note','2016-11-22 10:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('830058','712','Care Coordination Note','2016-11-22 11:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('839020','712','Care Coordination Note','2016-11-22 10:37:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00040004','712','Care Coordination Note','2016-11-22 15:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('879833','805','PCCP','2016-11-23 09:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('339505','712','Care Coordination Note','2016-11-23 08:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00533042','805','PCCP','2016-11-23 11:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('873267','805','PCCP','2016-11-23 10:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('663192','712','Care Coordination Note','2016-11-23 13:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('663192','805','PCCP','2016-11-25 09:05:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('766801','712','Care Coordination Note','2016-11-23 15:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('808452','805','PCCP','2016-11-25 13:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00006279','805','PCCP','2016-11-25 13:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2016-11-25 10:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('804890','805','PCCP','2016-11-25 11:39:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2016-11-28 13:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('804636','805','PCCP','2016-11-28 15:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826552','805','PCCP','2016-11-29 08:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00559276','712','Care Coordination Note','2016-11-29 14:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('863138','778','Care Coordination Note (phone)','2016-11-29 15:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00116623','778','Care Coordination Note (phone)','2016-11-29 15:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('822255','805','PCCP','2016-11-29 15:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('786678','712','Care Coordination Note','2016-11-30 15:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00365565','805','PCCP','2016-12-01 09:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2016-12-01 07:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('274803','805','PCCP','2016-12-01 12:04:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('770262','712','Care Coordination Note','2016-12-01 12:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('323581','805','PCCP','2016-12-01 14:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00625326','805','PCCP','2016-12-01 14:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00001696','712','Care Coordination Note','2016-12-01 15:04:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00626479','712','Care Coordination Note','2016-12-01 16:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826728','805','PCCP','2016-12-02 10:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('838995','805','PCCP','2016-12-02 10:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00514492','712','Care Coordination Note','2016-12-02 16:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('724972','778','Care Coordination Note (phone)','2016-12-02 14:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('766801','712','Care Coordination Note','2016-12-02 14:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('320565','778','Care Coordination Note (phone)','2016-12-05 09:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('780058','712','Care Coordination Note','2016-12-05 15:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('869453','805','PCCP','2016-12-06 09:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860870','805','PCCP','2016-12-06 13:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('738789','805','PCCP','2016-12-06 15:39:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('746273','805','PCCP','2016-12-06 16:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00104685','712','Care Coordination Note','2016-12-06 14:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('819833','778','Care Coordination Note (phone)','2016-12-07 10:16:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00078987','712','Care Coordination Note','2016-12-07 08:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('674328','805','PCCP','2016-12-07 11:12:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('770262','712','Care Coordination Note','2016-12-07 15:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('880100','805','PCCP','2016-12-07 11:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('787798','805','PCCP','2016-12-08 11:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00626479','712','Care Coordination Note','2016-12-08 15:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('803766','805','PCCP','2016-12-08 11:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('743152','712','Care Coordination Note','2016-12-08 14:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('678861','712','Care Coordination Note','2016-12-08 14:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860264','805','PCCP','2016-12-08 16:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('864100','805','PCCP','2016-12-09 10:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('842751','712','Care Coordination Note','2016-12-09 16:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00573762','712','Care Coordination Note','2016-12-12 14:37:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00040004','712','Care Coordination Note','2016-12-12 14:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('735693','805','PCCP','2016-12-13 11:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('853023','778','Care Coordination Note (phone)','2016-12-13 12:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('863460','805','PCCP','2016-12-13 14:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('861543','805','PCCP','2016-12-13 16:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('777543','805','PCCP','2016-12-13 17:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00548480','805','PCCP','2016-12-14 10:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860114','805','PCCP','2016-12-13 16:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('815902','805','PCCP','2016-12-13 16:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00027714','778','Care Coordination Note (phone)','2016-12-14 13:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('810241','805','PCCP','2016-12-14 11:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00005007','805','PCCP','2016-12-14 09:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('756774','778','Care Coordination Note (phone)','2016-12-14 13:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('326572','712','Care Coordination Note','2016-12-14 12:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('279898','712','Care Coordination Note','2016-12-14 16:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('876371','805','PCCP','2016-12-28 14:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00006785','805','PCCP','2016-12-15 14:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00539295','712','Care Coordination Note','2016-12-16 09:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00380255','805','PCCP','2016-12-16 10:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00587995','712','Care Coordination Note','2016-12-16 11:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('846827','805','PCCP','2016-12-16 09:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00021090','805','PCCP','2016-12-16 13:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00043830','778','Care Coordination Note (phone)','2016-12-19 08:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('797687','805','PCCP','2016-12-19 13:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826460','805','PCCP','2016-12-19 14:57:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00090313','805','PCCP','2016-12-20 08:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('760767','805','PCCP','2016-12-20 10:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00085964','805','PCCP','2016-12-20 13:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('863138','778','Care Coordination Note (phone)','2016-12-20 11:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('762006','712','Care Coordination Note','2016-12-20 11:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00599331','712','Care Coordination Note','2016-12-20 13:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('716300','712','Care Coordination Note','2016-12-20 16:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('652015','805','PCCP','2016-12-21 10:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('275500','805','PCCP','2016-12-21 12:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('822776','805','PCCP','2016-12-21 11:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('347624','805','PCCP','2016-12-21 13:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860178','805','PCCP','2016-12-21 12:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('727518','805','PCCP','2016-12-21 16:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00506337','778','Care Coordination Note (phone)','2016-12-22 15:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('705624','778','Care Coordination Note (phone)','2016-12-22 14:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('700743','712','Care Coordination Note','2016-12-23 08:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('700743','805','PCCP','2016-12-23 08:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00006279','712','Care Coordination Note','2016-12-23 14:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00570034','712','Care Coordination Note','2016-12-23 13:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('809550','712','Care Coordination Note','2016-12-29 11:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00078987','712','Care Coordination Note','2016-12-27 08:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('320981','805','PCCP','2016-12-27 10:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('862153','805','PCCP','2016-12-27 10:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00570034','712','Care Coordination Note','2016-12-27 11:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860115','805','PCCP','2016-12-27 15:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00521483','805','PCCP','2016-12-27 13:05:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00008002','805','PCCP','2016-12-27 15:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('731622','805','PCCP','2016-12-27 14:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00040396','712','Care Coordination Note','2016-12-27 15:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725003','712','Care Coordination Note','2016-12-28 13:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('763527','805','PCCP','2016-12-28 14:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('893596','805','PCCP','2016-12-30 09:39:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818627','805','PCCP','2016-12-30 09:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('799909','805','PCCP','2016-12-30 11:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('654916','712','Care Coordination Note','2016-12-30 14:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('807007','805','PCCP','2016-12-30 13:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('893150','805','PCCP','2016-12-30 13:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00076546','805','PCCP','2016-12-30 13:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00114776','712','Care Coordination Note','2016-12-30 17:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('303343','778','Care Coordination Note (phone)','2017-01-03 08:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00631339','712','Care Coordination Note','2017-01-03 09:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00590119','805','PCCP','2017-01-30 11:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00047165','805','PCCP','2017-01-03 09:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00009685','805','PCCP','2017-01-03 11:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689968','712','Care Coordination Note','2017-01-23 10:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('825810','805','PCCP','2017-01-03 10:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00511255','805','PCCP','2017-01-03 12:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00511255','778','Care Coordination Note (phone)','2017-01-03 12:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2017-01-03 12:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860793','805','PCCP','2017-01-03 13:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('864311','805','PCCP','2017-01-03 13:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('881866','805','PCCP','2017-01-03 12:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('279061','712','Care Coordination Note','2017-01-03 14:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('762383','805','PCCP','2017-01-03 13:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('276185','805','PCCP','2017-01-03 15:04:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('864137','805','PCCP','2017-01-03 15:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('328996','805','PCCP','2017-01-03 15:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00545207','805','PCCP','2017-01-03 16:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('862233','805','PCCP','2017-01-04 13:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('714477','712','Care Coordination Note','2017-01-04 10:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('770262','712','Care Coordination Note','2017-01-04 11:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('839020','712','Care Coordination Note','2017-01-05 09:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('712693','712','Care Coordination Note','2017-01-05 09:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('729597','805','PCCP','2017-01-05 11:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('799709','712','Care Coordination Note','2017-01-05 15:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826138','805','PCCP','2017-01-05 12:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00534144','778','Care Coordination Note (phone)','2017-01-06 10:16:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00626479','805','PCCP','2017-01-05 10:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('820942','712','Care Coordination Note','2017-01-05 16:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00012379','778','Care Coordination Note (phone)','2017-01-06 12:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('838729','805','PCCP','2017-01-06 12:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860489','805','PCCP','2017-01-06 09:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('309752','805','PCCP','2017-01-06 14:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('324527','805','PCCP','2017-01-06 11:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('871491','805','PCCP','2017-01-07 10:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860233','805','PCCP','2017-01-07 09:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00007828','712','Care Coordination Note','2017-01-06 13:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('331335','805','PCCP','2017-01-06 13:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('794119','778','Care Coordination Note (phone)','2017-01-06 14:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('683030','778','Care Coordination Note (phone)','2017-01-06 15:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00533342','805','PCCP','2017-01-07 10:39:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('814363','805','PCCP','2017-01-09 09:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('806731','805','PCCP','2017-01-09 10:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('215789','805','PCCP','2017-01-09 11:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('810683','805','PCCP','2017-01-09 13:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00533814','712','Care Coordination Note','2017-01-09 15:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00590698','805','PCCP','2017-01-09 14:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('891659','805','PCCP','2017-01-10 09:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('784168','712','Care Coordination Note','2017-01-09 16:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('716568','805','PCCP','2017-01-10 10:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('648112','805','PCCP','2017-01-10 12:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('804681','805','PCCP','2017-01-10 11:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('324531','805','PCCP','2017-01-10 14:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00545357','805','PCCP','2017-01-10 14:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('824849','805','PCCP','2017-01-10 13:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00541303','805','PCCP','2017-01-10 15:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00012379','778','Care Coordination Note (phone)','2017-01-11 13:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('806610','805','PCCP','2017-01-11 11:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('329737','805','PCCP','2017-01-13 09:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('806868','805','PCCP','2017-01-13 09:12:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('218431','805','PCCP','2017-01-13 10:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00006279','712','Care Coordination Note','2017-01-13 15:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('794119','778','Care Coordination Note (phone)','2017-01-13 14:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00029868','805','PCCP','2017-01-16 10:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00104318','712','Care Coordination Note','2017-01-17 11:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00035817','712','Care Coordination Note','2017-01-17 11:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('310404','712','Care Coordination Note','2017-01-17 16:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('811678','805','PCCP','2017-01-18 12:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('714477','805','PCCP','2017-01-20 08:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00586534','712','Care Coordination Note','2017-01-18 10:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('218271','712','Care Coordination Note','2017-01-20 12:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('793868','805','PCCP','2017-01-20 16:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('842081','712','Care Coordination Note','2017-01-20 15:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00029550','712','Care Coordination Note','2017-01-20 15:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00113541','712','Care Coordination Note','2017-01-23 14:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('654916','712','Care Coordination Note','2017-01-23 15:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('808628','712','Care Coordination Note','2017-01-23 13:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('794718','805','PCCP','2017-01-23 09:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('901878','778','Care Coordination Note (phone)','2017-01-24 11:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00363216','778','Care Coordination Note (phone)','2017-01-24 11:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('743431','778','Care Coordination Note (phone)','2017-01-24 11:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00514569','805','PCCP','2017-01-24 13:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('733647','805','PCCP','2017-01-24 14:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00551528','712','Care Coordination Note','2017-01-24 10:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('711330','712','Care Coordination Note','2017-01-24 11:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('642984','805','PCCP','2017-01-24 12:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('762006','805','PCCP','2017-01-24 14:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689968','805','PCCP','2017-01-24 14:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('304370','778','Care Coordination Note (phone)','2017-01-25 09:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00002639','778','Care Coordination Note (phone)','2017-01-25 08:45:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00002003','805','PCCP','2017-02-06 15:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('H495442','712','Care Coordination Note','2017-01-25 15:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('897910','712','Care Coordination Note','2017-01-26 10:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('827538','712','Care Coordination Note','2017-01-27 08:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('223390','712','Care Coordination Note','2017-01-25 16:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('900204','778','Care Coordination Note (phone)','2017-01-26 13:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('872504','712','Care Coordination Note','2017-01-26 14:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00533789','712','Care Coordination Note','2017-01-26 11:04:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('839666','778','Care Coordination Note (phone)','2017-01-27 08:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2017-01-30 09:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('897910','712','Care Coordination Note','2017-01-30 09:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('657571','778','Care Coordination Note (phone)','2017-01-30 08:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('234081','778','Care Coordination Note (phone)','2017-01-30 09:11:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('670024','712','Care Coordination Note','2017-01-30 10:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('715004','712','Care Coordination Note','2017-01-31 08:41:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('805815','805','PCCP','2017-01-31 13:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('322337','778','Care Coordination Note (phone)','2017-01-31 13:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('732708','805','PCCP','2017-01-31 15:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('845823','712','Care Coordination Note','2017-02-01 09:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('813553','778','Care Coordination Note (phone)','2017-02-01 09:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('894853','778','Care Coordination Note (phone)','2017-02-01 13:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('820809','712','Care Coordination Note','2017-02-02 17:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689865','712','Care Coordination Note','2017-02-03 10:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('893662','805','PCCP','2017-02-03 13:33:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00121868','778','Care Coordination Note (phone)','2017-02-03 11:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('678861','712','Care Coordination Note','2017-02-06 11:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00578837','778','Care Coordination Note (phone)','2017-02-06 11:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00575683','805','PCCP','2017-02-06 17:26:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00546819','805','PCCP','2017-02-06 16:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00595078','712','Care Coordination Note','2016-09-02 08:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00012619','712','Care Coordination Note','2016-07-26 09:15:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00024690','712','Care Coordination Note','2016-07-05 08:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00039975','805','PCCP','2016-07-01 15:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00028931','712','Care Coordination Note','2016-07-05 11:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('334176','778','Care Coordination Note (phone)','2016-07-05 15:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('854996','805','PCCP','2016-07-05 13:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00024690','712','Care Coordination Note','2016-07-06 09:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00126175','712','Care Coordination Note','2016-07-06 11:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('724864','712','Care Coordination Note','2016-07-06 09:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('698181','712','Care Coordination Note','2016-07-07 10:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00613185','712','Care Coordination Note','2016-07-07 11:42:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00575683','712','Care Coordination Note','2016-07-07 13:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('774319','712','Care Coordination Note','2016-07-07 10:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('733767','712','Care Coordination Note','2016-07-07 12:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('335476','712','Care Coordination Note','2016-07-07 12:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00521638','712','Care Coordination Note','2016-07-07 12:58:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('759963','712','Care Coordination Note','2016-07-08 09:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00538831','712','Care Coordination Note','2016-07-07 14:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('635810','712','Care Coordination Note','2016-07-08 09:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','712','Care Coordination Note','2016-07-08 09:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('680271','712','Care Coordination Note','2016-07-08 10:16:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00509850','712','Care Coordination Note','2016-07-08 11:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('778048','712','Care Coordination Note','2016-07-08 09:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('768246','712','Care Coordination Note','2016-07-08 14:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('797687','805','PCCP','2016-07-05 14:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('335476','712','Care Coordination Note','2016-07-08 14:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00544346','712','Care Coordination Note','2016-07-08 17:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('680271','712','Care Coordination Note','2016-07-11 10:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('676727','712','Care Coordination Note','2016-07-11 11:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('691677','805','PCCP','2016-08-10 13:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00631409','712','Care Coordination Note','2016-07-11 14:14:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00633902','712','Care Coordination Note','2016-07-11 11:56:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('644057','778','Care Coordination Note (phone)','2016-07-12 14:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00618459','712','Care Coordination Note','2016-07-12 16:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00064269','805','PCCP','2016-07-14 09:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('726773','805','PCCP','2016-07-14 09:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00326660','712','Care Coordination Note','2016-07-14 10:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('335476','805','PCCP','2016-07-14 17:18:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00057983','712','Care Coordination Note','2016-07-14 09:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00057983','712','Care Coordination Note','2016-07-15 09:47:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('354302','712','Care Coordination Note','2016-07-15 14:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00048225','712','Care Coordination Note','2016-07-15 15:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('879833','712','Care Coordination Note','2016-10-19 08:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('766113','805','PCCP','2016-08-10 11:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00553986','712','Care Coordination Note','2016-07-19 09:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('691268','712','Care Coordination Note','2016-07-18 09:34:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('742355','805','PCCP','2016-07-19 17:07:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('785411','712','Care Coordination Note','2016-07-19 14:25:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('742355','712','Care Coordination Note','2016-07-20 10:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('774319','712','Care Coordination Note','2016-07-21 11:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-07-21 09:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('743462','805','PCCP','2016-07-20 10:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('689968','712','Care Coordination Note','2016-07-21 13:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('771092','805','PCCP','2016-07-21 17:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('759476','805','PCCP','2016-07-21 15:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00086350','712','Care Coordination Note','2016-07-22 09:46:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00119213','805','PCCP','2016-07-22 10:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('760276','712','Care Coordination Note','2016-07-22 11:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('719220','712','Care Coordination Note','2016-07-22 17:40:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('730485','712','Care Coordination Note','2016-07-25 13:20:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('680271','712','Care Coordination Note','2016-07-25 11:13:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('760513','805','PCCP','2016-07-25 15:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('759476','712','Care Coordination Note','2016-07-26 10:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('837565','778','Care Coordination Note (phone)','2016-07-26 13:22:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-07-27 09:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00633902','712','Care Coordination Note','2016-07-28 10:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('836733','712','Care Coordination Note','2016-07-28 10:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('850143','712','Care Coordination Note','2016-07-28 12:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00086350','712','Care Coordination Note','2016-07-29 11:00:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('891956','712','Care Coordination Note','2016-07-29 13:54:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00121762','712','Care Coordination Note','2016-07-29 12:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('744386','712','Care Coordination Note','2016-07-29 15:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00509850','805','PCCP','2016-08-01 09:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('733767','712','Care Coordination Note','2016-08-01 10:05:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('799709','778','Care Coordination Note (phone)','2016-08-01 14:01:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('679585','712','Care Coordination Note','2016-08-01 12:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('679585','805','PCCP','2016-08-01 12:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('891181','805','PCCP','2016-08-01 13:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('762006','712','Care Coordination Note','2016-08-01 14:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('776828','712','Care Coordination Note','2016-08-02 09:12:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00538831','712','Care Coordination Note','2016-08-02 13:28:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00005636','805','PCCP','2016-08-02 14:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('733767','712','Care Coordination Note','2016-08-02 15:24:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('860949','712','Care Coordination Note','2016-08-03 10:44:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('796730','778','Care Coordination Note (phone)','2016-08-03 14:50:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('238552','712','Care Coordination Note','2016-08-03 17:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('713548','778','Care Coordination Note (phone)','2016-08-04 11:53:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('815574','778','Care Coordination Note (phone)','2016-08-04 14:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00057983','712','Care Coordination Note','2016-08-04 13:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('223617','712','Care Coordination Note','2016-08-04 14:02:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('354061','805','PCCP','2016-08-05 11:05:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','805','PCCP','2016-07-27 10:16:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('826439','805','PCCP','2016-08-05 11:27:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('671238','805','PCCP','2016-08-05 13:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('666679','805','PCCP','2016-08-05 12:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00058913','805','PCCP','2016-08-05 12:29:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('711288','778','Care Coordination Note (phone)','2016-08-05 14:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('753580','712','Care Coordination Note','2016-08-05 16:55:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('725566','712','Care Coordination Note','2016-08-08 11:08:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('765701','778','Care Coordination Note (phone)','2016-08-08 15:10:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00509850','712','Care Coordination Note','2016-08-09 09:38:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00057983','712','Care Coordination Note','2016-08-09 07:52:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('762006','805','PCCP','2016-08-09 13:48:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00599331','712','Care Coordination Note','2016-08-09 10:59:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00078987','712','Care Coordination Note','2016-08-09 14:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('839020','712','Care Coordination Note','2016-08-09 14:49:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('797687','712','Care Coordination Note','2016-08-11 08:51:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00574820','805','PCCP','2016-08-11 14:19:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('818136','712','Care Coordination Note','2016-08-11 14:09:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('783450','712','Care Coordination Note','2016-08-11 11:35:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('715004','805','PCCP','2016-08-11 16:36:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('654916','712','Care Coordination Note','2016-08-16 13:43:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('783450','712','Care Coordination Note','2016-08-16 09:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00087898','778','Care Coordination Note (phone)','2016-08-16 16:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00603868','712','Care Coordination Note','2016-08-17 17:16:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00120309','712','Care Coordination Note','2016-08-18 10:06:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00603795','805','PCCP','2016-08-22 10:31:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00544346','805','PCCP','2016-08-23 15:21:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00579850','805','PCCP','2016-08-24 12:23:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('822255','712','Care Coordination Note','2016-08-29 09:30:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('774844','712','Care Coordination Note','2016-08-25 10:32:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00552277','778','Care Coordination Note (phone)','2016-08-25 19:17:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('00030896','805','PCCP','2016-08-25 14:03:00')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values(insert into #T(IDXMRN, NoteCode, NoteName, EncDttm) values('730485','712','Care Coordination Note','2016-08-26 10:00:00')
February 7, 2017 at 9:14 am
I can't see your expected results, but here's a guess. You've posted in a SQL Server 2008 forum, so I assume that's what you're using. There's a better method if you're on 2012 or later.
WITH Numbered AS (
SELECT
IDXMRN
, NoteCode
, NoteName
, EncDttm
, ROW_NUMBER() OVER (PARTITION BY IDXMRN ORDER BY EncDttm) AS RowNo
FROM #T
)
SELECT
n1.IDXMRN
, n1.NoteCode
, n1.NoteName
, n1.EncDttm
, DATEDIFF(day,n1.EncDttm,n2.EncDttm) AS DaystoNextCCN
FROM NUmbered n1 JOIN Numbered n2
ON n1.RowNo = n2.RowNo - 1 AND n1.IDXMRN = n2.IDXMRN
WHERE n1.NoteName = 'PCCP' AND n2.NoteName = 'Care Coordination Note'
John
February 7, 2017 at 9:43 am
Almost there. Your where clause results in only PCCP records. If I remove your where clause and order by IDXMRN, EncDttm, then, it looks good. Only problem is....I need the earliest record to be PCCP, then the subsequent Care Notes, if any.
So, take a peek at the record with an IDXMRN=00035817. The most recent EncDttm is 2016-09-27 16:49:00 but, the NoteName is "Care Coordination Note". I want to exclude that one and other IDXMRNs like that.
February 7, 2017 at 9:48 am
OK, please post some expected results that I can see, and I'm on it.
John
February 7, 2017 at 9:58 am
">
I need the first example to not include the first Care Note. The individual IDXMRNs should begin with a PCCP record.
February 7, 2017 at 10:01 am
I'm not sure that the img tags are working.
February 7, 2017 at 10:10 am
NineIron - Tuesday, February 7, 2017 10:01 AMI'm not sure that the img tags are working.
You shouldn't be posting expected results as images anyhow. You should be posting them as inserts into a table (preferably temp tables), so that we can execute them. This allows us to do things like use EXCEPT to compare our results with your expected results.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2017 at 10:23 am
Here is a table. The expected results should look something like this. I'm not sure that the Days... is correct but, you get the picture. The PCCP record should be first with Days=0.
create table #T(IDXMRN varchar(10),NoteCode varchar(3),NoteName varchar(100),EncDttm datetime,DaystoNextCCN varchar(5))insert into #T(IDXMRN, NoteCode, NoteName, EncDttm, DaystoNextCCN) values('00006279','805','PCCP','2016-11-25 13:18:00','0')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm, DaystoNextCCN) values('00006279','712','Care Coordination Note','2016-12-23 14:29:00','21')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm, DaystoNextCCN) values('00035817','712','Care Coordination Note','2016-09-27 16:49:00','10')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm, DaystoNextCCN) values('00035817','805','PCCP','2016-10-07 08:22:00','0')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm, DaystoNextCCN) values('00035817','712','Care Coordination Note','2016-10-20 13:46:00','21')insert into #T(IDXMRN, NoteCode, NoteName, EncDttm, DaystoNextCCN) values('00035817','712','Care Coordination Note','2016-11-10 10:30:00','68')
February 8, 2017 at 2:56 am
In your results, PCCP isn't first in the second group, so I'm not sure quite what your requirement is. In that first row, you show the days to the PCCP, despite the fact you've named your column DaystoNextCCN. Try this - it shows the date the next CCN in all cases, even if the next row is a PCCP. If you don't want to include the last row in each group, just add WHERE n2.RowNo IS NOT NULL.
WITH Numbered AS (
SELECT
IDXMRN
, NoteCode
, NoteName
, EncDttm
, ROW_NUMBER() OVER (PARTITION BY IDXMRN, NoteCode ORDER BY EncDttm) AS RowNo
FROM #T
)
SELECT
n1.IDXMRN
, n1.NoteCode
, n1.NoteName
, n1.EncDttm
, CASE
WHEN n1.NoteName = 'PCCP' THEN 0
ELSE DATEDIFF(day,n1.EncDttm,n2.EncDttm)
END AS DaystoNextCCN
FROM NUmbered n1
LEFT JOIN Numbered n2
ON n1.RowNo = n2.RowNo - 1 AND n1.IDXMRN = n2.IDXMRN
WHERE n1.NoteName IN ('PCCP','Care Coordination Note')
ORDER BY
n1.IDXMRN
, n1.EncDttm;
John
February 8, 2017 at 4:51 am
Thanx.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply