qrius (11/4/2012)

---

Hi, am trying to pass 'Orange,Guava' argurment to this stored Proc. dbo.TESCOS table has two columns, Fruit varchar(100) and Price int. I keep getting errors >> Msg 207, Level 16, State 1, Line 3
Invalid column name 'Guava'.

Any help? thanks!


USE [Paul]
GO
/****** Object: StoredProcedure [dbo].[FruitPrice] Script Date: 11/04/2012 23:07:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery12.sql|7|0|C:\Users\Paul\AppData\Local\Temp\~vsD79B.sql
ALTER PROC [dbo].[FruitPrice]
(
@OrderList varchar(500)
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @SQL varchar(400)

SET @SQL =
'SELECT Fruit,Price
FROM dbo.TESCOS
WHERE Fruit IN (' + @OrderList + ')'

EXEC(@SQL)
END

ALTER PROC [dbo].[FruitPrice]
(
	@OrderList varchar(500)
)
AS
BEGIN
	SET NOCOUNT ON

	SELECT Fruit,Price
	FROM dbo.TESCOS
	WHERE Fruit IN (SELECT Item FROM DelimitedSplit8K(@OrderList, ','))

END