quote:

---

--SEARCH RESULT FOR SEARCH METHOD 1, GIVEN JOB# AND STN#
CREATE PROCEDURE dbo.validate_JobStn
@job nvarchar(5) = null ,
@stn nvarchar(3) = null
AS

declare @flag smallint

IF EXISTS --If the record is to be updated then pull all the needed informaiton from the database with that jnum and snum
(SELECT * FROM STN WHERE Job_Num = @job AND STN_Num = @Stn)
BEGIN
SET @flag = 1

SELECT S.*, I.img_name, I.imageid
FROM STN S
INNER JOIN [Image] I ON I.STN_id = S.STN_key
WHERE S.Job_Num = @job
AND S.STN_Num = @Stn

SELECT M.CAT_id
FROM Merge_ImageCategory M
INNER JOIN STN S ON M.STN_id = S.STN_key
WHERE S.Job_Num = @job
AND S.STN_Num = @Stn

SELECT FLAG = @flag
END
ELSE
BEGIN --SINCE the record is not in Image Quotes then put it in STN
INSERT INTO STN (Job_Num, STN_Num)
VALUES (@job, @stn)

SELECT STN_key
FROM STN
WHERE Job_Num = @job
AND STN_num = @stn

IF EXISTS (SELECT * FROM TimeCard..STN_Numbers WHERE Job_Number = @job AND STN_Number = @Stn)
BEGIN
SET @flag = 2 -- Station is not in our database but exists in the Timecard database, if this is the case pull the Description
SELECT Stn_Description as [Description]
FROM TimeCard..STN_Numbers
WHERE Job_Number = @job
AND STN_Number = @Stn

SELECT FLAG = @flag
END
ELSE
BEGIN
SET @flag = 3
SELECT FLAG = @flag
END
END
GO

---