i have stored procedure called dbo.match . looks : create procedure [dbo].[match] @parameterfromuser nvarchar(30), @checkbool int begin --some code select rowid, percentmatch @matches end this procedure being called stored procedure : create procedure matchmotherfirstname @motherfn nvarchar(20) , @checkbool int begin select @constval = functionweight dbo.functionweights functionweights.functionid = 20; /* code execute `dbo.match` procedure in above procedure called `matchmotherfirstname` , retrieve `rownumber` , `percentmatch`, insert #temp in respective fields , , calculate `percentmatch * constval`, , insert in corresponding column called `percentage` in `#temp` */ end i need execute dbo.match stored procedure in above procedure, retrieve rowid , pecrntmatch value, @constval value have above, multiply @constval , percentmatch , store in percentage column of #temp , insert results dbo.match procedure in temporary table. dbo.match ...
Comments
Post a Comment