Passing an INT array into a SQL stored procedure

Asked Mar 15 '21 at 16:55

Active Mar 16 '21 at 08:25

Viewed 20 times

I'm struggling to find what I thought would be a simple solution.

I have an array of customerID's and I want to pass that into a stored procedure to find the notificationID's of those customers.

For example:

CREATE PROCEDURE [dbo].[getCustomerNotificationIDs]
    @customerIDs *array*

    SELECT [NotificationID]
    FROM [dbo].[CustomerNotifications]
    WHERE [CustomerID] IN @customerIDs

Can anyone point me in the right direction please?

edited Mar 16 '21 at 08:25

asked Mar 15 '21 at 16:55

Adsy1944

Yes I am, and using Microsoft SQL Server Management Studio to access it. – Adsy1944 Mar 16 '21 at 08:25
T-SQL has no support for arrays – Mar 16 '21 at 08:25

Passing an INT array into a SQL stored procedure

0 Answers0