Just one more question. If I want for only to appear the fields  'MaxMinDesc' and the 'VacationHours' how would I do it? I have tried taking the asterixes off...

• This reply was modified 2 years, 6 months ago by  Ed B.

MinRN is the alias given to the rownumber ordered by vacation hours ascending. The lowest (or joint lowest) will get...

SELECT *,
       CASE WHEN MaxRN =1 THEN 'Max' ELSE 'Min' END AS MaxMinDesc
FROM (
       SELECT...

I have always used procs, maybe because I started with SSRS 2000 and it was terrible, so I did everything I possibly could in the database and just used SSRS...

I think there are two key things you need. Firstly the container needs to have a setting of MaximumErrorCount > 1 so that the it doesn't fail when the dataflow...

I just noticed that you are using MySQL so I really don't know, but GO...

It's almost a week later, what did you end up doing?

I am curious as to whether it is possible to stop the service and copy the data file(s)  with or...

This might work for creating a table of local date times when Eastern Daylight Savings and Central European Summertime start and end for the next 10 years (based on current...

It may be the permissions of the SQL Server Service account.

I just created a share and granted just myself permission to access it and I confirmed that I could in...

Have you set up the aaa directory as a share?

That path "\\ServerA\aaa\" presumably refers to a specific drive on the server.

I have an audit that I reference using a mounted...

I would recommend...

Are you sure it's not EDT?

Now I see why AWS defaults to Zulu time.

Does this work? I don't know if the extra level of nesting is required, or whether you can just replace the select * with a column list.

SELECT...

I would not use a row_number. Row_number is useful for returning a specific row. The requirement is to identify pat_ids that have multiple dx ,but do not have multiple excluded...

The null date is ordered after the valid dates (in descending order)  so will...

• This reply was modified 2 years, 7 months ago by  Ed B.
• This reply was modified 2 years, 7 months ago by  Ed B. Reason: typo