dragonpms (4/3/2011)
ok ,lets i explain my requirement....ALTER PROC Multiple_Instance_Value
(
@compnay_ID INT,
@Instance_ID NVARCHAR(MAX)
)
AS
BEGIN
SELECT instance_id,address,company_name,status FROM cmytbl
WHERE company_ID =@company_ID AND instance_id = @instance_id
END
for exemple we passing the input parameter as
EXEC Multiple_Instance_Value @company_id = 201,@instance_id = '1011,1012,1013,1014,1015,1016,1017'
I want output as
insatnce_id: 1011, address: 3 way line, ABC private ltd,1
insatnce_id: 1012, address: 4 way line, DEF private ltd,1
insatnce_id: 1013, address: 5 way line, GHI private ltd,1
insatnce_id: 1014, address: 6 way line, JKL private ltd,1
insatnce_id: 1015, address: 7 way line, MNO private ltd,1
insatnce_id: 1016, address: 8 way line, PQR private ltd,1
In the above we get the each output table by means of instance_id what we passed in the @input parameter of @instance_id.
The output table is not fixed it may vary deponds on the @instance_id.
I think you may understand my requirement,if so please help me out,am waiting for the solution,if any queries please let me know..........
This is an SQL Server CE forum. IIRC, SQL Server CE cannot use stored procedures nor can you declare variables in any of it's scripts. So let me ask, what version of SQL Server are you really using?
--Jeff Moden
Change is inevitable... Change for the better is not.