Steve.

I have a question about the rCTE example. In the rCTE, the Product Assembly is "decomposed" into parts, which is then decomposed again (in the rCTE)… but how do you...

• This reply was modified 6 years, 3 months ago by pietlinden. Reason: Clarification

Do you have some sample data?

CREATE TABLE scripts, INSERT scripts, please.

a heap is a table without an index - it's unordered. You can't reorder something that's not ordered by an index.

Okay, sorry everybody. I found out that the question was way easier than I thought. (That's what happens when you don't get scripts to recreate the tables and data and...

I'm an Aspie too, so I can kind of see where David is coming from. talking to "paper" or typing on a computer might be easier because there's so much...

I think I remember your article about "Find all pilots that can fly all the planes" question. (Yep, that's the one!)

Is there a way to process the "build orders" without...

Wouldn't you declare a variable to hold the filename and then use .NET functions to parse out the chunks you want that make a date? Then compare it to some...

If you're trying to get a count of enrollments for each day, then you would need a Calendar table of some kind. Are you trying to count the number of...

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

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