1
Answer

Case Statement with Cte

Ramco Ramco

Ramco Ramco
3y
672
1

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)
Next Recommended Forum