Home Forums SQL Server 7,2000 SQL Server Newbies Recursive query for a Bill of Materials table RE: Recursive query for a Bill of Materials table

  • November 12, 2007 at 9:44 am

    #750306

    andy.dawson (11/12/2007)

    Thanks for taking the time to have a closer look.

    When I use your code I get an error:

    "Error 208: Invalid object name 'expand'"

    Any ideas?

    Sorry, you need to change the 'ALTER' to 'CREATE' in the first line.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.