Answer to Question #235486 in Databases | SQL | Oracle | MS Access for diana

Question

First record in transaction file is read

2

First record in the old master file

is read

3

REPEAT

4

IDs are compared

5

IF IDs do not match, old master file record is written to new master file

6

IF IDs match transaction/calculation is carried out

7

Computer calculates the pay, Rate (from master file) mul

tiplied by

hours worked

(from transaction file)

8

Wages_to_date is updated and record is written to new master file

9

IF IDs match, next record from transaction file is read

10

Next record from master file is read

11

U

NTIL end of transaction file

12

Remaining records of the master file are written to the new master file

Answer 1

DECLARE @RecordID INT = 2


IF (@RecordID >=3)
	BEGIN
	Select * from Records where id = 1
	Select * from Records where id = 2
	END
ELSE
	BEGIN
	Select * from Records where id = 3
	Select * from Records where id = 4
	END