No, it's a member of the db_datareader role and the only other permission is the Execute on dbo.

This works with the data provided.

Selectdistinct

a.EmplID,

Case when c.EmpID is null then b.Designation else c.Designations End as [Role]

from #EmpIDs a

inner join #EmpRoles b on a.EmplID = b.EmpID

left outer join #LatestRoles c...

My 2 penn'orth; I think the error you're getting is from an attempt to execute the stored proc with a connection that isn't open so you're not seeing the message...

We need to copy some columns for new and amended clients from an in-house database to a 3rd-party one. The original process involved copying the data to an intermediate database...

I would try;

select distinct top 100

i.invoice_id, i.buyer_code, i.submit_time, i.request_id

from

dbo.invoice i

inner join dbo.invoice_adj ia on i.invoice_id = ia.invoice_id and ia.amount !=0

left outer join dbo.invoice_detail iad on i.invoice_id = iad.invoice_id

left...