Rank records including datediff between records

• NineIron

  SSChampion

  Points: 12529

  More actions

  February 7, 2017 at 8:37 am

  #334884

  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')


• John Mitchell-245523

  SSC Guru

  Points: 148786

  More actions

  February 7, 2017 at 9:14 am

  #1927113

  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

• NineIron

  SSChampion

  Points: 12529

  More actions

  February 7, 2017 at 9:43 am

  #1927127

  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.

• John Mitchell-245523

  SSC Guru

  Points: 148786

  More actions

  February 7, 2017 at 9:48 am

  #1927130

  OK, please post some expected results that I can see, and I'm on it.

  John

• NineIron

  SSChampion

  Points: 12529

  More actions

  February 7, 2017 at 9:58 am

  #1927132

  
  ">

  I need the first example to not include the first Care Note. The individual IDXMRNs should begin with a PCCP record.
  

• NineIron

  SSChampion

  Points: 12529

  More actions

  February 7, 2017 at 10:01 am

  #1927134

  I'm not sure that the img tags are working.

• drew.allen

  SSC Guru

  Points: 76776

  More actions

  February 7, 2017 at 10:10 am

  #1927138

  NineIron - Tuesday, February 7, 2017 10:01 AM

  I'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

• NineIron

  SSChampion

  Points: 12529

  More actions

  February 7, 2017 at 10:23 am

  #1927146

  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')


• John Mitchell-245523

  SSC Guru

  Points: 148786

  More actions

  February 8, 2017 at 2:56 am

  #1927270

  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

• NineIron

  SSChampion

  Points: 12529

  More actions

  February 8, 2017 at 4:51 am

  #1927287

  Thanx.