Hi John

Yes, you are right. I'm just having a blonde moment. There is an IDENTITY key word in the other PK.

Thanks for showing me the error of my...

Hi John

I thought SQL would automatically insert values if it's a PK. Did I think wrong? I will research it, thanks.

Thanks Louis, I will see if there is something on SSIS/SSAS that I can use.

Thanks. I will look into it

Hi

No, it should use the getdate function, so that I can advance it to the next month without hard coding the date

Hi

Thank you for your response.

I most probably didn't make myself clear, my apologies.

It should be something like the following:

Select 1 AS Month1: 07/07/2015 where the part after the AS keyword...

Oh, ok. Thanks. It worked!

Thank you both for your reply but the integer dates are still hard-coded in your answers. And that's the problem that I have. Instead of 20141106 (hard-coded) I...

Thanks Stuart. You took the ugliness out of the code. 😀

Hi Stuart

Thanks for replying. Here is some sample data from the calendardefinition table:

KeyDateTransDateSmallTransDateNumericTransPeriodTransWeekOfYearNumberTransWeekOfYearDescrTransWeekOfMonthNumberTransWeekOfMonthDescrTransMonthDescrTransMonthNumberTransYearNumber

1NULLNULLNULLNULLNULL0NULLNULLNULL

201/01/1980 00:00198001011980.0111980 Week 0111980.01 Week 1January11980

302/01/1980 00:00198001021980.0111980 Week 0111980.01 Week 1January11980

403/01/1980 00:00198001031980.0111980 Week 0111980.01 Week 1January11980

504/01/1980 00:00198001041980.0111980...

Thanks Chris.

The problem that I have is that in the main query them MIN_keydate and MAX_keydate have null values, which creates a problem for me. Is there any way...

Hi Chris

Can I, for the last time, just run some idea with you, if you don't mind.

Kind regards

Fred

can you assist me with option two, please?

I have to be out of office in the next ten minutes and then should be at home in about three...

yes, that is quite correct

sorry, forgot about the difference in dates. Here is sample data

(shortened as for space):

KeyDepotKeyItemMIN_keydateMAX_keydate

511031221712541

1075181223412524

6194751221812218

6322101223712541

1580991224712509

624951222712541

6165581221812218

15367241221012503

580271234212523

4363041221912219

4108341221912403