USE [DataPRO]
GO

/****** Object:  StoredProcedure [dbo].[sp_DASGet]    Script Date: 8/15/2017 8:59:42 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[sp_DASGetChildrenDAS]
	 @ParentSerialNumber	nvarchar(50) = null
AS
BEGIN
	SET NOCOUNT ON;
	SELECT [SerialNumber]		
	FROM [dbo].[DAS] where 
	[ParentDAS] = @ParentSerialNumber
END







GO