CODEWITHSUNDEEP
sqlsql-servert-sql
Neca24
Neca24

Reputation: 49

Incorrect syntax here?

SELECT B.code + '-' + LEFT(F.code, 1) + '-' 
     + CAST(ROW_NUMBER() OVER (PARTITION BY AT.[description]  
                               ORDER BY ID) AS VARCHAR(10)) AS [code] 
     + '-' + AST.CODE,

I tired with few options with () but nothing worked

SELECT B.code + '-' + LEFT(F.code, 1) + '-' 
       + CAST(ROW_NUMBER() OVER (PARTITION BY AT.[description] 
                                 ORDER BY ID) AS VARCHAR(10)) AS [code] 
       + '-' + AST.CODE,

Upvotes: 0

Views: 78

Answers (1)

mkRabbani
mkRabbani

Reputation: 16918

You have placed "AS [code]" in a wrong place inside the string operation. Try this-

SELECT B.code + '-' + 
    LEFT(F.code, 1) + '-' + 
    CAST(ROW_NUMBER() OVER (PARTITION BY AT.[description] ORDER BY ID) AS VARCHAR(10)) + 
    '-' + AST.CODE AS [code]

Upvotes: 4

Related Questions