Getting Error that table name or alias does not match.

Getting an error with the PR_ID and cannot figure out why.......The CUST_ID and the PR_ID did come from the same IDCODE Table. I was given the links as a MUST DO from another application developer who said it needed to be done that way. Any help is appreciated thank you.
Msg 107, Level 16, State 2, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
The column prefix 'PR_ID' does not match with a table name or alias name used in the query.

USE [DATA_04]
GO
/****** Object:  StoredProcedure [dbo].[Rpt_SalesSummaryAdopted_sproc_MAC_RAMS]    Script Date: 10/14/2013 09:01:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
   ALTER PROCEDURE [dbo].[Rpt_SalesSummaryAdopted_sproc_MAC_RAMS]  
 
	(
		@Cus_no_Start		varchar(12), 
		@Cus_no_End			varchar(12),
--		@Rams_Cus_no_Start	varchar(12),
--		@Rams_Cus_no_End	varchar(12),
		@DB_Include			int -- 0 = Macola Only, 1 = RAMS Only, 2 = Macola and RAMS 

	) AS

-- for testing
-- drop table #weeklytemp
-- declare @Cus_no_Start varchar(12), @Cus_no_End varchar(12)
-- set @Cus_no_Start = '0'
-- set @Cus_no_Start = '1505'
-- set @Cus_no_End = '1999'
-- end testing
/* note:
8 columns
WW = col 1 report_sort = 10
EW = col 2 report_sort = 20
OR = col 3 report_sort = 30
AK = col 4 report_sort = 40
MW = col 5 report_sort = 185
NC = col 6 report_sort = 50
MI = col 7 report_sort = 110
FS = col 8 report_sort = 70
*/
----------------------------------------------------
-- front zero fill  customer numbers
----------------------------------------------------
If @Cus_no_Start <> '*' and @Cus_no_End <> '*'  
BEGIN
 set @Cus_no_Start			= right('000000000000' + @Cus_no_Start,12)
 set @Cus_no_End			= right('000000000000' + @Cus_no_End,12)
END

/***************************************************************************
-- Taking out the selection for RAMS customers
If @Rams_Cus_no_Start <> '*' and @Rams_Cus_no_End <> '*' 
BEGIN 
  set @Rams_Cus_no_Start	= right('000000000000' + @Rams_Cus_no_Start,12)
  set @Rams_Cus_no_End		= right('000000000000' + @Rams_Cus_no_End,12)
END
*****************************************************************************/

-- print @Cus_no_Start
-- print @Cus_no_End
----------------------------------------------------
-- get static variables from date tables
----------------------------------------------------
declare @CurrFromDate int, @CurrToDate int, @CurrToDateYTD int, @CurrFromDateYTD int,
@PriorFromDateYTD int, @PriorToDateYTD int, @CurrWeekBeginDate int, @CurrWeekEndDate int,
@PriorWeekBeginDate int, @PriorWeekEndDate int, @PriorFromDate int, @PriorToDate int
select
   @CurrWeekEndDate 	= CurrWeekEndDate, 
   @CurrToDateYTD 		= CurrToDateYTD,
   @CurrFromDateYTD		= CurrFromDateYTD,
   @CurrFromDate 		= CurrFromDate,
   @CurrToDate 			= CurrToDate, 
   @CurrToDateYTD 		= CurrToDateYTD,
   @CurrWeekBeginDate 	= CurrWeekBeginDate,
   @PriorWeekBeginDate 	= PriorWeekBeginDate,
   @PriorWeekEndDate 	= PriorWeekEndDate,
   @PriorFromDateYTD 	= PriorFromDateYTD,
   @PriorToDateYTD 		= PriorToDateYTD,
   @PriorFromDate 		= PriorFromDate,
   @PriorToDate 		= PriorToDate
from dbo.Rpt_ReportingDates  WITH (NOLOCK) 

declare @CurrentWeek decimal(8,0), 
		@NumberOfWeeks int, 
		@CurrToDate_Period tinyint, 
		@CurrToDateYTD_FiscalYear smallint
declare @CurrToDate_pSDt datetime, 
		@CurrToDate_pSDt7 datetime

