even other data types are not working.

How do I declare a global variable?

DECLARE X varchar(10)

Select * from table where table.id = X

is not working.

Thanks.

How to do it without a DTS package?

Please let me know.

Thanks