This post makes no sense. Why would you have an OrderId in a Customer table!?

Also there is no DDL, including the primary key, so the best that can be done...

I am not sure what question/problem is.

A few basic points to note:

1. Oracle effectively works as SET IMPLICIT_TRANSACTIONS ON so third party applications, which target multiple dbs, tend to work...

• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.

WITH ChangeDates
AS
(
    SELECT R.TeamId, R.PersonId, D.ChangeDate
,MAX(CASE WHEN R.RoleName = 'Manager' THEN X.StartEnd END) AS Manager
,MAX(CASE WHEN R.RoleName = 'Leader' THEN X.StartEnd END) AS Leader
,MAX(CASE...

Or dynamically:

/* Should be able to get this from a role table without DISTINCT
SELECT DISTINCT RoleName
INTO #Roles
FROM #AssignmentRange;
 */

 SELECT RoleId, RoleName
 INTO #Roles
 FROM
 (
 ...

WITH ChangeDates
AS
(
    SELECT R.TeamId, R.PersonId, D.ChangeDate
        ,MAX(IIF(R.RoleName = 'Manager', X.StartEnd, 0)) AS Manager
    ...

• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.

Try returning LogDate as a datetime2 instead of datetime. Some programs, like Excel, do not format datetime very well.

The total rows suggests you have not SET NOCOUNT ON; at the...

• This reply was modified 2 years, 3 months ago by Ken McKelvey.

As you are using a trusted connection (-E for SQLCMD) it might just be easier to exec a signed stored procedure. I cannot test anything at the moment but something...

• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.

Thanks. That is certainly worth thinking about.

Sorry for the late reply.

Currently we have an onsite system where images/documents are stored in the database. We are considering if these should be placed on the file system, or...

You might be able to use Convert_HtmlToXml in the following to get XML which you might then be able to process as you want.

https://sqlsharp.com/features/

I suspect it would be better...

Yes. I would have thought this is the main use of Micro...

Fair enough, the SQL generated by EF is a lot better than it used to be. It is just my experience that...

While EF has some nice advanced features, is there any reason why the bulk of the DB access cannot be done with Dapper and...

What is an AOR job?

If ESP means...

I have experience with two large systems - one with FILESTREAM blobs and the other using normal blobs.  Both ultimately got migrated out of the database into an object...