gistfile1.txt

ALTER VIEW [dbo].[vPatient] AS
SELECT	[uid_Patient], 
		[uid_ProviderOrganization], 
--		[uid_ProviderLocation], 
		[uid_LastEncounter], 
		[vc_MRN], 
		[vc_FName], 
		[vc_LName], 
		[c_Gender], 
		[dt_Birthdate], 
		[dt_Created],
		[vc_MiddleInitial],
		[vc_PrimaryCareProvider],
		[vc_SSN]
		
FROM [dbo].[tPatient]
GO