Apart from that your ALTER statement is missing a period, it should be ON [dbo].[JOURNAL], I can't see anything wrong with it.

What error are you...

@ben that doesn't give the correct answer, no, look at the OP's sample data. You've effectlvely just captured the next ReferralID in your query, something that would be much better...

Huh, interesting. It...

SSIS comes with an FTP task by default, however, you don't have much functionality with it (you can't check all the files on the server and get their age for...

Your question doesn't explain your logic. As i asked, I need to know why your output is what it is. To quote my previous post:

My confusion arises from...

You'll need to use a lookup table.

I've done this with a CTE, but if you have a true lookup table, you should use that.
USE DevTestDB;
GO

Please...

You're going to be hard pressed to get a solution then. As Eirikur pointed out, an escaped underscore in an = statement doesn't work(well, it searches for '[_]', not '_')....

The above also screams SQL Injection at me. Are your getting the values of @sqlstmt and @filterstmt from the SP's paramters?

What if I were to pass the following...