Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shelly1
Starting Member
25 Posts |
 Posted - 2009-06-22 : 05:54:07
|
| Hello Can anyone help, i have created two drop down lists, 1 for the year and 1 for the month however i keep getting the error msg below.Can anyone shed any light.Must declare the scalar variable "@ Year"Code usedWHERE (Year = @Year) AND (MonthNumberOfYear = @Month)Many thanksMich |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-22 : 05:59:37
|
1. Where have you created the two dropdown lists? Remember we can't see your screen.2. How are the values from dropdown lists related to the code snippet?3. Are you using another tool such as Reporting Services?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Error msg