Okay,

You'll have to modify your Store procedure to pass the variable for the network and it should give you the expected result.

Use this SP  below instead, amend where applicable.

-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,Mahesh,Ramchurn>
-- Create date: <Create Date 16,09,2019>
-- Description:	<Description,Select IP Address from Network Range,>
-- =============================================
CREATE PROCEDURE spIP 
	-- Add the parameters for the stored procedure here
	@Network nvarchar(50)

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	select IP from tblnetIPstat where Network = @Network and status is null or status = ''
END
GO

Cheers,

MR.   

Thanks Mahesh,

Will try & update!

Thanks Again!

Sorry Mahesh,

one thing i noticed, in my column Network, the values are the first 3 octates of IP

So if the IP is: 192.168.2.10

Network is: 192.168.2

Based on the selection of Network range the available IP's which are not Test or Production should be shown...