Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
ALTER PROCEDURE dbo.ReportTypeSelect( @ReportTypeKey int) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT ReportTypeKey, NULL AS ReportTypeKey, ReportTypeName, ReportTypeDesc, rt.ReportTypeGroupKey, ReportTypeGroupName, rt.OrderTypeKey, OrderTypeName FROM dbo.ReportType rt JOIN dbo.OrderType o ON rt.OrderTypeKey = o.OrderTypeKey JOIN dbo.ReportTypeGroup rtg ON rt.ReportTypeGroupKey = rtg.ReportTypeGroupKey WHERE ReportTypeKey = @ReportTypeKey END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.