Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
SELECT CASE WHEN CAST(GETDATE() AS DATE) = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) THEN 1 ELSE MAX ([' + @ColumnName1 + ']' + ' ) END Output' + ' FROM [dbo].[' + @tableName + ']'
select max (cast(ref as int)) as ref from table1 order by ref