Thanks for the explanation, frodriguez.

Also note that "distrust" is too strong a word. I think "careful" would be a better subscription.

And I guess I forgot tot say in my orignal...

Reported as spam.

And a friendly reminder to anyone to be carefull when following links. This one might be legit, or it might be a virus. No way to tell, so...

Hi Steve,

First, thanks for not including surrogate keys in your ERD. They are an implementation choice, so they should never ever be in any ERD. (And let me stress the...

Oh dear. The design of the input table is quite awful - it violates First Normal Form by having separate columns for the months. This is called a repeating group,...

tony28 (3/1/2016)

---

First I think it was my mistake that I wrote "NameOfColumn" instead of right values... so DATE is char(8) like 20160302 and seq is char(4) like from 0001 till...

This is one of many reasons why you need some form of source control for your database objects. I know RedGate has tools that allow you to just restore prod...

Kenneth-1467 (3/1/2016)

---

I do have the same opinion with you guys that multiple databases are the most ideal. But this has been challenged by our architects that it would require...

If you want a tool to draw the pretty pictures for your data model, MS Visio gets the job done well enough.

There are also tolls that do way more, such...

There's your answered. You are licensed to use max 20 cores. Seems you are using the Server/CAL based licensing method and...

Let's see if I can do this without messing up - I want to reply to some of your questions in a different order, so I have to move bits...

At first sight, the data model looks okay. Of course I do not know the exact requirements. Also, every flavor of ER modeling has its own ways to represent optional/mandatory...

michal.lisinski (3/1/2016)

---

Thanks for suggestions, as Hugo wrote, looping through table records as a substitute for cursor is not the best solution.

I'm trying to find a set-based option to increase counter...

tony28 (2/29/2016)

---

Hugo Kornelis (2/29/2016)

---

So why not write this as

WHERE A.1PKCOLUMN='DATE'

AND A.2PKCOLUMN > '+SEQ'

That would make it far easier for SQL Server to estimate the cardinality, and...

So you want a different schema for each tenant, a single procedure with the tenant as a parameter, and no dynamic SQL?

Prepare to write lengthy IF ... ELSE IF ......

Laurie