Correlation Names -- sql server data warehouse

Adam Machanic
3/21/2005 1:37:06 PM

I'm not sure how you change them in what you're doing, but a correlation
name in a SQL Query is a synonym for a table or column's actual name. For
instance:

SELECT SomeOtherTable.SomeColumn AS SomeOtherName
FROM SomeTable AS SomeOtherTable

In this query, SomeTable will be treated as "SomeOtherTable", and SomeColumn
will be returned as "SomeOtherName".

Apparently, you have two columns coming back with the same name. Change one
of them...

--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

[quoted text, click to view]

Pushpendu Sharma
3/22/2005 12:04:18 AM

Hi,

What is correlation name and how can I use it? I get this error when trying
to process the cube for the first time using DSO.

An unhandled exception of type 'System.Runtime.InteropServices.COMException'
occurred in AutomatedCubeCreation.exe

Additional information: Tables or functions 'ScanGeographyProductTime' and
'ScanGeographyProductTime' have the same exposed names. Use correlation
names to distinguish them.;42000

--
Thanks,
Pushpendu

sql server data warehouse : Correlation Names