Re: Correlation Names

[Adam Machanic]

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
--

"Pushpendu Sharma" <pus...@hotmail.com> wrote in message
news:OilnEQkL...@TK2MSFTNGP10.phx.gbl...
> 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
>
>

[Pushpendu Sharma]