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 |
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2000-08-04 : 00:00:00
|
percy writes "How do you place a where statement assigned to a variable into a select statemnt? I have built a where clause based on certain conditions in a stored procedure using SQL Server 7.0 and now that I have the where clause built, I wonder how to place it into the select statment. I have tried Where = @variablename,but that is bad syntax. Sorry if this is a newbie question, but I've looked through SQL Server books online to no avail. Thanks in advance for any advice"Percy, please see http://www.sqlteam.com/item.asp?ItemID=245. |
|
|
|
|