I'd suggest adding a Continuous Integration step into your setup. Just deploy the code, without data, into a database, on commit of the code (or a push to a...

It works perfectly for the given data.  Try deleting one of the dates and find out that the date doesn't appear in the result.  If...

To continue, one of my pet peeves are SQL lines of code that go off screen and dynamic SQL that comes out as a single line of code, especially when...

Just in case anyone else is having the issue... I've verified that I'm no longer getting email responses for posts that I've subscribed to or have responded to.  I've send...

Another simplification would be to use DATENAME for the year instead of casting the results of the YEAR(() function.

EDIT:  Sorry... I missed the -1 that was being done.

Post withdrawn.

You also list the 3 conditions, as follows...

If duplicate codes then invalid result

if 8 & another code then invalid result

if 9 & another code then invalid result

For the first rule,...

[Options table] 1 Option1 2 Option2 8 None 9 NotKnown

[Answers table] Student Answer 100 1 100 2

101 1 101 9

Student 100 answers are valid. Student 101 answers are not...

I'd be a bit concerned about that process... it sounds like...

p.s.  If you want to add a week number just add the following to the SELECT list...

,Wk = t.N+1

And thanks for the test data and the examples of the expected...

For some reason (mostly avoiding lots of "Logical READS"), I take great relish in avoiding Calendar tables, especially for things like this.

Here's the code I used...

--===== Solve...

Reminder... String_Split does not have an ordinal position of elements in the return in 2019.  You'll need to use DelimitedSplit8K or something similar.

I don't know for sure but, my guess would be, probably because the one person writing the QOD's has more than one job.  It's not easy to come up with...

SQLAgent is a scheduling/control program... not a data transfer program.  What is SQLAgent calling to do the transfer.  That's what you need to look at.

Hi, I am trying to process results to this question: "What optional subjects do you study?"

Results could be one or many of these options: 1 Option1 2 Option2 8...