If what you're looking for is to programmatically add items to the dropdown list (and I think it is) this would do the trick:

protected void...

Added table definitions, sqlplan and suggested query sqlplan. Same output btw, in no time, will need to check this a bit further later on...

Suggested NONCLUSTERED index speeds up...

CELKO (11/8/2016)

---

>> I'm having some trouble finding a solution to a problem, its been a few hours now and I think I just completely loose track of what I'm doing...

Hey, thanks for the help...

In the end I just couldnt make it work the automated way:

"for each record on a list of records with missing weeks insert missing weeks for...

A set of colorful juggling balls and truck shaped stress toy

/* date included */

-- A sensible way

SELECT FORMAT(GETDATE(), 'ddMMyyyyhhmm', 'en-GB')

-- The Rube Goldberg way

SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, GETDATE(), 103), '/', '') + REPLACE(CONVERT(VARCHAR, GETDATE(), 108), ':', '') AS BIGINT), 12)

-- The SQL#...

Jeff Moden (10/30/2016)

---

sys.user (10/30/2016)

---

Jeff Moden (10/30/2016)

---

What is your "week" based on", especially for the first and last week of the year where it's normally not a 7 day week? ...

Jeff Moden (10/30/2016)

---

What is your "week" based on", especially for the first and last week of the year where it's normally not a 7 day week? Also, do you...

This tool will sure help you in this particular task: http://www.sqlsecurity.com/downloads

PARTITION BY x ORDER BY x missing, thanks dude.

I decided to go with 2 new tables 'Stores' and 'Stock'

Stores if quite simple StoreID and Name

Stock with some data looks like:

================================================

StockID | MovieID |...

Yes it is, I was just too lazy to...

Well, since the original database was meant to work with single copies of...

Thats alright then... Thanks both for your help.