Hmm, interesting. I could replicate the problem, but not with SSMS. Strangely it was Outlook 2016 that wanted my attention. SSMS was happy to plum away

I almost wonder if...

I'm yet to try out the feature myself, but I imagine it very much to be like the Multiple Desktop functionality that many Linux distributions have had for some time....

My above post, using Drew's groundwork, provides exactly what I need 🙂

VastSQL (1/3/2017)

---

Thanks Guys.

The file is uploaded to application server itself initially and then data gets inserted into multiple tables once the validation is complete. The validation checks in many tables...

You've only provided one line of sample data, so unsure this will work (I've guessed that the date is always at the end, and in the format dd/MMM/yy):

USE DevDB;

GO

CREATE TABLE...

What method are you using to upload and process the file? Is the file being uploaded to a Filestream table or a file system?

How is SQL reading the file, SSIS?...

Little confused firstly, are you using MySQL or SQL Server? You make several references to MySQL however this is a SQL Server forum, so which are you actually using? SSIS...

On the subject of allowing others to view, will they be accessing the report web portal directly (is that your intention, or how you want them to). If so, you...

This is to be expected. Functions require every parameter to be passed, regardless of if you're going to use them all.

Try:

SELECT * FROM dbo.Employee(@ID, @SCR, '*', DEFAULT);

I'll need to test some more when I return to the office after the New Year break, I don't have the data at home, but here is my solution incorperating...

Thank both, unfortuantely neither, at present do not meet specification (however, are close).

Although, with the data I have are correct, would not work with others where the rating from...

Kevin is correct. If visuals are that much of a problem, either align the columns yourself or create the report is SSRS and define it in your design.

Exporting straight from...

Sounds like the xml for the document is poorly formed. This could be for a number of reasons.

For example it could be that you have a name of a sheet...

This looks like your query before, but without the OR. Not sure if it should be there, but I have ommited it.

I haven't tested this mind, as I don't have...

A simple OR Statement will suffice.

AND (tblDataPermit.ExpirationDate <= @ExpirationDate

OR tblDataPermit.ExpirationDate IS NULL);