The problem is that your ON clause must not identify unique rows.

The other issue with your post is that the MERGE statement includes an ean column and the...

User1 must be given permission to impersonate user2, but I'd like to understand why ownership chaining[/url] isn't sufficient in this case, so please answer the following questions:

1. Are all...

The Windows event log will have the service stop and start events.

You also want to look at the database server to see if the SQL Server that hosts the report...

You need to use NOT IN.

Thanks Jeff, always nice to hear that from you.

I've never used bcp or BULK INSERT because I'm an SSIS guy, but if Luis and Jeff recommend...

First thank you for writing it to handle sets, that is probably the most common thing I need to correct in triggers.

There is only one thing I would change and...

I like Lowell's solution and I think it will perform better than an AFTER update trigger because the AFTER trigger will require 2 updates to take place while the INSTEAD...

This "works". It uses Jeff's DelimitedSplit8K function for all the splits (found here[/url]). If the answer to Jeff's question about "sloshes" 😛 is no, then this won't be...

I would suggest investigating using a numbers or tally table. This search, https://www.bing.com/search?q=Number+or+Tally+table, retunrs a bunch of posts about what a numbers or tally table is and how to...

hjp (3/14/2016)

---

Thank you for an interesting article. I find it less useful, though, when you rely on two assumptions:

1. SQL Authentication (and the willingness to store credentials in plaintext in...

Luis Cazares (3/14/2016)

---

Jack Corbett (3/14/2016)

---

CONVERT(DATE, ScheduledActivity.ScheduledDateTime)

As...

CONVERT(DATE, ScheduledActivity.ScheduledDateTime)

As the number of rows in the...

AS long as your Language setting is one where the default date format is...

What reporting platform are you using? You should parameterize the query and I'm sure whatever reporting platform you are using supports parameters.

The reason your query using ScheduledActivity.ScheduledStartTime = CONVERT(datetime,...

Duplicate post. Please put replies on this thread, http://www.sqlservercentral.com/Forums/Topic1769091-2799-1.aspx