The choice of device has many factors to consider, location where it is to be used would be my first concern. Using a device in a nice clean office where...

I agree with Jeff 🙂 However extracting the data and transferring to a secure ftp site at 1.1 sec per report is very optimistic.

Unlike me, jack of many trades and master of none. :-/ LOL

If Category is static (ie ALL is always 3)

SELECT j.Job,j.Category,ISNULL(c.Value,3)
FROM Job j
LEFT JOIN Category c ON c.Category = j.Category

Otherwise Scott's solution

I am by no means an expert in this but AFAIK the only error DBMail would have is with the connection to the destination SMTP server or a system error...

• This reply was modified 4 years, 1 month ago by David Burrows.

.....

We also have some complicated stuff we need to do to display on many screens in the GUI.  The application is under constant "improvement".  One of the things that...

• create a test job and send some mails to yourself.
• Send some emails with your own email address in BCC to find out if they actually arrive.
• As...

I'm no expert on this but have you checked your SMTP server that emails were received, whenever I have troubles like this it is invariably an SMTP issue. Are the...

• This reply was modified 4 years, 1 month ago by David Burrows.

Any solution will be difficult due to variations in format, however this may work except for Heparin as I cannot discern which value is which and also it will ignore...

• This reply was modified 4 years, 1 month ago by David Burrows.

And "The pot calling the kettle black" to boot :0/

I'd like to add my thanks as well, a great and thoroughly enjoyable presentation (and I actually understood it 🙂 ).

Lots of good stuff.

Now I just have to find IndexDNA...

Since SSIS is not SQL - it isn't the same - and the code is not processed as SQL code. Since the data is in the file -...

My point is that the list is so big I have a feeling you are chasing away people you might not want to. I see that list and don't...

Let's say you do create a CI on the combination of PatientID and DocumentID.  Now... ask yourself, what is the basis of each?  If they are as so many...

You're welcome and thanks for the feedback.