There's no such thing as a global variable in SQL Server. So i had to do it differently. Here's how.