If they really are NULL (and not just empty strings), simply add a WHERE clause to your query:

WHERE NOT (LoanID IsNull and LoanNum is NULL)

For each file Extract the patient Id from the file name Check whether the extracted patient Id matches a row in the SQL Server lookup table If a match...

Is this the required process? If not, what is?

For each file
Extract the patient Id from the file name
Check whether the extracted patient Id matches a row in...

Hi - Need your help in this. Below is the scenario : 1. I have got of files with the format (Name_ID_PatientID_currenttimestamp.pdf), these files are generated daily. Highlighted yellow...

with all due respect, such constructions are "easier to read"  if you...

So the number of columns returned = (number 0f commas + 1), is that correct?

What happens if the number of commas varies by input data row?

What should the columns be...

I was using join in wrong order as i should use Dev as driver table instead of addrs in join conditions. but only issue with this as it's pulling NULL...

I do not have a solution, though maybe there is a a clumsy workaround.

Use the Transfer All Jobs option, then adapt your existing T-SQL to drop those jobs on the...

To (INNER) join table T1 in database DB1 to table T2, in database DB2, you can use this syntax (assuming you are running the query from the context of DB1)

SELECT...

• This reply was modified 6 years, 6 months ago by Phil Parkin.

I ran the query using your formatted query but it's just executing (running almost 7 minutes and still running) as looks like because of the CROSS JOIN, it's doing...

If there's a question here, I...

As far as I can see, BD.Morg.loan does not appear anywhere in your query. Are you sure about that error message?

Here is a formatted version of your query, which may...

A reformatted version. Don't know how you can read the one you posted!

SELECT [Event Type] = EventType
      ,[Company Number] = ccro
 ...

I guess I should have checked which forum I was in, before answering 🙂

You've been here long enough to know that providing pictures is not the best way of asking for help. Instead, please provide DDL, sample data in the form of INSERT...