convert SQL QUERY TO SP

[efrat]

Hi Folks
how can convert sql query to sp :

SELECT MACHINE.machine_id,
MACHINE.machine_name
FROM MACHINE
WHERE MACHINE.in_station = 'Bank'

And this .

SELECT DISTINCT MACHINE.type_id,
MACHINE_TYPE.type
FROM MACHINE,
MACHINE_TYPE
WHERE ( MACHINE.type_id = MACHINE_TYPE.type_id ) and
( ( MACHINE_TYPE.machine_level = "FIB" ) AND
( MACHINE.in_station ='Bank' ) )

Thank you very much
efrat
[email protected] (Tom is busy)

[Clunietp]

1)
Create Procedure sp_GetMachine
@IN_Station varchar(10)
As
SELECT MACHINE.machine_id,
MACHINE.machine_name
FROM MACHINE
WHERE MACHINE.in_station = @IN_Station


2)
Create Procedure sp_GetMachine2
@IN_Station varchar(10),
@Machine_Level varchar(5)
As
SELECT DISTINCT MACHINE.type_id,
MACHINE_TYPE.type
FROM MACHINE,
MACHINE_TYPE
WHERE ( MACHINE.type_id = MACHINE_TYPE.type_id ) and
( ( MACHINE_TYPE.machine_level = @Machine_Level ) AND
( MACHINE.in_station =@IN_Station ) )

Go Efrat Go

[efrat]

Thanks Tomi
I send you alot of e mail

Thanks you Tom
My world was so dark till i met you