untested, but this might give you an idea.

percentage is # ontime / Total,typically limited by a period of time (a month?)

due to integer division in SQL, you need to convert...

nice solution from Hugo, as always;

for me, i really hate running totals stored in the table itself; plus it's breaking some of those rules for normalization, of course.

eventually, the...

i'm betting Sean Lange's suggestion that your left join converted to inner is your core problem:

modify your join criteria like this, doe sthat solve the issue?

SELECT

ord.CustomerId,

...

User2 has to be created with the correct roles and permissions in the new database.; permissions in the old db would not make any difference;

sounds like he has rights...

i think this is an Oracle question ffor the psuedo column rownum that is materialized in that RDBMS:

https://docs.oracle.com/cd/B28359_01/server.111/b28286/pseudocolumns009.htm

Conditions testing for ROWNUM values greater than a positive integer are always false....

it is absolutely allowed, and works...

rownum would have to be a real column name, right?

if it is an alias for the row_number() functions's results, no results would occur if your table only had...

there is no alert for that specific condition(where a spid exists with value = -2.)

so you cannot use Alerts, specifically.

for specific events you can capture, you can have an event...

it looks like you've got a process, maybe a sql job or windows scheduled task, that runs every five minutes?

might also be an application or Service, installed on the...

if your source has multiple lat/long for a postal code, you'd get the error;

you need to limit to a single "missing" postal code

WITH MySource

AS

(SELECT ROW_NUMBER() OVER (Partition By PostImp.ZipCode ORDER...

yes, with a data driven subscription(if you have enterprise) ; more info is needed obviously, but if the report has a parameter for UserId or email to generate an...

there are two specific, separate free downloads called SQL Server Data Tools(SSDT /SSDT-BI) that are related to SQL server 2014, so that you can do Data related projects or...

martin 48305 (12/4/2015)

---

I am having the same problem with an even simpler UPDATE statement: UPDATE ... SET ... WHERE. Even though the fields that are updated already exists with the...

Michelle-138172 (1/11/2016)

---

Thanks for the input.

I checked the SQL Server Agent and the mail profile is enabled for the Alert System.

There is no error message in the mail tables either.

The...

SQL server cannot connect to a POP3/IMAP a server to pull down the mail natively.

you can do it in a programming language like c#/VB.net, which also means you can create...