select 
	@CurrentWeek 				= CurrentWeek,
	@NumberOfWeeks 				= NumberOfWeeks,
	@CurrToDate_Period 			= CurrToDate_Period,
	@CurrToDateYTD_FiscalYear	= CurrToDateYTD_FiscalYear,
	@CurrToDate_pSDt			= CurrToDate_PeriodStartDate,
	@CurrToDate_pSDt7			= CurrToDate_PeriodStartDate+(7*vwFiscalDates.NumberOfWeeks-1)

from dbo.vwFiscalDates  --  WITH (NOLOCK)


----------------------------------------------------------------------------------------------------
--  below is pulling data from macola into temp table weeklytemp
----------------------------------------------------------------------------------------------------
CREATE TABLE #weeklytemp
  (
    [data_source] varchar(12),--  what database is the data coming from  macola or rams?
	[RAMS_ID] VARCHAR (6) Null,
	[CurrWeekEndDate] [int] NULL ,
	[CurrToDate] [int] NULL ,
	[CurrToDateYTD] [int] NULL ,
	[CurrentWeek] [decimal](8, 0) NULL ,
	[NumberOfWeeks] [int] NULL ,
	[CurrToDate_Period] [tinyint] NULL ,
	[CurrToDateYTD_FiscalYear] [smallint] NULL ,
	[Terr_name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ID_Title] [Varchar] (40),
	[Report_Sort] [int] NULL ,
	[Terr] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustNo] [varchar] (24) 	COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,	
	[TerrAdopted] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TerrAdoptedName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Adopted_Sort] [int] NULL ,
	[WeekNumber] [int] NULL ,
	[Week1_EndDate] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TICKET_NUMBER] varchar (10) NULL,
	[Item_no] [char] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[RETURN_REASON_CODE] varchar (6) null,
	[FINAL_PRICE] decimal (38,2) null,
	[TOTAL_DELIV_QUANTITY] int null,
	[Week_Sls_Amt] [decimal](38, 2) NULL ,
	[Week_Cost_Amt] [decimal](38, 2) NULL,
	[Date_id] [datetime] null,
	[qty_to_ship] varchar (10) null,
	[inv_dt] int,   
	[prod_cat] Varchar (12), --left([prod_cat],2) int, --as ProdCatNo,
	[prod_desc] varchar (32),
    [CurrWeekBeginDate] int null,
    [PriorWeekBeginDate] int Null,
    [PriorWeekEndDate] Int Null,
    [CurrFromDate] Int Null,
    [PriorFromDate] Int Null,
    [PriorToDate] Int Null,
    [CurrFromDateYTD] Int Null,
    [PriorFromDateYTD] Int Null,
    [PriorToDateYTD] Int Null,
    [qty_return_to_stk] Int null
    )
   
--------------------------------------------------------
--RAMS Section
-------------------------------------------------------

if (@DB_Include = 1 or @DB_Include = 2) -- 1 = RAMS Data only; 2 = Both Macola and RAMS data
BEGIN

