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, 8 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, 8 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.

This looks like it works...

CREATE TABLE #Test(
 col1 int,
 col2 int,
 col3 int);
GO
INSERT INTO #Test VALUES 
 (1, 203, 1232)
,(2, null, 2343)
,(3, 502, 15566)
,(4, null, 4566)
,(5, null, 4545)
,(6, 601, 4545)
,(7, 601,...

Forum Etiquette: How to post data/code on a forum to get the best help

Job security.

Can't you just right-click on the table and ...Script Table As... Insert/Update/Delete?

have you looked at windowing functions? RANK()? DENSE_RANK()?