The code below cause an error Conversion failed when converting the nvarchar value '6, 24' to data type int. The AlertStatuschange is set as *6*, *24* thus I remove the * to match the number but keep getting the error.
SELECT tlbAlertchange.ShipmentID,
customer_employees.Employe
eLast_Name
, customer_employees.Employe
eFirst_Nam
e,
customer_employees.Employe
eEmail_Add
ress, customer_employees.Employe
eFax_Numbe
r,
customer.Fax_Number, tblactevents.ActivityID, customer_employees.AlertSt
atuschange
FROM tlbAlertchange
INNER JOIN tblactevents ON (tlbAlertchange.acteventsI
D = tblactevents.ActEvetID)
INNER JOIN tblshipment ON (tlbAlertchange.ShipmentID
= tblshipment.ShipmentID), customer
INNER JOIN customer_employees ON (customer.CustomerID = customer_employees.Company
ID)
WHERE (tblshipment.CLIENT_ID = customer_employees.Company
ID) and tblactevents.ActivityID in (replace(customer_employee
s.AlertSta
tuschange,
'*',''))
Group by customer_employees.Employe
eLast_Name
, customer_employees.Employe
eFirst_Nam
e,
tlbAlertchange.ShipmentID,
customer_employees.Employe
eEmail_Add
ress,
customer_employees.Employe
eFax_Numbe
r, customer.Fax_Number,
customer_employees.AlertSt
atuschange
,tblacteve
nts.Activi
tyID
Start Free Trial