As the previous poster mentioned, following the best practices will allow us to understand the issue at hand and avoid misunderstandings.

However, at a glance it looks like your issue may...

SELECT

*

FROM

TableA LEFT OUTER JOIN TableB on TableA.Account = TableB.Account

WHERE

TableA.HCS_Code != TableB.HCS_Code

OR

TableB.HCS_Code IS NULL

Howdy,

It looks as though your issue is the number of single quotes around CurDBSchemaVersion

Try:

When @import_type = 'UserDetails' Then

'exec master..xp_cmdshell ''bcp "Select v.EntryValue, FirstName, GroupID From VC..UserDetails LEFT JOIN VC..UserGroup ON...

I'm slightly confused by something here...

I think the solution you provided will only return results where there have been 10 updates within 5 days if the customer in questio's first...

This is behaving exactly how I'd expect, I understand what you're saying about call numbers... but this isn't an insurmountable issue.

I think your looking for a technical issue / solution...