Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rip.murdock
Starting Member
4 Posts |
 Posted - 2005-08-31 : 21:00:32
|
| I’ve utilized Openrowset with Select…Into to dump the results of an MDX queries 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 screen, 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].[MEMBER_CAPTION],[Date].[Quarter].[MEMBER_CAPTION],[Date].[Month].[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].[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? |
|
|
|
|
|
Referencing MDX Query results in SQL Server