none
Using WHERE clause with CROSS APPLY get error

    Question

  • Dear All,

    I have a select statement below that return a result set without any error: 

    SELECT * FROM

    SVY.SQL_SSV_QA_OUTLET_DATA AS F
    CROSS APPLY REF.SplitX(F.RE_TEXT, ',')

    The error come when I try to add the where clause before the CROSS APPLY

    SELECT * FROM
    SVY.SQL_SSV_QA_OUTLET_DATA AS F
    WHERE F.START_DATE BETWEEN  '2014-03-01' AND '2014-03-30'
    CROSS APPLY REF.SplitX(F.RE_TEXT, ',')

    Msg 156, Level 15, State 1, Line 4
    Incorrect syntax near the keyword 'CROSS'.

    Am I doing anything wrong here?

    SAM

    Friday, May 16, 2014 7:03 AM

Answers

All replies