Posted by Jack Vamvas on 06/26/06 08:28

Have you seen this?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;836136

----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________


<bhushanvinay@gmail.com> wrote in message
news:1151201638.581707.126850@m73g2000cwd.googlegroups.com...
> i have a single souce table , Table a With contiains records for two
> different entries for the same vendor by different accounting
> instructions,
>
> BidId = 10,Person Name=ABC,PersonBidAmt=$100
> BidId = 11,Person Name=ABC,PersonBidAmt=$110
>
> now the recors are to be shown as
>
> Original Rcds Vs IntutiveRecords
> OrName,OrAmt,IntName,IntAmt
> ABC,100,ABC,110
>
> for this reason i use
>
> Select A.name,A.Amt,B.name,B.Amt
> from A
> leftOuterjoin B -- There are many reasons why i do a left outer join
> because i may not have the record in the b side at all
>
> but this is causing a very big performence issue as this view is very
> huge.31,000 records on each side is taking 2 minits to work.
>
> Could any one help me with this.
>

[Back to original message]