Lost With Stored Procedures -- Help Please

Hi,

Looking to create a stored procedure that will take a value from a webpage and display the information from another table. I think i need a variable fed to the SP but am not sure how to do it.

Here is a little background:

I have a database that tracks customer requirements and there are 2 tables that I am concerned with. tbl3215 and tbllog. The common theme between them is a field called ittnumber. Basically what happens is this:

a web application user selects a workcenter that they want to see what requirements are against their office. They select the one they want to view and via a hyperlink the information is given to them in a new window.

That part works great; the part that does not work at all is the part that i want to pull a few columns from the tbllog table. I want it to show all log entries for that particular requirement and only that requirement. This is where i am completely stuck.

How do i get both gridviews to work? I think it is in the stored procedure but like i said i dont know how to take the value selected and return those fields.

here is my stored procedure:

USE [SCX_3215]
GO
/****** Object: StoredProcedure [dbo].[ResultsQuery] Script Date: 08/22/2007 14:37:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ResultsQuery]
(
@ittNumber varchar(50),
@ittLog varchar(max),
@LogDate nvarchar(50),
@LogUserID varchar(1),
@LogID nvarchar(50)
)
AS
SET NOCOUNT OFF;
SELECT distinct tbllog.IttNumber, tbllog.IttLog, tbllog.LogDate, tbl3215.IttNumber AS Expr1
FROM tbllog CROSS JOIN tbl3215
WHERE (tbllog.IttNumber = tbl3215.ittnumber)
ORDER BY ittnumber

The stored procedure that works is the one that pulls all the columns from tbl3215 and is diplayed here as well:

USE [SCX_3215]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Hyperlink]
{

@ittnumber varchar(max)
}

AS

SET NOCOUNT OFF;
SELECT DISTINCT ittnumber, itttitle, ittdescription, ittjustification, techsolution, datereceived, daterequired, customer, orgid, priority, funded, completed, CompletionDate,Disapproved, DisReason FROM tbl3215 WHERE (ittnumber = @ittnumber) ORDER BY ittnumber


Can anyone help me? I appreciate the assistance. Please let me know if you need more information

Joe