Search results for query: *

Wow, thanks Mark. I see I have a lot to learn with this stuff, but what a great example I can learn from as I implement and test with this. CB

Hello, I've got this which is working without the WHERE clause (or when WHERE 1 = 1) and am trying to get this to work with the MAX(FileLoadDate) in the filter condition. I'm comparing to the variable values which is working fine, but when I try to run this with a WHERE clause with a nested...

Thank you both for your responses. This stored procedure is going to take in the FileName from an SSIS package, with the prior steps being that both the Submission table will be truncated, so we'll always be sure that the detail records in the Submission table belong to the MAX record in the...

Hello, I'm taking in the string comparisons I need, but now need to just update a column in another table based on this result. Here's a snippet of what I'm trying to accomplish with a CASE WHEN THEN END but it isn't working: SELECT * FROM TestSubmission t CASE WHEN t.Region <> @region THEN...

Actually, I realized that all I need to do at this point is simply loop through values in another table and compare thos, so the heavy lifting ahs been done. It works a treat, thanks again for the assist!

Hi Simi, I added a missing parentheis on the end and it worked! Fantastic! So, can you show me an example of how I would apply this string parsing logic to records as I loop through them? Thanks, Bruce

Hi Simi, OK, I think I'm tracking this. Let me give it a whirl and I'll let you know how it goes. Thank you very much for taking the time out to reply. Bruce

Hello, I am writing a stored procedure to compare values within a File Name stored in one table to the stored values in another. Here is an example of the filename: TESTCOMPANY_ABCD_23_NEW_SUBMISSION.txt. The filename along with a timestamp is stored in a table named SubmissionManagement...