Ramco Ramco

Ramco Ramco

  • 442
  • 3.4k
  • 517.1k

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)