Home Forums SQL Server 2008 T-SQL (SS2K8) How to filter condition by column? RE: How to filter condition by column?
ssurve
SSC Enthusiast
Points: 176
More actions
September 22, 2012 at 10:18 am
#1541088
you can use dynamic sql as
declare @Col_List varchar(10)=',QTR1'
Declare @Sql nVarchar(max)='SELECT ACCOUNT'+@Col_List +' FROM TABLE_NAME'
EXEC @Sql