Using multiple IF ELSE in A multi-statement TVF Sql Server

Question

How can I use IF ELSE statements inside A multi-statement TVF ? My Cide goes like this

CREATE FUNCTION Production.ms_tvf_ProductCostDifference
(
@ID INT ,

)
     RETURNS @retCostDifference TABLE
     (
      ProductId INT ,
      CostDifference MONEY
    )
    AS
    BEGIN

    With ABC as 
     ( Select ------
     )
    if @ID ='1'
    //some code using ABC defined
    ELSe IF @ID=2
    //Somecode
    Return;
    END

How should be the flow?

I am getting some sytax errors.. on IF and insert statements — user2490024, Apr 15 '16 at 15:03
Update the question, don't add important information in comments — Panagiotis Kanavos, Apr 15 '16 at 15:04
As for the question itself - just check the syntax. Googling for "T-SQL IF" returns it in the very first result — Panagiotis Kanavos, Apr 15 '16 at 15:04

score 0 · Accepted Answer · answered Apr 15 '16 at 15:06

You cant use IF inside a WITH

instead you need something like this

  if @ID ='1'
    With ABC as 
         ( Select ------
         )
        //some code using ABC defined
  ELSE IF @ID=2
      With ABC as 
         ( Select ------
         )
      //Somecode
  Return;

Using multiple IF ELSE in A multi-statement TVF Sql Server

1 Answers1