Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Newbie Design Question

    Have you looked at Kimball's "Slowly Changing Dimension" techniques? Its in "The Data Warehouse Toolkit".

    Hope this helps

    March 3, 2006 at 9:48 am

    #624656

  • RE: How do I use SQL Query on Excel Data?

    You can use OPENDATASOURCE in a query e.g

    SELECT *

    FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="C:\TestJoins.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...Sheet1$ AS s1

    INNER JOIN OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="C:\TestJoins.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...Sheet2$ AS s2 ON s2.KeyID=s1.KeyID

    Where the first...

    March 3, 2006 at 9:45 am

    #624654

Viewing 2 posts - 1 through 2 (of 2 total)