SQL Subquery containing OpenRowset - Syntax error - Incorrect syntax near ')'

Question

I don't see the syntax issue below. I'm using a subquery, because I'm building it up to do a cross-apply once I get that figured out.

 SELECT 
   BulkColumn
   FROM
     (
      SELECT CAST(BulkColumn AS xml) as BulkColumn 
            FROM OPENROWSET(BULK'c:\Flight03.xml',SINGLE_CLOB) as T
      )

Error: Incorrect syntax near ')'.
       Line # refers to the closing parenthesis at the bottom

The subquery, when run by itself works fine:

      Select CAST(BulkColumn AS xml) as BulkColumn 
            FROM OPENROWSET(BULK'c:\Flight03.xml',SINGLE_CLOB) as T

So shouldn't I just be able to wrap it with parentheses and use it in another query?

TomStroemer · Accepted Answer · 2020-05-21 18:39:57Z

2

You need a name for your subquery. Try this:

SELECT 
   BulkColumn
   FROM
     (
      SELECT CAST(BulkColumn AS xml) as BulkColumn 
            FROM OPENROWSET(BULK'c:\Flight03.xml',SINGLE_CLOB) as T
      ) Sub

answered May 21, 2020 at 18:39

TomStroemer

1,6101 gold badge13 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

danghyan · Accepted Answer · 2020-05-21 18:48:32Z

1

after subquery in from u must set name for it

select ... From (...) *name*

answered May 21, 2020 at 18:48

danghyan

1213 bronze badges

Collectives™ on Stack Overflow

SQL Subquery containing OpenRowset - Syntax error - Incorrect syntax near ')'

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related