Not sure I understand the problem fully, but is as simple as this? (I've done this from memory - forgive me if the syntax isn't 100%.)

USE MYDatabase;

IF...

• This reply was modified 5 years, 9 months ago by John Mitchell-245523. Reason: Removed rogue quotation mark
• This reply was modified 5 years, 9 months ago by John Mitchell-245523.

Yes, I meant to mention that performance would be horrible.  You do realise you're going to get false matches the way you've ended up doing it?  For example, 3045 would...

It looks as if tbl1 pads out the account numbers so that they're all the same length, by inserting 0s before the fourth to last digit.  If I'm right, you...

If you're only interested in connections, rather than what they're actually doing, then you only need to capture login events.  If your position is that nobody is connecting, but you...

This *was* good advice back in 2005, but now on SQL Server 2012 and above, table variables can be indexed, are dynamically indexed by default and fully accessible by...

Thanks Jeff.  I have now submitted my first ever Question of the Day!

John

If you need to do the import over and over then consider writing it using bcp or BULK INSERT.  If you really prefer to use the GUI then follow

• This reply was modified 5 years, 9 months ago by John Mitchell-245523. Reason: Added link to the article I mentioned

You need to build your SQL string dynamically, as you have done, and then pass it to sp_executesql, which should not be part of the dynamic SQL.  Here's some pseudo-code:

One thing I noticed is that the AND A.fpe_start_date >= ph.start_date line will turn your LEFT JOIN into an INNER JOIN.  I think you need that to be in your...

If you could provide the table DDL and sample data in consumable format, it would be easier for us to help you.

What have you already tried?  Is it as simple...

No, because, as the error message implies, you can't have dynamic SQL in a function. ...

It's still almost impossible to read if you put it all on one or two lines.  Try something like this (the only thing I've changed is the layout):

            
December 19, 2019 at 9:44 am
            
#3708990

            
            
                                                
        

I use this query to capture recent deadlocks.  If you run it in SSMS and click on the DeadlockGraph field, the XML will open in a separate window and you'll...

You could insert the result of the EXEC statement into a temp table and set the value of @result from there.  What I recommend you do, though, is use sp_executesql...

I recommend that you lay out your code to make it readable.  You'll find it much easier to spot errors that way.  I think what you need is a ")"...