Declare @var varchar(2000)

exec Link_Get '100',@var out

//Call sp and get the resultant xml

Insert into LinkHistory( Details) values (@var)

How abt this?

its the same every stored proc. the procOut returns integer,zero meaning successful,anything > 0 some error.

I found this from Planet Source Code. CHeck you adequate rights to use it.

CREATE PROCEDURE DECRYPTSP2K

@objName varchar(50)

AS

DECLARE @a nvarchar(4000), @b-2 nvarchar(4000), @C nvarchar(4000),...

Hope this helps

declare @procOut int

exec @procOut = proc_A(1,2,'Test)

select @procOut

Hope this helps. Works only in sql server 2000

CREATE Function FormatNumber

(@RawNumber numeric(32,2) = 0,

@ShowDecimal as bit = 0

)

returns varchar(200) AS

BEGIN

declare @FormattedNumber...