Sql Joins

  • Thread starter Thread starter Robert Morris
  • Start date Start date
R

Robert Morris

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
 
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.
 
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
 
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.
 
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
 
Back
Top