so i am using database expert ->ole db (ado) ->selecting the server -> then Add Command. I have a sql statement that accepts two parameters, year and week number. I am having some issues with using the Add Command to Report dialog box. I create the parameters, replace them in the code, but only get errors.

Here is the actual SQL statement...

declare @DesiredYear int

declare @dYear varChar (20)
set @dYear = 2011
set @DesiredYear = @dYear

declare @DesiredWeek int

declare @dWeek as INT
set @dWeek = 5
set @DesiredWeek = @dWeek



This works fine. This what it looks like in the command window

declare @DesiredYear int

declare ?dYear int

set @DesiredYear = {?dYear}

declare @DesiredWeek int

declare ?dWeek as INT


dWeek and dYear are the parameters created in the command view and @DesiredYear and @DesiredWeek are used throughout the sql itselt, hence trying to set the entered parameter to the variable.

yeah sorry about the lack of detail. So the ?dWeek and ?dYear, are the declared variables. i took the {}'s out as trial and error.

declare @DesiredYear int
set @DesiredYear = {?dYear}

declare @DesiredWeek int
set @DesiredWeek = {?dWeek}

i changed it to this and it worked! Thanks