-- Run this script on your AdventureWorks database



SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE CategorySelect
AS
SET NOCOUNT ON
SELECT  ProductCategoryID AS CategoryID,
	Name AS CategoryName 
FROM dbo.ProductCategory

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE SubCategorySelect
@ProductCategoryID tinyint
AS
SET NOCOUNT ON
SELECT  ProductSubCategoryID AS SubCategoryID,
	Name AS SubCategoryName 
FROM dbo.ProductSubCategory
WHERE ProductCategoryID=@ProductCategoryID

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

