Home Forums SQL Server 2008 T-SQL (SS2K8) Eliminate Dynamic SQL - WHERE Clause RE: Eliminate Dynamic SQL - WHERE Clause
Vishal Sinha
Ten Centuries
Points: 1174
More actions
October 5, 2010 at 1:16 pm
#1232022
Well using CUSTOMER_ID is one column they will use in the where clause. In actual scenario, the existing code may have a where clause for some other column - that's how the existing code is! it may as well be FIRST_NAME = 'xxx'