Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Migrating data from Microsoft Dynamics GP into SQL Server 2008

    Hi S'bu

    I assume you mean GP 10?

    As per our friend Google...

    Setup Tables.

    These tables have 4 prefix. IV40100 – this is Inventory Control Module setup table. ...


    _____________________________________________________________________
    Select 'Remember, we were all newbies once'
    From Truth
    Order by Experience
    _____________________________________________________________________

    June 11, 2009 at 5:04 am

    #1007895

  • RE: SQL Function : Find ‘X’ Business Days in the Future

    Hi, J Gravelle

    There is a data warehousing structure that will make it much easier to do this calc, as well as the flexibility to do loads more...The Date dimension

    By...


    _____________________________________________________________________
    Select 'Remember, we were all newbies once'
    From Truth
    Order by Experience
    _____________________________________________________________________

    February 4, 2009 at 7:00 am

    #937931

  • RE: SSIS Lookup using a Script Component

    Hi Sachin

    As requested, here is an example, but first, just a bit of waffling...

    In the code, I create a dummy temp table, and put some random values in. My last...


    _____________________________________________________________________
    Select 'Remember, we were all newbies once'
    From Truth
    Order by Experience
    _____________________________________________________________________

    January 5, 2009 at 11:47 pm

    #921586

  • RE: SSIS Lookup using a Script Component

    Hi Sachin

    Being a DW developer, I am always on the lookout for the simplest way of doing things. Another suggestion/question would be (if I understand the scenario correctly), why not...


    _____________________________________________________________________
    Select 'Remember, we were all newbies once'
    From Truth
    Order by Experience
    _____________________________________________________________________

    January 5, 2009 at 7:26 am

    #921116

  • RE: The Date Dimension in Analysis Services

    Good, solid article on the date dimension.

    I love role-playing dimensions - they can expand business users' understanding of their data to points that they had never considered.

    For example, one of...


    _____________________________________________________________________
    Select 'Remember, we were all newbies once'
    From Truth
    Order by Experience
    _____________________________________________________________________

    November 28, 2008 at 6:29 am

    #904754

Viewing 5 posts - 1 through 6 (of 6 total)