In Query use variable like Dynamic SQL

Question

Hi All,

I have 1 query in sql server.

DECLARE @sqlWhere VARCHAR(MAX)
SET @sqlWhere = 'flg_active = 1 order by CreatedDate'

Select * from TableName1 where @sqlWhere

Is it possible with out dynamic SQL.



Thanks,
Jitendra Patel