Can we at least see the stored procedure code?  Hard to fix something without seeing it.

Can't you just use CALCULATE() and IF/SWITCH to handle the different options? CALCULATE lets you override some or all of the current evaluation context. Wouldn't the difference between "early" and...

What's your expected result? What constitutes a "duplicate"? Two records that cancel each other out, like the last pair do?

Oh, if you're trying to restrict groups of users from seeing rows, then use Row Level Security. \

use data masking?

https://www.sqlshack.com/using-dynamic-data-masking-in-sql-server-2016-to-protect-sensitive-data/

Could you explain the context of what you're doing? If you have a table of days and some are marked as holidays, you don't need to store that information in...

• This reply was modified 6 years, 6 months ago by pietlinden.

Something like this?

use tempdb;
GO
CREATE TABLE HOLIDAY (DATEHOLIDAY DATE);
CREATE TABLE Times (DATEMONTH DATE, IS_WORK BIT);
GO
INSERT INTO HOLIDAY(DATEHOLIDAY) VALUES('2012-01-01'),('2012-02-01');
INSERT INTO Times(DATEMONTH,IS_WORK) VALUES('2012-01-01',0),('2012-01-02',0),('2012-01-03',1),
('2012-02-01',0),('2012-02-02',0),('2012-02-03',1);

Then the update is pretty simple, because the...

If the table already exists, use INSERT INTO instead of SELECT INTO (which creates a new table)

Can you set MAXDOP in just that misbehaving query so it runs fast while you sort out what's going on?

Nobody's going to read an attached (maybe virus-infected) file. Post your CREATE TABLE and INSERT scripts here.

Maybe JOIN() does what you want?

This is a standard recursive common table expression. Here's an article showing the solution: https://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/

WITH cteEmpH(EmployeeID, ManagerID, usrName, lvl)
AS (
 SELECT ID, ManagerID, usrName, 1 AS lvl
 FROM Employee
 WHERE...

• This reply was modified 6 years, 6 months ago by pietlinden.

Use a common table expression.

https://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/

Mockery? Everybody was a noob at one point. I've been fighthing with SQL Server for about 10 years and I still ask silly questions.

No, without the data engine installed on...

I would leave the tables separate. You can write a query/function in DAX to do the counts. If they're separate, it makes creating basic measures much easier.

LineNo is a reserved word in T-SQL. don't use it as a column name.