CREATE TABLE #TestData (
SampleTime DATETIME
);

INSERT INTO #TestData ( SampleTime )
VALUES ( '2017-03-27 09:24:00.000' )
  , ( '2017-03-27 09:48:00.000' )
  , ( '2017-03-27...

Reported as spam

Your requirements for filtering the data are quite vague.
The code below will join the data, and return it all.  You can tweak the WHERE as needed.

The reason that you are getting duplicates is because your source data is all the same. If you want to prevent duplicates in your results, then you need to find...

This should do the trick

CREATE TABLE #Company (CompanyID INT, CompanyName VARCHAR (100));
CREATE TABLE #KVPairs (CompanyID INT, KeyColumn VARCHAR (100), ValueColumn VARCHAR (100));

INSERT...

You can try this

INSERT INTO DCert (stateID, custnumber, lastname, firstname, mailAddress)
WITH cteData AS (
SELECT
  DC.[State Id] as stateID
,...

Does this give you the required output?

-- This date is used so that SQL does not get an overflow error when calculating a large time...

It seems you have an issue with duplicate records for PartNum, DueDate, Quantity).

This should do the trick

WITH cteBaseData AS (
SELECT
  PartNum

Reported as spam

This sounds like a running totals issue.

Something along the lines of .....
SELECT as many random questions as needed
WHERE QuestionType = 'Short Note'
AND QuestionComplexity...

What about an option to MARK ALL AS READ.
Then when looking at the UNREAD tab, we can start with fresh data.