I suppose that foreign key constraints on MySQL do not fire in the same transaction context as the distributed transaction. That would be very hard to demonstrate though.

Dateadd accepts integer units, so your only option is using a smaller interval such as seconds and do your math outside the function call.

I think it has to do with the way MySQL paticipates to distributed transactions. Did you check the rows are there after the first insert (with another OPENQUERY statement in...

Not enough information.

You didn't read the article I suggested, did you?

Let me say it again: read it (here's the link http://www.sqlservercentral.com/articles/Best+Practices/61537/) post the information in the format described in the...

You really don't want us to go through hundreds of lines of code? Please explain the problem in plain English: it will be faster.

Please also post table definitions as CREATE...

Glad I could help

My bad, I forgot to delete the last line

SELECT AVG(UnitPrice) AS [Average Unit Price], AVG(Quantity) AS [Average Quantity], SUM((UnitPrice * Quantity) * (1...

I suppose this is what you want:

SELECT AVG(UnitPrice) AS [Average Unit Price], AVG(Quantity) AS [Average Quantity], SUM((UnitPrice * Quantity) * (1 - Discount))...

This seems to be what you're after: https://msdn.microsoft.com/en-us/library/ms179250.aspx?f=255&MSPPError=-2147217396

If you want an alternative method, the simplest thing I can think of is to create a view with 12 of the 14...

I performed some tests and it looks like it's not completely true (as far as I can tell):

-- SETUP:

-- 1. Create a linked server

-- 2. Execute this at both...

Looks like you're right. The only reference that I could find is this page in Paul Randal's blog: http://www.sqlskills.com/blogs/paul/worrying-wait-type/

It works with 2008 and above.

Quick tip: the Data Collector can do that for you.

It's a feature that people have long asked for, but it's not available directly. In Oracle, this is called "Autonomous transaction" and is used exactly for this kind of tasks...

This project will help you for sure: https://scriptsqlconfig.codeplex.com/