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.

 All Forums
 Other Forums
 Other Topics
 Where conditions in a Select Statement

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.
   

- Advertisement -