sql server limit

[bing]

I'm storing time series data in a table in SQL server 2000. The table
has columns like: CodeEquity, PriceDate, LastPrice. To extract the
last price for a number of equities on COMMON DATES I have used the
query:

select t.LastPrice,h1.LastPrice,h2.LastPrice,h3.LastPrice from
Blg_HistoricData t,Blg_HistoricData h1,Blg_HistoricData
h2,Blg_HistoricData h3
where t.CodeEquity=114151 and h1.CodeEquity=112220 and
t.PriceDate=h1.PriceDate and h2.CodeEquity=112580 and
t.PriceDate=h2.PriceDate and h3.CodeEquity=112228 and
t.PriceDate=h3.PriceDate

this works for about 20 self joined tables and then says syntax error.
I'm wondering what sql limits it hits. Is it possible to do this in
SQL for 300 tables?

Thank you.

[Gert-Jan Strik]

No, this is not possible for 300 tables, because the maximum number of
tables in one SELECT statement is 255 (may be one more or less).

With 20 tables, this should still work. You could try adding OPTION
(ROBUST PLAN).

Hope this helps,
Gert-Jan

bing wrote:

I'm storing time series data in a table in SQL server 2000. The table
has columns like: CodeEquity, PriceDate, LastPrice. To extract the
last price for a number of equities on COMMON DATES I have used the
query:

select t.LastPrice,h1.LastPrice,h2.LastPrice,h3.LastPrice from
Blg_HistoricData t,Blg_HistoricData h1,Blg_HistoricData
h2,Blg_HistoricData h3
where t.CodeEquity=114151 and h1.CodeEquity=112220 and
t.PriceDate=h1.PriceDate and h2.CodeEquity=112580 and
t.PriceDate=h2.PriceDate and h3.CodeEquity=112228 and
t.PriceDate=h3.PriceDate

this works for about 20 self joined tables and then says syntax error.
I'm wondering what sql limits it hits. Is it possible to do this in
SQL for 300 tables?

Thank you.