insert  into #weeklytemp

	SELECT DISTINCT
	    	    
	    'Rams',
		CM.CM_SELLZONE,
		@CurrWeekEndDate as CurrWeekEndDate, 
		@CurrToDate as CurrToDate, 
		@CurrToDateYTD as CurrToDateYTD, 
		@CurrentWeek as CurrentWeek,
		@NumberOfWeeks as NumberOfWeeks,
		@CurrToDate_Period as CurrToDate_Period,
		@CurrToDateYTD_FiscalYear as CurrToDateYTD_FiscalYear,
		CUST_ID.ID_DESC as Terr_name,
		CUST_ID.ID_Title as ID_Title, 
		RptTerr.Report_Sort, 
		SUBSTRING(PR_ID.ID_DESC, 3, 2) AS Terr,
		OH.OH_CUSTOMER_NUMBER,
		CM.CM_FULLNAME,
		RptTerr.Terr_id AS TerrAdopted,
		RptTerr.Terr_name AS TerrAdoptedName,
		RptTerr.Report_Sort as Adopted_Sort,
		FLOOR((CONVERT(INT, OH.OH_DELIVERY_DATE - @CurrToDate_pSDt,112))/7+1) AS WeekNumber,
		CONVERT(char(8), @CurrToDate_pSDt+(7*FLOOR(CONVERT(INT, OH.OH_DELIVERY_DATE - @CurrToDate_pSDt)/7+1)-1),112) AS Week1_EndDate,
		OD_TICKET_NUMBER,
		OD.OD_PRODUCT as Item_no,
		OD.OD_RETURN_REASON_CODE,
		OD.OD_FINAL_PRICE,
		OD.OD_TOTAL_DELIV_QUANTITY, 
		Week_Sls_Amt = (CASE WHEN (OH.OH_SALE_TYPE = 'O' AND OH.OH_CUSTOMER_TYPE_ID IN ('000001','000003') 
									AND CM.CM_CUST_SUB_TYPE <> 3 -- SBT = 3 (Pay By Scan)
									AND OD.OD_RETURN_REASON_CODE IN ('000000','000001')) -- Sale or BuyBack
							   THEN COALESCE(OD.OD_TOTAL_DELIV_QUANTITY * OD.OD_FINAL_PRICE , 0)
							   ELSE 0 END),
		Week_Cost_Amt = (CASE WHEN (OH.OH_SALE_TYPE = 'O' AND OH.OH_CUSTOMER_TYPE_ID IN ('000001','000003') 
									AND CM.CM_CUST_SUB_TYPE <> 3 AND OD.OD_RETURN_REASON_CODE IN ('000000','000001')) 																											
							   THEN	COALESCE(OD.OD_TOTAL_DELIV_QUANTITY * OD.OD_PRODUCT_COST_PRICE,0)
							   ELSE 0 END),
	     OH.OH_delivery_date,
	     OD_TOTAL_DELIV_QUANTITY,
	     CONVERT(char(8), OH.OH_DELIVERY_DATE ,112),
         PD.PRD_A_GLTYPE,   --coalesce (right(PD.PRD_A_GLTYPE,2), '00'),  -- AS ProdCatNo,
         PD.PRD_DESC1,
         @CurrWeekBeginDate AS CurrWeekBeginDate,
		 @PriorWeekBeginDate AS PriorWeekBeginDate,
		 @PriorWeekEndDate AS PriorWeekEndDate,
		 @CurrFromDate as CurrFromDate,
		 @PriorFromDate AS PriorFromDate,
		 @PriorToDate AS PriorToDate,
		 @CurrFromDateYTD AS CurrFromDateYTD,
		 @PriorFromDateYTD AS PriorFromDateYTD,
		 @PriorToDateYTD AS PriorToDateYTD,
		 qty_return_to_stk = 0
		 
         
FROM    CHLROS05.RAMSDB.dbo.ROSS_SALESHDR AS OH  
		INNER JOIN CHLROS05.RAMSDB.dbo.ROSS_CUSTOMER AS CM  
			ON OH.OH_CUSTOMER_NUMBER = CM.CM_CUSTKEY
			AND CM.CM_ACCT_GLPOSTS = '000004'
			--AND left(CM.CM_SELLZONE,1) = '4'
			--AND CM.CM_CUST_SUB_TYPE <> 3
		Left Outer JOIN CHLROS05.RAMSDB.dbo.ROSS_IDCODE as CUST_ID  
			ON CM.CM_SELLZONE = CUST_ID.IDVALUE
			   AND CUST_ID.ID_TITLE = N'Sale Zone'
		INNER JOIN dbo.Rpt_Territory as RptTerr on RptTerr.Terr_id  = SUBSTRING(PR_ID.ID_DESC, 3, 2)
		INNER JOIN  CHLROS05.RAMSDB.dbo.ROSS_SALESDTL AS OD	
			ON OD.OD_TICKET_NUMBER = OH.OH_TICKET_NUMBER								
		INNER JOIN CHLROS05.RAMSDB.dbo.ROSS_PRODUCTS AS PD 
			ON PD.PRD_PRODUCT = OD.OD_PRODUCT
		INNER JOIN CHLROS05.RAMSDB.dbo.ROSS_IDCODE as PR_ID  
            ON PD.PRD_R_BRANDNAME = PR_ID.IDVALUE
            AND PR_ID.ID_TITLE = N'Product Brand Name'
		
		--WHERE 
			--(CONVERT(char(8),OH.OH_DELIVERY_DATE,112) BETWEEN @CurrToDate_pSDt AND @CurrToDate_pSDt7)	
			--OH.OH_SALE_TYPE = 'O'
			-- AND (CUST_ID.ID_TITLE = N'Sale Zone')
GROUP BY  PR_ID.ID_DESC,
          OD.OD_PRODUCT,
          CM.CM_SELLZONE,
          CUST_ID.IDVALUE,
          PR_ID.ID_TITLE,
          PR_ID.IDVALUE

