Database

<br />
select ppar_engparameters.parmval, ppar_engparameters.parmname<br />
from ppar_engparameters<br />
where ppar_engparameters.prcdversion = (select max(prcd.prcdversion) from prcd where<br />
prcd.prcdname = ppar_engparameters.prcdname and prcd.activeflag='A') and <br />
ppar_engparameters.parmval='myValue' <br />
<br />
<code>select category from catg_pll<br />
where catgnumber = 01 and partprcdname||' '||partprcdversion = 'myValue2'

select catg_pll.category, prcd.activeflag, prcd.prodstatus from catg_pll, prcd<br />
where  prcd.prcdname||' '||prcd.prcdversion = 'myValue2'<br />
and catgnumber = '05' and <br />
catg_pll.partprcdname||' '||catg_pll.partprcdversion = 'myValue2'<br />

@CourseNumber int OUTPUT,
	@CourseName nvarchar(100),
	@College int,
	@Department int,
	@Description nvarchar(500)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    INSERT INTO Course
		(CourseName, College, Department,Description)
	VALUES
		(@CourseName, @College, @Department,@Description)

	SELECT @CourseNumber = @@IDENTITY