Ramco Ramco

Ramco Ramco

  • 1.4k
  • 697
  • 41.5k

Case Statement with Cte

Dec 17 2021 8:06 AM

Hi

  I am getting data from Cte

I want if @ICode parameter is not null then select statement should execute with parameter else all data

SELECT * from cteCab where icode = @ICode

else select * from ctetab

 

Thanks


Answers (1)