ProTech-Online.com

Microsoft SQL code example to pull Syteline current operations.

USE [testsite_live_App]
GO
/****** Object:  StoredProcedure [MYSCHEMA].[_chad_Excel_Addin_BOM_Current_Operation]    Script Date: 06/24/2013 23:34:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [MYSCHEMA].[_chad_Excel_Addin_BOM_Current_Operation]
      --@ORDER_NUM nvarchar(12)
AS
BEGIN
      SET NOCOUNT ON;
      SELECT itm.item AS Item
            ,itm.description AS 'Item Description'
            ,jbr.oper_num AS Operation
            ,jbr.wc AS WC
      FROM jobroute AS jbr
            INNER JOIN job AS job
                  ON job.job = jbr.job
                  AND job.suffix = jbr.suffix
            INNER JOIN item AS itm
                  ON itm.job = job.job
            INNER JOIN jrt_sch AS jsh
                  ON jbr.job = jsh.job
                  AND jbr.suffix = jsh.suffix
                  AND jbr.oper_num = jsh.oper_num
      WHERE job.suffix = '0' and job.type = 'S' AND itm.item IS NOT NULL
      ORDER BY itm.item, jbr.oper_num

END