It could be that one / more tables in the join has data being loaded ( after truncating / deleting
) on a regular basis. So it might have had data during the 1 or 2 times u got the result

--- Khaled Harb <[Email Address Removed] wrote:
> Hi DBA's
> SQL Server 7.00, I have SQL statement that contain several left joins
> Problem appeared when running the same SQL statement several times – for
> example 10 times, it returns results for 1 or 2 times and 0 rows for the
> rest of times
> Can any one suggest a reason for this?
> Regards
>


=====
Ganapathy Sankara Baaham
60 Strawberry Hill Ave
Stamford CT USA

If u can dream it,
you can do it.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
MS Sql Server LazyDBA home page