SQL Server Performance Forum – Threads Archive

Getting syntax error in my stored procedure.Pls he

Below is the stored procedure i am creating.I created @Report_Parameter_1 report parameter and added two values Forclosure and Bancrupcy’. I AM GETTING ERROR Line 16: Incorrect syntax near ‘=’ IN BELOW PROCEDURE IN THIS LINE
then dbo.tblRAIL.lkpRailid = 1.Do you know why i am getting this error. Store Procedure declare @Attorneyrname as string
declare @Report_Parameter_1 as string
SELECT DISTINCT
dbo.tblVENDOR.VendorName, dbo.tblVENDOR.VendorShortName, dbo.tblRAIL.RailDescr, dbo.tblSPIKE.SpikeDescr, dbo.tblRAIL.ScreenValue,
dbo.tlkpSID.SId, dbo.tblConVendtoSuperClient.VendorID
FROM dbo.tlkpSID INNER JOIN
dbo.tblSPIKE ON dbo.tlkpSID.SidID = dbo.tblSPIKE.SidId INNER JOIN
dbo.tblRAIL INNER JOIN
dbo.tblVENDOR ON dbo.tblRAIL.SuperClientVendorId = dbo.tblVENDOR.VendorId ON dbo.tblSPIKE.RailId = dbo.tblRAIL.RailId INNER JOIN
dbo.tblConVendtoSuperClient ON dbo.tblVENDOR.VendorId = dbo.tblConVendtoSuperClient.SuperClientId
WHERE (dbo.tblConVendtoSuperClient.VendorID = 199) AND (dbo.tblvendor.vendorid <> 123)
and ([email protected])and
case when @Report_Parameter_1=’Forclosure’
then dbo.tblRAIL.lkpRailid = 1,
case when @Report_Parameter_1=’Bankrupcy’
then dbo.tblRAIL.lkpRailid = 2
end

---

SELECT DISTINCT
dbo.tblVENDOR.VendorName, dbo.tblVENDOR.VendorShortName, dbo.tblRAIL.RailDescr, dbo.tblSPIKE.SpikeDescr, dbo.tblRAIL.ScreenValue,
dbo.tlkpSID.SId, dbo.tblConVendtoSuperClient.VendorID
FROM dbo.tlkpSID INNER JOIN
dbo.tblSPIKE ON dbo.tlkpSID.SidID = dbo.tblSPIKE.SidId INNER JOIN
dbo.tblRAIL INNER JOIN
dbo.tblVENDOR ON dbo.tblRAIL.SuperClientVendorId = dbo.tblVENDOR.VendorId ON dbo.tblSPIKE.RailId = dbo.tblRAIL.RailId INNER JOIN
dbo.tblConVendtoSuperClient ON dbo.tblVENDOR.VendorId = dbo.tblConVendtoSuperClient.SuperClientId
WHERE (dbo.tblConVendtoSuperClient.VendorID = 199) AND (dbo.tblvendor.vendorid <> 123)
and ([email protected]) and
dbo.tblRAIL.lkpRailid = case when @Report_Parameter_1=’Forclosure’ then 1
when @Report_Parameter_1=’Bankrupcy’ then 2
end ***********************
Dinakar Nethi
SQL Server MVP
***********************
http://weblogs.sqlteam.com/dinakar/

---

]]>