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 |
|
benko
Starting Member
24 Posts |
 Posted - 2004-11-02 : 11:04:55
|
| OK, i have params coming in @temp1 and @temp2. How come in my select statement when i go rxColumn = @temp1, it says i must declare the variable. What the... Thanks in advance |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-11-02 : 11:07:57
|
can we see a little more??Are you using dynamic SQL?Corey |
 |
|
|
benko
Starting Member
24 Posts |
Posted - 2004-11-02 : 11:09:58
|
| it seems pretty simple like thisCreate proc ProcName( @param1 varchar(20) = null ,@param2 varchar(20) = null)ASselect rxField1 = @param1, rxFeild2 = @param2....and it says i must declare them.... |
|
|
|
benko
Starting Member
24 Posts |
Posted - 2004-11-02 : 11:11:39
|
| n/m dude i got er...stupid mistake..missed the 'rxfield' + @param1 |
|
|
|
|
|
|
Stored Proc Question....