SQL 2000 Stored Procedure

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Ryan Peterson 148.128.243.8 on August 13 2007 11:20:53:

Is it possible and how do I modify @Params, @Values, @Date? I just don't understand how I go about getting the values that go there, because I want to make them static. I'm a sql newb so please bare with me. Thanks.

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object: Stored Procedure dbo.sp_rc_SysCompliancePatchDate Script Date: 8/13/2007 11:02:23 AM ******/

CREATE PROCEDURE dbo.sp_rc_SysCompliancePatchDate(@Params image, @Values image, @Date datetime)
AS BEGIN
select * from f_rc_SysCompliancePatchDetail(@Params, @Values, @Date)
select * from f_rc_SysCompliancePatchAges(@Params, @Values, @Date)
END

GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Follow Ups:

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Is it possible and how do I modify @Params, @Values, @Date? I just don't understand how I go about getting the values that go there, because I want to make them static. I'm a sql newb so please bare with me. Thanks. > > SET QUOTED_IDENTIFIER ON > GO > SET ANSI_NULLS ON > GO > > /****** Object: Stored Procedure dbo.sp_rc_SysCompliancePatchDate Script Date: 8/13/2007 11:02:23 AM ******/ > > CREATE PROCEDURE dbo.sp_rc_SysCompliancePatchDate(@Params image, @Values image, @Date datetime) > AS BEGIN > select * from f_rc_SysCompliancePatchDetail(@Params, @Values, @Date) > select * from f_rc_SysCompliancePatchAges(@Params, @Values, @Date) > END > > > GO > > SET QUOTED_IDENTIFIER OFF > GO > SET ANSI_NULLS ON > GO > >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]