using active perl 5.8 and windows sql server 2000 executing sql statement which has complex sub queries using perl DBI DBD::ODBC get below error

DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL 
+Server]Internal Query Processor Error: 
The query processor ran out of stack space during query optimization. 
+(SQL-42000)(DBD: st_execute/SQLExecute err=-1)

[download]

the same sql statement gets executed successfully in sql server query analyzer or through asp page using adodb 

$sth=$dbh->prepare($sqlarr[2]);    
$sth->execute($reportstartdt,$reportenddt);

[download]

after sth execute get error

i am unable to understand whether problem is in perl or in sql server

any help or pointers for resolution will be helpful thanks in advance
krishna

Code tags and formatting to match original input added by davido.

In reply to perl DBI error by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.