Here is a dirty way to do this in SQL 7:

select 'RKA10' as Data into #data from sysobjects where 1=2

union

select 'RKA100'

union

select 'KA11'

union

select 'RMX10'

union

select 'RMX100'

union

select 'RMX11'

union

select 'RSA12'

union

select 'RSA120'

union

select 'RSA1201'

union

select 'RSA139'

union

select 'RSBH01'

select...

You need a SP that takes user's login as a parameter and returns correct result based on his credentials

select 1 as [ID], 1 as SecondaryID, 3.2 as Value into #temp

union

select 1,2, 1.3

union

select 1, 3, 0.4

union

select 2, 1, 4.8

union

select 2, 2, 1.3

union

select 3, 1, 1.5

union

select 3, 2, 2.3

select id,...

this article might help:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q175/5/74.asp&NoWebContent=1

This might run slightly faster:

CREATE TABLE #Table1 (ID int identity,

 TimedAt datetime default getdate(),

 One int, Two int, Three int)

INSERT #Table1 (One, Two, Three) VALUES (1,2,3)

INSERT #Table1 (One, Two, Three)...

without temp tables, make sure it is sorted:

INSERT INTO EmpLicns (ElcEEID, ElcLicenseID, ElcNumber, ElcSystemID)

select EecEEID, 'DRIVER' as ElcLicenseID, EecUDField04,

ElcSystemID='user' + cast(((select count(*) from EmpComp as emp where emp.EecEEID<EmpComp.EecEEID) +1)...

select EecEEID, 'DRIVER' as ElcLicenseID, EecUDField04,

ElcSystemID='user' + cast(((select count(*) from EmpComp as emp where emp.EecEEID<EmpComp.EecEEID) +1) as varchar)

FROM EmpComp

order by EecEEID