You're not escaping your Dynamic SQL when you get to your variable. Thus the SQL you're executing is expecting a variable @facilityID,. which you haven't declared.

Try replacing the...

So, for your first step, you could do something like this:
DECLARE @FirstWD DATE;

SELECT TOP 1 @FirstWD = [Date]
FROM DimDate DD
WHERE DD.[Calendar Year] =...

What do you defined as a Business day? First weekday, or do you want to exclude public holidays (if so, are you storing details of public holidays?)? I simply the...

I still don't see any difference to your request to your original request. Does this not achieve what you want?
SELECT S2.student_rollno,
       marks, --Not sure...

You could try setting your bad rows to go to a different destination for now, for simplicity you could do it to a csv/text file. Then have a look at...

I might be missing something here, screenshots are not a good way to portray your data, but why not add an extra join, to your Subjects_Gradetype_junction table, and return the...

May I ask why you think a LEFT JOIN won't work for you? What's is your reasoning, have you tested?

Have a look at this simple example. Note that...

Took back up cycling last year, really enjoy that. Now that the clocks have gone back it's light after 18:00, so I can actually cycle into and from work again,...

An after insert trigger is still all part of the same transaction, it just means that the trigger happens after the insertion, rather than before or instead of. If any...

No need for temporary tables, you can do this with a simple aggregate and CASE statement:
SELECT COUNT(DISTINCT CASE WHEN T.TransactionId IS NOT NULL THEN E.EmployeeId ELSE NULL...