Can anyone tell me why I am getting this ODBC error? I am trying to setup an e-mail from an existing procedure. All I have added is the criteria of central in the where clause.
EXEC master.dbo.xp_sendmail
@recipients = '',
@copy_recipients = '',
@subject = 'Leeco Steel Sales East District',
/*@attachments = 'SALES_PERFORMACE_ALERT.cs
v ,
@attach_results = 'TRUE',
@separator = @TAB,*/
@dbuse = 'LLC',
@width = 300,
@query =
'SET QUOTED_IDENTIFIER OFF
PRINT "DAILY SALES, MARGIN $ AND MARGIN % AND DAILY SPT"
SELECT
CONVERT(int,SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.XTNDPRCE ELSE B.XTNDPRCE END ELSE 0 END)) AS DAILY_SALES,
CONVERT(int,SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.EXTDCOST+((C.STNDCOST*-
B.QUANTITY
)/2000)*62
.25 ELSE B.EXTDCOST-((C.STNDCOST*-B
.QUANTITY)
/2000)*62.
25 END ELSE 0 END)) AS DAILY_COST,
CONVERT(int,((SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.XTNDPRCE ELSE B.XTNDPRCE END ELSE 0 END)))-SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.EXTDCOST+((C.STNDCOST*-
B.QUANTITY
)/2000)*62
.25 ELSE B.EXTDCOST-((C.STNDCOST*-B
.QUANTITY)
/2000)*62.
25 END ELSE 0 END)) as DAILY_MARGIN_$,
CONVERT(decimal(4,3),1-SUM
(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.EXTDCOST+((C.STNDCOST*-
B.QUANTITY
)/2000)*62
.25 ELSE B.EXTDCOST-((C.STNDCOST*-B
.QUANTITY)
/2000)*62.
25 END ELSE 0 END)/(SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.XTNDPRCE ELSE B.XTNDPRCE END ELSE 1 END))) as DAILY_PMARGIN,
CONVERT(int, SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN (C.STNDCOST*-B.QUANTITY)/2
000 ELSE (C.STNDCOST*B.QUANTITY)/20
00 end else 0 end)) AS DAILY_TONS,
CONVERT(int,SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN -B.XTNDPRCE ELSE B.XTNDPRCE END ELSE 0 END)/SUM(CASE WHEN A.GLPOSTDT = CONVERT(CHAR (10), GETDATE()-1,101) THEN CASE WHEN B.SOPTYPE = 4 THEN (C.STNDCOST*-B.QUANTITY)/2
000 ELSE (C.STNDCOST*B.QUANTITY)/20
00 end else 0 end)) AS SPT
FROM SOP30200 A
left join SOP30300 B ON A.SOPTYPE=B.SOPTYPE AND A.SOPNUMBE=B.SOPNUMBE
LEFT JOIN iv00101 C ON B.ITEMNMBR=C.ITEMNMBR
WHERE
a.subtotal<>0 and
A.SOPTYPE IN(3,4) AND
a.salsterr=central and
A.VOIDSTTS <> 1 AND
/*DATEPART(MM,A.GLPOSTDT) = DATEPART(MM, GETDATE()) AND*/
DATEPART(MM,A.GLPOSTDT) = DATEPART(MM, GETDATE()) AND
DATEPART(YYYY,A.GLPOSTDT) = DATEPART(YYYY, GETDATE())
'
GO