Microsoft SQL stored procedure to pull the Syteline BOM data.

USE [testsite_live_App]
GO
/****** Object: StoredProcedure [MYSCHEMA].[_chad_Excel_Addin_BOM_Indented]    Script Date: 06/17/2013 22:20:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [MYSCHEMA].[_chad_Excel_Addin_BOM_Indented]
      @site nvarchar(20)
      ,@item nvarchar(30)
AS
BEGIN
      SET NOCOUNT ON;
      CREATE TABLE #INDENTED_TMP (
         seq int
         ,TcLevel int
         ,TcItem nvarchar(30)
         ,TcGroupItem nvarchar(30)
         ,TcDesc nvarchar(40)
         ,TQty float
         ,TUm nvarchar(3)
         ,TUnit nvarchar(1)
         ,TRef nvarchar(1)
         ,TType nvarchar(1)
         ,TcPmtCode nvarchar(1)
         ,TcStocked tinyint
         ,TcRevision nvarchar(8)
         ,TcJobRefSeq nvarchar(10)
         ,TcJobRefDes nvarchar(10)
         ,TcJobRefBubble nvarchar(4)
         ,TcJobRefAssySeq nvarchar(4)
         ,rowpointer uniqueidentifier
         ,QtyPerFormat nvarchar(30)
         ,PlacesQtyPer tinyint
         ,AltGroup int
         ,AltGroupRank int
         ,Operations nvarchar(MAX) null
         ,PlannerCode nvarchar(3) null
         ,Phantom tinyint null
         ,ProductCode nvarchar(10) null
         ,FamilyCode nvarchar(10) null
         ,Backflush tinyint null
         ,BackflushLocation nvarchar(15) null
      )
      DECLARE @NOW AS DATETIME
      SET @NOW = CONVERT(date, GETDATE())
      IF @site = 'testsite'
      BEGIN
            INSERT INTO #INDENTED_TMP (seq
                  ,TcLevel
                  ,TcItem
                  ,TcGroupItem
                  ,TcDesc
                  ,TQty
                  ,TUm
                  ,TUnit
                  ,TRef
                  ,TType
                  ,TcPmtCode
                  ,TcStocked
                  ,TcRevision
                  ,TcJobRefSeq
                  ,TcJobRefDes
                  ,TcJobRefBubble
                  ,TcJobRefAssySeq
                  ,rowpointer
                  ,QtyPerFormat
                  ,PlacesQtyPer
                  ,AltGroup
                  ,AltGroupRank)
            EXEC testsite_Live_App.dbo.Rpt_IndentedCurrentBillofMaterialSp
                  @StartingItem = @item,
                  @EndingItem = @item,
                  @StartingProCode = NULL,
                  @EndingProCode = NULL,
                  @MaterialType = 'MTOF',
                  @Source = 'PMT',
                  @Stocked = 'B',
                  @ABCCode = 'ABC',
                  @EffectiveDate = @NOW,
                  @EffectiveDateOffset = NULL,
                  @PageJob = 'S',
                  @PrintLevelZero = 0,
                  @DisplayRefer = 0,
                  @DisplayHeader = 0,
                  @PrintAlternateMaterials = 0
            UPDATE #INDENTED_TMP
            SET Operations = testsite_Live_App.TEST._chad_Excel_Addin_Operations(@site, TcItem)
                  ,PlannerCode = itm.plan_code
                  ,Phantom = itm.phantom_flag
                  ,ProductCode = itm.product_code
                  ,FamilyCode = itm.family_code
                  ,Backflush = itm.backflush
                  ,BackflushLocation = itm.bflush_loc
            FROM #INDENTED_TMP indented
                  INNER JOIN testsite_Live_App.dbo.item itm
                        ON indented.TcItem = itm.item
      END
      SELECT seq
            ,TcLevel
            ,TcItem
            ,TQty
            ,TUm
            ,TcDesc
            ,Operations
            ,TType
            ,TcPmtCode
            ,TcStocked
            ,AltGroup
            ,PlannerCode
            ,Phantom
            ,ProductCode
            ,FamilyCode
            ,Backflush
            ,BackflushLocation
      FROM #INDENTED_TMP

END