4
Answers

Incorrect Syntax near the keyword End

Ramco Ramco

Ramco Ramco
1y
443
1

Hi

SET @frDate= "01/04" +  (CASE WHEN (MONTH(GetDate())) <=3 THEN convert(varchar(4),
  YEAR(getDate())-1) else "01/04" + convert(varchar(4),YEAR(getDate()) End

Thanks

Answers (4)
Next Recommended Forum