Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Why am I getting a T-SQL error near the SELECT verb? RE: Why am I getting a T-SQL error near the SELECT verb?

  • July 17, 2017 at 7:17 am

    #1951144

    sandyshin 42844 - Sunday, July 16, 2017 8:22 PM

    INSERT INTO  dbo.mixedwords (Mixed, MixLen, GoodVa)
    Values ( SELECT DISTINCT LTRIM(RTRim(mixVa) as NewTerm
                                , MixCnt 
                                , ValidVal 
                         FROM Sandbox
               )  
    Note: All objects are spelled correctly
            The SELECT query runs if highlighted and executed

    A missing closing parenthesis here, too: LTRIM(RTRim(mixVa)
    Not sure how it would still run if you just highlighted it and executed it.