• Edward-445599 (6/18/2013)


    Bhaskar.Shetty (6/18/2013)


    Whenever you fire same query second time or more, it will be faster anyways as it will pick the result from cache and gives faster results. This may be the reason for this.

    Hi I am aware of that , sorry I didn't make myself clear, interchanging between the two queries , one with no line breaks and one with line breaks causes a different execution plan to fire

    care to share the queries and exec plans?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day