Post reply

Stored Procedure and SELECT statement return different results

  • December 4, 2014 at 10:02 am

    #1762776

    I got the answer (from StackOverFlow, ahem). I need to fully qualify my object names. We have a mobile.Employee table and a dbo.Employee table. Three of us were staring at this and didn't see it.

  • December 4, 2014 at 12:03 pm

    #1762798

    Glad to hear you got the answer.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • December 5, 2014 at 3:10 am

    #1762901

    Melanie Peterson (12/4/2014)

    I got the answer (from StackOverFlow, ahem). I need to fully qualify my object names. We have a mobile.Employee table and a dbo.Employee table. Three of us were staring at this and didn't see it.

    Could you please clarify ,Do you mean to say that SP execution was using Mobile schema and the simple Select query was using dbo schema ?

  • December 5, 2014 at 7:50 am

    #1762972

    Yes, that's exactly what I mean.

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply