using outer variable

[#1]

Hi

I am going to get a variable from user before loading data ,and limit data with this value in where condition of load or select .

like this :

IDProduct : get from users

select * from tab1 where ID=$IDProduct;

how can i do it ?

[prieper]

Variables need to be included in brackets: $(IDProduct), if it is a string, it should be included in apostrophs:

IDProduct : get from users
select * from tab1 where ID='$(IDProduct)';

HTH
Peter

[#3]

How can i use stored procedure output in other scripts

like this :

sql_sp: SQL declare @ID_Hogh int Execute BSICRS.[dbo].[S_IDPprices] @ID_Hogh=@ID_Hogh output

Select @ID_Hogh as result;

let ID_SP = load result resident sql_sp;

select * from table1 where ID=$(ID_SP );

thanks