DECLARE @parameters nvarchar(max)
SELECT  @parameters = '@FromDate datetime,
                       @ToDate datetime,
                       @Adults int
                       @CountryId int'
EXEC('EXEC sp_executesql N''' + @sql + ''', N''' + @parameters + ''',
   @FromDate = N''' + '2010-01-01' + ''', 
   @ToDate = N''' + '2010-01-10' + ''', 
   @Adults = N''' + 2 + ''', 
   @CountryId = N''' + 123 + '''')
Tuesday, July 14, 2009
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment