Re: Different results between SQL Server and SQR

[Al H <star111lists@MINDSPRING.COM>]

Do you have some kind of variables in the code that you are replacing
with hard coded values to make it run in QA?

It would be helpful if you pasted your SQL code here...

On Mon, 27 May 2002 10:18:55 +0100, you wrote:

>I've got a problem where I've written some SQL to basically retrieve both
>employee details and their manager's ID and name for use in an SQR.  Due to
>several customisations the manager's details are retrieved from a view.
>When the SQL is run in Query Analyzer, it works as expected.  However when
>this exact SQL is transplanted to SQR, it returns the correct manager ID
>but one single manager name for everybody.  Does anybody know of any
>strange differences in intepretation of SQL at the SQL Server vs SQR level?
>
>Thanks
>Greg
>