Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
CREATE PROCEDURE NewCaseInsertDocs -- Add the parameters for the stored procedure here @MaxCaseId int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here INSERT INTO dbo.Documents_Needed (CaseID, Type) VALUES ((SELECT MAX(CaseID) From dbo.ACF_Cases),'Assign') END GO
Join the community of 500,000 technology professionals and ask your questions.