nightmare.sql

SELECT
    [TargetCompleteDate] - 21 AS [ActionReqd],
    [S1].[Qid],
    [S1].[JBGid],
    [Manufacturers].[FacilityName],
    [S1].[Qty],
    [S1].[Description],
    [S1].[SubDescription]
  FROM
       (
         (
          SELECT
              [Q].[Qid],
              [QBR_Worksheet].[JBGid],
              [Q].[MfgID],
              [QBR_Worksheet].[Qty],
              [QBR_Worksheet].[Description],
              [QBR_Worksheet].[SubDescription]
            FROM
                 (
                   (
                     ([TOOL_GetCurrentCO]
                 INNER JOIN
                      [QBR]
              ON [TOOL_GetCurrentCO].[QCOid] = [QBR].[QCOid]
                     )
                      INNER JOIN
                           (
                            SELECT
                                [Qid],
                                [MfgID],
                                [JobStatusID]
                              FROM [Q]
                                   INNER JOIN
                                        (
                                         SELECT
                                             [dbo].[GetSessionParameter]
                                                ('Purchasing_TaskList.MfgID_Filter', '%'
                                                ) AS [Value]
                                        ) AS [USP]
                                ON [Q].[MfgID] LIKE [USP].[Value]
                           ) AS [Q]
              ON [TOOL_GetCurrentCO].[Qid] = [Q].[Qid]
                   )
                           INNER JOIN
                                [Purchas_POs-1]
              ON [Q].[Qid] = [Purchas_POs-1].[JobNumber]
                 )
                                INNER JOIN
                                     (
                                       (
                                         (
                                           (
                                            SELECT
                                                [QBRid],
                                                [JBGid],
                                                [Qty],
                                                [PBuyout],
                                                [IsOptional],
                                                [OptionTaken],
                                                [Group0],
                                                [Group1],
                                                [Group3],
                                                [Description],
                                                CONVERT ( nvarchar(max), [SubDescription]
                                                        ) AS [SubDescription]
                                              FROM [QBR_Worksheet]
                                           ) AS [QBR_Worksheet]
                 LEFT JOIN
                      [Purchas_POs-2]
              ON [QBR_Worksheet].[JBGid] = [Purchas_POs-2].[JBGid]
                                         )
                      LEFT JOIN
                           [Admin_KillList_WorksheetDiscrepancies]
              ON [QBR_Worksheet].[JBGid] = [Admin_KillList_WorksheetDiscrepancies].[JBGid]
                                       )
                           LEFT JOIN
                                [UnapprovedJobs]
              ON [QBR_Worksheet].[QBRid] = [UnapprovedJobs].[QBRid]
                                     )
              ON [QBR].[QBRid] = [QBR_Worksheet].[QBRid]
            WHERE
                 [QBR_Worksheet].[JBGid] IS NOT NULL
                 AND [QBR_Worksheet].[JBGid] NOT LIKE N'%PT%'
                 AND [Purchas_POs-2].[JBGid] IS NULL
                 AND [Admin_KillList_WorksheetDiscrepancies].[JBGid] IS NULL
                 AND [Q].[JobStatusID] = 10020
                 AND [QBR_Worksheet].[PBuyout] = '1'
                 AND [UnapprovedJobs].[QBRid] IS NULL
                 AND [QBR].[TakeMe] = '1'
                 AND (
                 [IsOptional] = '0'
                 OR [OptionTaken] = '1'
                     )
                 AND (
                 [Group0] >= 50
                 OR [Group0] = 40
                 AND (
                 [Group1] <> 41
                 AND [Group1] <> 46
                 OR [Group3] > 0
                     )
                     )
                 AND NOT (
                 [Group0] = 71
                 AND [QBR_Worksheet].[Description] = N'Includes'
                 AND [QBR_Worksheet].[SubDescription] = N''
                         )
         ) AS [S1]
       INNER JOIN
            [Manufacturers]
    ON [S1].[MfgID] = [Manufacturers].[MfgID]
       )
            INNER JOIN
                 [Jobs]
    ON [S1].[Qid] = [Jobs].[Qid]
  WHERE
  --[S1].[MfgID] LIKE [dbo].[GetSessionParameter]
  -- ('Purchasing_TaskList.MfgID_Filter', '%'
  -- )
  --AND 
       [Jobs].[TargetCompleteDate] <= GETDATE () + 42
       AND (
       [Jobs].[PrintAppro] = 'B'
       OR [Jobs].[PrintAppro] = 'Y'
           )
       AND (
       [Jobs].[CreditAppr] = 'P'
       OR [Jobs].[CreditAppr] = 'Y'
           )
       AND [Jobs].[Cancelled] = '0'
  GROUP BY
    [TargetCompleteDate] - 21,
    [S1].[Qid],
    [S1].[JBGid],
    [Manufacturers].[FacilityName],
    [S1].[Qty],
    [S1].[Description],
    [S1].[SubDescription];