Yes carl I know there is no concept of package. But how should i go for it?? I could not find a way where i can implement this with sql...

Nobody to answer????

Is there anything in sql server that defines variable which will persist in session.

In oracle it is pretty good . You define...