set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[GetBugDetails]
(@Category VarChar)
AS

DECLARE @BugDetails TABLE
(BugsID BIGINT,
Category VarChar,
Severity VarChar,
Priority VarChar,
Owner VarChar,
State VarChar,
Result VarChar,
Summary VarChar,
Votes Char)

INSERT INTO @BugDetails
SELECT BugsID, Category, Severity, Priority, Owner, State, Result, Summary, Votes
FROM bugs
WHERE Category = @Category