Ramco Ramco

Ramco Ramco

  • 465
  • 2.8k
  • 394.7k

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)