Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383] [SQL server issues]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more

sqlserversamples.codeplex.com

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383][SQL server issues]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more
sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

1. AdventureWorksDW2008R2 DimDate table has missing dates

   sqlserversamples.codeplex.com/workitem/13383 - Cached - Similar

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates. description. There
   is a gap in dates between 2008 and 2010 in the AdventureWorksDW2008R2
   DimDate table. ... The attached script will fix the problem. Use the ... Sign in to
   add a comment or to set email notifications ... Item number: 13383.
   

2. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   sqlsample.blogspot.com/.../ Commented%20Issue%3A%20AdventureWorksDW2008R2%20Di... - Cached

   9 Sep 2013 ... Commented Issue: AdventureWorksDW2008R2 DimDate table has missing
   dates [13383]. pavanbarnala wrote Feb 23, 2012 at 10:47 AM.
   

3. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue_27.html - Cached

   27 Aug 2013 ... [SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate
   table has missing dates [13383] ...
   

4. [SQL server issues] Commented Issue - Show all posts

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue_21.html - Cached

   21 Aug 2013 ... AdventureWorksDW2008R2 DimDate table has missing dates ... 08/27/09--10:26
   : Commented Issue: Installer: The zipped DB package doesn't
   

5. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue_12.html - Cached

   12 Aug 2013 ... AdventureWorksDW2008R2 DimDate table has missing dates ... 08/27/09--10:26
   : Commented Issue: Installer: The zipped DB package doesn't
   

6. [SQL server issues] Commented Issue - Show all posts

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue.html - Cached

   9 Sep 2013 ... [SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate
   table has missing dates [13383] ...
   

7. Tin học căn bản A B C - About - Google+

   https://plus.google.com/106698475788327335617/about - Cached

   Tin học căn bản A B C hasn't shared anything on this page with you.
   

8. Commented Issue AdventureWorksDW2008R2 DimDate table has ...

   timnhanh.thietkewebtl.com/s%5CCommented-Issue- AdventureWorksDW2008R2-DimDate-table-has-missing-dates-133... - Cached

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates.
   description. There is a gap in dates between 2008 and 2010 in the ...
   

9. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   timnhanh.thietkewebtl.com/?...Commented%20Issue: %20AdventureWorksDW2008R2%20DimDate%20table%20has%2... - Cached

   Commented Issue AdventureWorksDW2008R2 DimDate table has missing dates
   13383 o tphcm. Xem kết quả · Commented Issue AdventureWorksDW2008R2 ...
   

10. San khau ca nhac tai quan 6 tphcm - T?m nhanh - t?m kiếm nhanh

    timnhanh.thietkewebtl.com/?q...fload=f - Cached

    Commented Issue AdventureWorksDW2008R2 DimDate table has missing dates
    13383 · lam sao de up file .ass len youtube vay cac bac co the chi cho em ki ...
    

11. Ban Laptop cu tai Thanh Hoa tai quan 12 tphcm - T?m nhanh

    timnhanh.thietkewebtl.com/?q...fload=f - Cached

    Commented Issue AdventureWorksDW2008R2 DimDate table has missing dates
    13383 · lam sao de up file .ass len youtube vay cac bac co the chi cho em ki ...
    

12. Shop thoi trang teen tai Hau Giang o quan 10 tphcm - T?m nhanh

    timnhanh.thietkewebtl.com/?q...fload=f - Cached

    Commented Issue AdventureWorksDW2008R2 DimDate table has missing dates
    13383 · lam sao de up file .ass len youtube vay cac bac co the chi cho em ki ...
    

13. Shop thoi trang teen tai Ha Noi tai quan 1 tphcm - T?m nhanh

    timnhanh.thietkewebtl.com/?q...fload=f - Cached

    Commented Issue AdventureWorksDW2008R2 DimDate table has missing dates
    13383 · Cho thue phong tro o Binh Duong · phim cap 3 an do o quan 8 tphcm
    

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

1. AdventureWorksDW2008R2 DimDate table has missing dates

   sqlserversamples.codeplex.com/workitem/13383 - Cached - Similar

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates. description. There
   is a gap in dates between 2008 and 2010 in the AdventureWorksDW2008R2
   DimDate table. ... The attached script will fix the problem. Use the ... Sign in to
   add a comment or to set email notifications ... Item number: 13383.
   

2. Microsoft SQL Server Community & Samples - Issues

   sqlserversamples.codeplex.com/workitem/list/basic - Cached

   22 Feb 2013 ... There seams to be an issue with the AdventureWorksDW2012 Data file
   download. ... The pages will list comments, but don't show a way to add them. ...
   AdventureWorksDW2008R2 DimDate table has missing dates ... Id #13383 |
   Release: None | Updated: Feb 22 at 1:37 AM by petermyers | Created: May ...
   

3. Commented Issue AdventureWorksDW2008R2 DimDate table has ...

   timnhanh.thietkewebtl.com/s%5CCommented-Issue- AdventureWorksDW2008R2-DimDate-table-has-missing-dates-13383.html

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates.
   description. There is a gap in dates between 2008 and 2010 in the ...
   

4. SqlServerSamples Work Item Rss Feed - Kekunda.com

   reputationless7.kekunda.com/chan-5121419/all_p1.html - Cached

   08/27/09--10:26: Commented Issue: Installer: The zipped DB package doesn't ....
   Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383] ...
   

5. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   sqlsample.blogspot.com/.../ Commented%20Issue%3A%20AdventureWorksDW2008R2%20Di... - Cached

   27 Aug 2013 ... Commented Issue: AdventureWorksDW2008R2 DimDate table has missing
   dates [13383]. pavanbarnala wrote Feb 23, 2012 at 10:47 AM.
   

6. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue_12.html - Cached

   12 Aug 2013 ... AdventureWorksDW2008R2 DimDate table has missing dates ... 08/27/09--10:26
   : Commented Issue: Installer: The zipped DB package doesn't
   

7. [SQL server issues] Commented Issue - Show all posts

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue.html - Cached

   9 Sep 2013 ... [SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate
   table has missing dates [13383] ...
   

8. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue_27.html - Cached

   27 Aug 2013 ... [SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate
   table has missing dates [13383] ...
   

9. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue.html - Cached

   2 Aug 2013 ... Commented Issue: AdventureWorksDW2008R2 DimDate table has missing
   dates [13383]. pavanbarnala wrote Feb 23, 2012 at 10:47 AM.
   

10. AdventureWorksDW2008R2 DimDate table has missing dates

    sqlsample.blogspot.com/.../Commented-Issue%253A- AdventureWorksDW2008R2-DimDate-table-has-missing-dates- ...

    No posts with label Commented-Issue%3A-AdventureWorksDW2008R2-
    DimDate-table-has-missing-dates-%5B13383%5D. Show all posts. No posts with
    label ...
    

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

1. AdventureWorksDW2008R2 DimDate table has missing dates

   sqlserversamples.codeplex.com/workitem/13383 - Cached - Similar

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates. description. There
   is a gap in dates between 2008 and 2010 in the AdventureWorksDW2008R2
   DimDate table. ... The attached script will fix the problem. Use the ... Sign in to
   add a comment or to set email notifications ... Item number: 13383.
   

2. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   sqlsample.blogspot.com/.../ Commented%20Issue%3A%20AdventureWorksDW2008R2%20Di... - Cached

   27 Aug 2013 ... Commented Issue: AdventureWorksDW2008R2 DimDate table has missing
   dates [13383]. pavanbarnala wrote Feb 23, 2012 at 10:47 AM.
   

3. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue.html - Cached

   2 Aug 2013 ... Commented Issue: AdventureWorksDW2008R2 DimDate table has missing
   dates [13383]. pavanbarnala wrote Feb 23, 2012 at 10:47 AM.
   

4. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue_12.html - Cached

   12 Aug 2013 ... AdventureWorksDW2008R2 DimDate table has missing dates ... 08/27/09--10:26
   : Commented Issue: Installer: The zipped DB package doesn't
   

5. SqlServerSamples Work Item Rss Feed - Kekunda.com

   reputationless7.kekunda.com/chan-5121419/latest.php - Cached

   24 Jul 2013 ... 08/27/09--10:26: Commented Issue: Installer: The zipped DB .... Issue:
   AdventureWorksDW2008R2 DimDate table has missing dates [13383] ...
   

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

1. AdventureWorksDW2008R2 DimDate table has missing dates

   sqlserversamples.codeplex.com/workitem/13383 - Cached - Similar

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates. description. There
   is a gap in dates between 2008 and 2010 in the AdventureWorksDW2008R2
   DimDate table. ... The attached script will fix the problem. Use the ... Sign in to
   add a comment or to set email notifications ... Item number: 13383.
   

2. Issues - Microsoft SQL Server Community & Samples - CodePlex

   sqlserversamples.codeplex.com/workitem/list/basic - Cached

   22 Feb 2013 ... There seams to be an issue with the AdventureWorksDW2012 Data file ...
   AdventureWorksDW2008R2 DimDate table has missing dates.
   

3. Updating... - Microsoft SQL Server Community & Samples - CodePlex

   sqlserversamples.codeplex.com/workitem/list/basic?size... - Cached

   There seams to be an issue with the AdventureWorksDW2012 Data file
   download. When I try to ... AdventureWorksDW2008R2 DimDate table has
   missing dates.
   

4. SqlServerSamples Work Item Rss Feed - Kekunda.com

   reputationless7.kekunda.com/chan-5121419/latest.php - Cached

   24 Jul 2013 ... 08/27/09--10:26: Commented Issue: Installer: The zipped DB package doesn't
   contain the DB Data (chan 5121419). Environment ========== ...
   

5. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   sqlsample.blogspot.com/.../ Commented%20Issue%3A%20AdventureWorksDW2008R2%20Di... - Cached

   12 Aug 2013 ... Showing posts with label Commented Issue: AdventureWorksDW2008R2
   DimDate table has missing dates [13383]. Show all posts ...
   

6. Sql samples, sql tips: [SQL server issues] Commented Issue ...

   sqlsample.blogspot.com/.../sql-server-issues-commented-issue.html - Cached

   2 Aug 2013 ... Commented Issue: AdventureWorksDW2008R2 DimDate table has missing
   dates [13383]. pavanbarnala wrote Feb 23, 2012 at 10:47 AM.
   

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

1. AdventureWorksDW2008R2 DimDate table has missing dates

   sqlserversamples.codeplex.com/workitem/13383 - Cached - Similar

   28 May 2010 ... There is an unsaved comment in progress. You will lose your changes if you ...
   AdventureWorksDW2008R2 DimDate table has missing dates ...
   

2. Issues - Microsoft SQL Server Community & Samples - CodePlex

   sqlserversamples.codeplex.com/workitem/list/basic - Cached

   22 Feb 2013 ... There seams to be an issue with the AdventureWorksDW2012 Data file ...
   AdventureWorksDW2008R2 DimDate table has missing dates.
   

3. Updating... - Microsoft SQL Server Community & Samples - CodePlex

   sqlserversamples.codeplex.com/workitem/list/basic?size... - Cached

   There seams to be an issue with the AdventureWorksDW2012 Data file
   download. When I try to ... AdventureWorksDW2008R2 DimDate table has
   missing dates.
   

4. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   sqlsample.blogspot.com/.../ Commented%20Issue%3A%20AdventureWorksDW2008R2%20Di... - Cached

   12 Aug 2013 ... Showing posts with label Commented Issue: AdventureWorksDW2008R2
   DimDate table has missing dates [13383]. Show all posts ...
   

5. SqlServerSamples Work Item Rss Feed - Kekunda.com

   reputationless7.kekunda.com/chan-5121419/latest.php - Cached

   24 Jul 2013 ... 08/27/09--10:26: Commented Issue: Installer: The zipped DB package doesn't
   contain the DB Data (chan 5121419). Environment ========== ...
   

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

1. AdventureWorksDW2008R2 DimDate table has missing dates

   sqlserversamples.codeplex.com/workitem/13383 - Cached - Similar

   28 May 2010 ... AdventureWorksDW2008R2 DimDate table has missing dates ... in dates
   between 2008 and 2010 in the AdventureWorksDW2008R2 DimDate ...
   

2. Microsoft SQL Server Community & Samples - Issues

   sqlserversamples.codeplex.com/workitem/list/basic - Cached

   22 Feb 2013 ... There seams to be an issue with the AdventureWorksDW2012 Data file ...
   AdventureWorksDW2008R2 DimDate table has missing dates.
   

3. SqlServerSamples Work Item Rss Feed - Kekunda.com

   reputationless7.kekunda.com/chan-5121419/latest.php - Cached

   24 Jul 2013 ... 08/27/09--10:26: Commented Issue: Installer: The zipped DB package doesn't
   contain the DB Data (chan 5121419). Environment ========== ...
   

4. AdventureWorksDW2008R2 DimDate table has missing dates [13383]

   sqlsample.blogspot.com/.../ Commented%20Issue%3A%20AdventureWorksDW2008R2%20Di... - Cached

   25 Jul 2013 ... Showing posts with label Commented Issue: AdventureWorksDW2008R2
   DimDate table has missing dates [13383]. Show all posts ...
   

5. Recent Items from 6/2/2010 | Pulse | SQLServerPedia

   pulse.sqlserverpedia.com/stream/?when=2010-06-02&page=34

   2 Jun 2010 ... SqlServerSamples - View Issue #13383: AdventureWorksDW2008R2 DimDate
   table has missing dates. Type: Link; 6/2/2010 at 1:39 PM ...
   

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

Read more

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com

[SQL server issues] Commented Issue: AdventureWorksDW2008R2 DimDate table has missing dates [13383]

pavanbarnala wrote Feb 23, 2012 at 10:47 AM

Hello,
Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 5:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.

.

sqlserversamples.codeplex.com