END

----------------------------------------------------
--End RAMS Section
----------------------------------------------------

		---------------------------------------------------------------------------------------------
	---   MACOLA   SECTION
	--------------------------------------------------------------------------------------------
	
 
If (@DB_Include = 0 or @DB_Include =2 ) -- macola data
-- if @DB_Include = 0  -- macola data
Begin
insert  into #weeklytemp

SELECT DISTINCT
     
      'Macola',
     ARCUSFIL_SQL.Terr, -- correlates with the RAMS ID in RAMS DB
--    Rpt_ReportingDates.CurrWeekEndDate AS CurrWeekEndDate,
--    Rpt_ReportingDates.CurrToDate AS CurrToDate,
--   Rpt_ReportingDates.CurrToDateYTD AS CurrToDateYTD,
      @CurrWeekEndDate as CurrWeekEndDate, 
      @CurrToDate as CurrToDate, 
      @CurrToDateYTD as CurrToDateYTD, 
      @CurrentWeek AS CurrentWeek,
      @NumberofWeeks AS NumberofWeeks,
      @CurrToDate_Period AS CurrToDate_Period,
      @CurrToDateYTD_FiscalYear AS CurrToDateYTD_FiscalYear,
      Rpt_Territory.Terr_Name,
      '0',
      Rpt_OELINHST_Terr.Report_Sort,
      Rpt_OELINHST_Terr.Terr,
      Rpt_OELINHST_Terr.cus_no ,
      ARCUSFIL_SQL.cus_name,
      Rpt_Territory.Terr_id,
      Rpt_Territory.Terr_name,
      Rpt_Territory.Report_Sort AS Adopted_Sort,
      '0', -- ARCUSFIL_SQL.weeknumber AS WeekNumber,
      '0', -- ARCUSFIL_SQL.week1_enddate,
      '0', -- ARCUSFIL_SQL.ticket_number,
      Rpt_OELINHST_Terr.item_no,
      '0', -- ARCUSFIL_SQL.OD_RETURN_REASON_CODE,
      '0.00', -- ARCUSFIL_SQL.OD_FINAL_PRICE,
      Rpt_OELINHST_Terr.qty_to_ship,-- dup below needs to match [TOTAL_DELIV_QUANTITY] in table
      Rpt_OELINHST_Terr.sls_amt,-- Weekly_Sales_Amt
      '0.00',-- Weekly_Cost_Amt 
      ' ', -- Date_ID set to Null per Phil Lavene
      Rpt_OELINHST_Terr.qty_to_ship,
      Rpt_OELINHST_Terr.inv_dt, 
      IMITMIDX_SQL.prod_cat,
      IMCATFIL_SQL.prod_cat_desc,
/*    Rpt_ReportingDates.CurrWeekBeginDate AS CurrWeekBeginDate,
      Rpt_ReportingDates.PriorWeekBeginDate AS PriorWeekBeginDate,
      Rpt_ReportingDates.PriorWeekEndDate AS PriorWeekEndDate,
     Rpt_ReportingDates.CurrFromDate AS CurrFromDate,
     Rpt_ReportingDates.PriorFromDate AS PriorFromDate,
     Rpt_ReportingDates.PriorToDate AS PriorToDate,
     Rpt_ReportingDates.CurrFromDateYTD AS CurrFromDateYTD,
     Rpt_ReportingDates.PriorFromDateYTD AS PriorFromDateYTD,
     Rpt_ReportingDates.PriorToDateYTD AS PriorToDateYTD,*/
--  Replacing above with same as in RAMS Select
      @CurrWeekBeginDate AS CurrWeekBeginDate,
      @PriorWeekBeginDate AS PriorWeekBeginDate,
      @PriorWeekEndDate AS PriorWeekEndDate,
      @CurrFromDate as CurrFromDate,
      @PriorFromDate AS PriorFromDate,
      @PriorToDate AS PriorToDate,
      @CurrFromDateYTD AS CurrFromDateYTD,
      @PriorFromDateYTD AS PriorFromDateYTD,
      @PriorToDateYTD AS PriorToDateYTD,

      Rpt_OELINHST_Terr.qty_return_to_stk
     
 

