I want to pass a
list of Integer values to a MS-SQL7 stored procedure. Can it be done?? - to test
as part of the IN? - Does not seem to like it any ideas?
CREATE PROCEDURE
DistribtionList @clientKey INT, @disKeys NVARCHAR( 500 ) AS
SELECT Recipient.RecipientID
FROM Recipient INNER JOIN (Distribution INNER JOIN DistributionItem ON Distribution.DistributionKey = DistributionItem.DistributionKey) ON Recipient.RecipientID = DistributionItem.RecipientID
WHERE Distribution.clientKey = @clientKey AND Distribution.DistributionKey IN ( @disKeys )
FROM Recipient INNER JOIN (Distribution INNER JOIN DistributionItem ON Distribution.DistributionKey = DistributionItem.DistributionKey) ON Recipient.RecipientID = DistributionItem.RecipientID
WHERE Distribution.clientKey = @clientKey AND Distribution.DistributionKey IN ( @disKeys )
Any alternaitvesanybody?? - Using ADO from ASP pages - I was trying to make a stored proc of an existing SQL statement on page.
Myles Penlington
Software Engineer
Advanced Management Systems Ltd
