I read your articles and the discussion threads, that's what prompted me to post my code when I realized no one had posted a solution to build a 4-4-5 calendar...

I know, old topic but better late than never.

I had to build calendar tables a while ago. Recently I was force to revisit this because of a little trick...

I'm puzzled :unsure:

I'm following the examples from the book I'm learning from which says that I have to uncheck "Inherit" this is actually what prevented it from working.

I enabled it...

I thought maybe I misunderstood what the "Inherit" column does so I decided to go 1 step further and add security to the dimension data.

In the Dimension Data tab I...

I don't really have a SQL Maintenance plan for my backups. I've created my own backup plan and implemented it with a bunch of jobs. I have 10...

Thanks a lot Jeffrey. I'll have to read that again tomorrow morning and look into it. I like the idea of keeping more than one full backup at...

In my post above I forgot to mention that I think I wasn't clear in my first post. I do not keep my full backups and transaction log backups...

Jeffrey you put your finger right on it. I was just copying/pasting my backup commands here and saw it.

BACKUP LOG [Database1] TO [Database1Log] WITH INIT , NOUNLOAD...

It looks like I'm on my own on this one. I'll post the code if I can figure it out.

I thought an example of what I'm saying could be useful so here's an example, I changed the field names to make it easier to read.

Database ...

You're right on the syntax errors, I was too quick in coding my test script and didn't see it. The fixed code however gives the same problem.

declare @tbl1 table

(

...

Thanks Michelle,

I should have paid more attention, I didn't see it.

Hi Shailesh,

That's similar to bhovious' solution but yours requires that I know the sizes which are in a table. If the sizescales are modified it would no longer work.

No Jeff, I only put it there for ease of read.

Michelle's I tried your latest suggestion. I had looked into using a pivot before but couldn't make it...

I'm playing with the idea of approaching it from the SizeScale table instead of the Invoice Table. For weeks now I've been trying to come up with a nice...