Re: Sql Joins by Robert
Robert
Tue Oct 28 09:15:59 CST 2003
Unfortunately, This team has many stored procedures that
do what I have described .... I am moving them slowely to
a change of mentality however, It will take time ...
sounds like an interop call to ADODB for the time being!
- Rob
>-----Original Message-----
>Now I see what you mean.
>We decide this poblem the way that we return only unique
column names. I
>mean, we create
>aliases for the same column names, so in the result
record set they all
>have different names. Logically, those columns should
have different name,
>shouldn't they?
>I think it's not a bad approach:)
>
>Hope this will help somehow.
>
>Sergey.
>
>"Robert Morris" <robertcmorris@bellsouth.net> wrote in
message
>news:096c01c39d46$eb12df60$a601280a@phx.gbl...
>> I am working with a crew that is writing stored procs
>> that return mutliple table aliases to the same table.
>> Thus I am getting multiple identical column names. They
>> are asking for functionality similar to what you had in
>> ADODB which returns table aliases with the column name.
I
>> believe that this was a bad side effect of a connected
>> recordset though. Is this correct, or do you know of a
>> way to get table alias names with the column name?
>>
>> Thanks,
>> - Rob
>>
>> >-----Original Message-----
>> >I use middle tier, which executes SQL stored
procedures.
>> >Procedures return record sets and use INNER joins.
>> >I don't have any problems.
>> >What problem do you experience exactly?
>> >
>> >Sergey.
>> >
>> >"Robert Morris" <robertcmorris@bellsouth.net> wrote in
>> message
>> >news:04ab01c39cfd$640f2940$a601280a@phx.gbl...
>> >> Anyone have any experience working with middle tiers
>> and
>> >> Stored Procedures with INNER Joins and OUTER JOINS.
If
>> >> so, I need some suggestion on how you handled tables
>> >> aliases.
>> >>
>> >> Thanks,
>> >> - Rob