FROM
    { oj (((DATA_04.dbo.Rpt_OELINHST_Terr Rpt_OELINHST_Terr LEFT OUTER JOIN DATA_04.dbo.Rpt_Territory Rpt_Territory ON
        Rpt_OELINHST_Terr.Terr = Rpt_Territory.Terr_Id)
     LEFT OUTER JOIN DATA_04.dbo.ARCUSFIL_SQL ARCUSFIL_SQL ON
        Rpt_OELINHST_Terr.cus_no = ARCUSFIL_SQL.cus_no)
	 INNER JOIN DATA_04.dbo.Rpt_ReportingDates Rpt_ReportingDates ON
        Rpt_OELINHST_Terr.inv_dt >= Rpt_ReportingDates.PriorFromDateYTD
            )
     LEFT OUTER JOIN DATA_04.dbo.IMITMIDX_SQL IMITMIDX_SQL ON
        Rpt_OELINHST_Terr.item_no = IMITMIDX_SQL.item_no}
     INNER JOIN DATA_04.dbo.IMCATFIL_SQL IMCATFIL_SQL ON
             IMITMIDX_SQL.prod_cat = IMCATFIL_SQL.prod_cat
WHERE
     (Rpt_OELINHST_Terr.inv_dt between @CurrFromDateYTD and @CurrToDateYTD or
     Rpt_OELINHST_Terr.inv_dt between @PriorFromDateYTD and @PriorToDateYTD) -- Changed by RB was @PriorFromDate and @PriorToDate
END



----------------------------------------------------
-- final select
----------------------------------------------------
select * from #weeklytemp

Open in new window

Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
DBAduck - Ben MillerConnect With a Mentor Principal ConsultantCommented:
I don't see an aggregate in your SELECT statement.  Remove the group by and see whether that resolves it.
0
 
Faiga DiegelConnect With a Mentor Sr Database EngineerCommented:
Try to move your INNER JOIN line 217 after all the joins, move it probably on line 225.

Reason: You already used this: SUBSTRING(PR_ID.ID_DESC, 3, 2) PR_ID is not aliased yet. Your PR_ID aliasing is way below
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Moved it to 225 and get the following errors......
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'CUST_ID.ID_DESC' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'CUST_ID.ID_TITLE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'RptTerr.Report_Sort' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_CUSTOMER_NUMBER' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'CM.CM_FULLNAME' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'RptTerr.Terr_Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'RptTerr.Terr_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'RptTerr.Report_Sort' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_DELIVERY_DATE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_DELIVERY_DATE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TICKET_NUMBER' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_RETURN_REASON_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_FINAL_PRICE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TOTAL_DELIV_QUANTITY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TOTAL_DELIV_QUANTITY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_FINAL_PRICE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TOTAL_DELIV_QUANTITY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_FINAL_PRICE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_SALE_TYPE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_CUSTOMER_TYPE_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_CUSTOMER_TYPE_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'CM.CM_CUST_SUB_TYPE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_RETURN_REASON_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_RETURN_REASON_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TOTAL_DELIV_QUANTITY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_PRODUCT_COST_PRICE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TOTAL_DELIV_QUANTITY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_PRODUCT_COST_PRICE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_SALE_TYPE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_CUSTOMER_TYPE_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_CUSTOMER_TYPE_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'CM.CM_CUST_SUB_TYPE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_RETURN_REASON_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_RETURN_REASON_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_DELIVERY_DATE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OD.OD_TOTAL_DELIV_QUANTITY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'OH.OH_DELIVERY_DATE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'PD.PRD_A_GLTYPE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Msg 8120, Level 16, State 1, Procedure Rpt_SalesSummaryAdopted_sproc_MAC_RAMS, Line 146
Column 'PD.PRD_DESC1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Do I need to post a new question or is this one going to be part of a single solution....?
0
 
Faiga DiegelConnect With a Mentor Sr Database EngineerCommented:
For the error template: Column {column name here from your select list} is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

THis means that your select list column should be in the group by clause. E.g. 'CUST_ID.ID_DESC' , you are using that for SELECT list but your GROUP BY clause is using  PR_ID.ID_DESC, that should match.
0
 
Faiga DiegelConnect With a Mentor Sr Database EngineerCommented:
That if you are aggregrating data elements in your select statement, which I don't see. Try removing your group by clause instead.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Removing the Group BY Worked. Thank you...!
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Grateful for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.