Hi,
i need to run the following query in order to be able to create a dataset and bind it to my parameter which
is supposed to be a drop down.
what i am trying to do is creating a temp table to create a dataset for Month and Year drop downs
my problem is that , the query builder does not support 'Declare' so i am basically not able to use my query.
What can i do to create a drop down param and bind it to a dataset which is not actually running on an existin table in my database.
Thanks very much
Zahra
declare
@months table(
monthName
varchar (50),
monthValue
int)
insert
into @months(monthName,monthValue)
select
'January',1 union
select
'Feburay',2 union
select
'March',3 union
select
'April',4 union
select
'May',5 union
select
'June',6 union
select
'July',7 union
select
'August',8 union
select
'September',9 union
select
'October',10 union
select
'November',11 union
select
'December',12
select
monthName, monthValue from @months order by monthvalue asc