| rip.murdock 2005-08-31, 8:24 pm |
| I’ve utilized Openrowset with Select…Into to dump the results of an
MDX query into a new table created on the fly. I’ve attempted to
reference the results using the INFORMATION_SCHEMA.COLUMNS table to
build a dynamic T-SQL statement, T-SQL doesn’t recognize the column
names that are automatically assigned to these columns because they
contain “.” The first four column names are
[Date].[Year].& #91;MEMBER_CAPTION],
[Date].[Quarter].& #91;MEMBER_CAPTION],
[Date].[Month].& #91;MEMBER_CAPTION],
[Date].[Day].[MEMBER_CAPTION]
When selecting the first of these, I get this error message.
The column prefix 'Date.Year' does not match with a table name or
alias name used in the query.
If I enclose the column name in brackets, selecting
[[Date].[Year].& #91;MEMBER_CAPTION]]
I get this error:
Unclosed quotation mark before the character string 'MEMBER_CAPTION]
I could also select these columns by ordinal position, but I do not
believe that is possible in T-SQL.
Any other suggestions?
|