Ok I have finally had time to circle back around to this query. In my attempts to follow the Forum Etiquette thread I ran into a slight problem in that my unique ID column is not of type INT. My unique id column is an Event_ID. I am getting an error saying that

"Table '#vEvent' does not have the identity property. Cannot perform SET operation." and if I try and skip the SET operation I get this error.

"Conversion failed when converting from a character string to uniqueidentifier." Thank you!

CREATE TABLE #vEvent

(

[EventID] [uniqueidentifier] NOT NULL,

[PatientId] [uniqueidentifier] NOT NULL,

[PatientLastName] [varchar](50) NOT NULL,

[PatientFirstName] [varchar](50) NOT NULL,

[PatientMRN] [varchar](20) NULL,

[EventDate] [datetime] NOT NULL,

[EventDescription] [varchar](100) NULL,

[FacilityName] [varchar](100) NOT NULL

)

SET IDENTITY_INSERT #vEvent ON

INSERT INTO #vEvent

(EventID, PatientId, PatientLastName, PatientFirstName, PatientMRN, EventDate, EventDescription, FacilityName)

SELECT '69D917F8-15EF-4FBB-B615-752853BE32C5','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Mar 23 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'DF9796A1-2045-4FAF-AEBF-B31072B8F788','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Mar 30 2012 12:00AM','Follow-up Visit','WMC - Cork' UNION ALL

SELECT 'AF5156BD-4033-49D7-A215-30A3ECCD155B','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Apr 4 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'D210E82D-D2C9-46FB-AFC4-C7286CA0A97B','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Apr 6 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'CDCC47C7-BEA4-4736-8ED8-D23BC797DD32','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Apr 11 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT '94BF7693-696B-4AB0-8F15-A682A742C17B','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Apr 13 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT '29FE3A60-18C4-4CE6-B819-529F85F7BF1E','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Apr 20 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT '773ACB33-C830-40E1-87DC-058ACF2E61GE','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','Apr 25 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'A2E85417-DFB0-4292-A3F4-FC7ED04F1672','7B191670-BE35-4685-B092-39A72E3621F2','RIGGS','ELLIS','000544249','May 2 2012 12:00AM','5/2/2012','WMC - Cork' UNION ALL

SELECT '69D917F8-15EF-4FBB-B615-752853BE32A3','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Mar 23 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'DF9796A1-2045-4FAF-AEBF-B31072B8F766','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Mar 30 2012 12:00AM','Follow-up Visit','WMC - Cork' UNION ALL

SELECT 'AF5156BD-4033-49D7-A215-30A3ECCD153Z','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Apr 4 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'D210E82D-D2C9-46FB-AFC4-C7286CA0A95Z','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Apr 6 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'CDCC47C7-BEA4-4736-8ED8-D23BC797DD10','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Apr 11 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT '94BF7693-696B-4AB0-8F15-A682A742C15Z','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Apr 13 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT '29FE3A60-18C4-4CE6-B819-529F85F7BFNC','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Apr 20 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT '773ACB33-C830-40E1-87DC-058ACF2E61EC','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','Apr 25 2012 12:00AM','Follow-up 45 min','WMC - Cork' UNION ALL

SELECT 'A2E85417-DFB0-4292-A3F4-FC7ED04F1650','7B191670-BE35-4685-B092-39A72E3621F2','REX','WOOD','000544249','May 2 2012 12:00AM','5/2/2012','WMC - Cork'