sp_executesql 3

[mimi2]

I am still at the same point.
What should i change to make this code work? Thanks

The error i get is:
Cannot use the OUTPUT option when passing a constant to a stored procedure

this is part of a stored procedure
declare sql nvarchar(200), maxdate datetime

SET @sql = N'SELECT @m = MAX(date) FROM ' + @link_server + '.database1.dbo.table1
EXEC sp_executesql @sql, N'@m datetime OUTPUT', MaxDate OUTPUT
print ('max= ' + cast (@MaxDate as varchar (40)) )

 

[JayKusch]

May need to go at it this way ... maybe - lol


CREATE PROCEDURE MyProcedure @MaxDate dateteime output

declare @sql varchar(400)

SET @sql = N'SELECT @MaxDate = MAX(date)
FROM ' + @link_server + '.database1.dbo.table1'

EXEC (@sql)

print ('max= ' + cast (@MaxDate as varchar (40)) )

Thanks

J. Kusch

 

[HyperRon]

What are you trying to do? You have @m as Max(date) that's not declared and you have MaxDate without '@' in front of it. Kinda confusing. Or maybe I'm on crack lol

Take a look at this:

http://support.microsoft.com/defaul...port/kb/articles/q262/4/99.asp&NoWebContent=1

that may help a bit

 

[JamesLean]

Add the @ in front of the maxdate variable when calling the SP.

--James

 

[mimi2]

I am the one who's on crack!!
@ was missing as JamesLean pointed out.
Thanks a lot.