CREATE PROCEDURE [dbo].[Procedure3] @para1 varchar(50), @para2 datetime AS BEGIN CREATE TABLE #tem ( …. …. ) insert into #tem (value) exec [dbo].[Procedure2] @para1,@para2,@para3 ……. ……. ………. END
CREATE PROCEDURE [dbo].[Procedure2] @para1 varchar(50), @para2 datetime, @para3 decimal(18,2) AS BEGIN CREATE TABLE #temp ( Value decimal(18,2) ) insert into #temp exec Procedure1 @para1,@para2,@para3 …….. ……. …….. select Name,Amount from #Temp1 END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)