-
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)
-
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 :)
-
Thank You Tomi
Thanks Tomi
I send you alot of e mail
Thanks you Tom
My world was so dark till i met you