IonelBurtan
Programmer
In a stored procedure I am receiving 5 parameters @x,@y,@,z,@t,@w all of them decimal(10,2)
Depending on each of them I insert a row in another table like:
if not (@x=0.0)
INSERT INTO TABLE_WHATEVER(@Id,@x)
if not (@y=0.0)
INSERT INTO TABLE_WHATEVER(@Id,@y)
... (5 times)
Is there a way to do all 5 insert phrases in a SINGLE SQL Phrase(on SQL 7.0).
Thanx,
s-)
Blessed is he who in the name of justice and goodwill, sheperds the weak through the valley of darkness...
Depending on each of them I insert a row in another table like:
if not (@x=0.0)
INSERT INTO TABLE_WHATEVER(@Id,@x)
if not (@y=0.0)
INSERT INTO TABLE_WHATEVER(@Id,@y)
... (5 times)
Is there a way to do all 5 insert phrases in a SINGLE SQL Phrase(on SQL 7.0).
Thanx,
s-)
Blessed is he who in the name of justice and goodwill, sheperds the weak through the valley of darkness...