Tell your boss to stick to defining functionality, and leave the implementation to those who are...

After taking a quick look, I can tell you that you are right.

The UPDATE FROM used in the trigger will affect all rows that match an inserted/updated row on the...

Doom

The behaviour is as expected.

SQL Server will always first compile an entire batch, then execute it. During compilation, various things are checked against the schema. But modifications made by early...

SQL Guy 1 (1/22/2016)

---

Hugo Kornelis (1/21/2016)

---

But a way more important question is what you/they are trying to achieve. If the report is such that some margin of error in...

From...

I quickly scanned the posted code. The problem is that the layout is like this:

WHILE (condition)

BEGIN;

BEGIN TRY

-- Do something that might fail

-- Find next row to process

END TRY

BEGIN CATCH

-- Handle...

Your problem stems from the fact that the SQL Server Query Optimizer can rearrange conditions as it sees fit. With the equality constraint it apparently picks an execution plan where...

Here's a quick attempt:

PS: For a tested solution, please post CREATE TABLE statements, plus INSERT statements with sample data, plus expected results.

WITH HelperCTE AS

(SELECT *, SUM(CASE WHEN Identifier = 'SET'...

Since TransDate...

boettger.andreas (1/22/2016)

---

Hi, I'm doing inventory snapshots for each of the last 12 months.

For this I need to sum up all transactions up to the month I'm looking at.

The function would...

In the report designer, select the cell you want to color code. Go to the properties, find the color (either foreground or background, whichever one you want), and replace the...

Please post CREATE TABLE statement for the table and INSERT statements with your sample data, plus expected results for that sample data.

Also, why exactly do you need this? This kind...

Since this appears to be a homework assignment, I am not going to spoon-feed you the answer.

But I will help of course. Your query contains an aggregation (the AVG function)...

If the date column is indexed, then you will probably get better performance if you select the month as "WHERE Date >= 20160100 AND Date < 20160201"

Also, instead of having...