SP excel recorset error ?
-
hi,
SP PİVOT table ODBC excel connection recorset.open return failed .
Msg 102, Level 15, State 1, Line 56
Incorrect syntax near ','.
EXEC@return_value = [dbo].[A_URTPLN_]
query attach SP
-
I'm not excel expert, but the query you attached is not complete. The code ends with a "," which tells me there is at least one more CTE that is being created before the final select. How are you building and executing this query in Excel? It looks like you have run out of characters in however you are attempting to execute it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply