Not me.

Good thought. You are correct about my current use of the REST API. Will have a go at this at some point.

A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him....

Additionally, using options such as SET ROW COUNT are session wide and prone to unintentional mistakes if it is left active.  Additionally, if you are just playing in...

It's a warning, not an error. The help text provides a reasonable explanation as to why the warning has been generated.

The staging table / stored procedure route is the way I would go. T-SQL will likely blow away anything you can code in SSIS to do this.

You might find that you can expand the data ranges very rapidly in T-SQL, by joining to an appropriate calendar table or numbers table (it's hard to be sure what...

SET ROWCOUNT 10

SELECT ...

SET ROWCOUNT 0

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...