I'm using SQL Server 2008 R2, in MS SQL Server Management Studio. I've only ever done Selecting and all the standard stuff but I find myself frequently using the same lists of strings for different queries and I'd like to be able to build variable that holds them. I don't have the access rights to create a new table, otherwise I would just do that. Is this even possible?

Let's say I have a bunch of client numbers that I want to use to include only their client account data with a query, example:

```
SELECT * FROM SALES
WHERE CLIENTNUMBER IN ('123','456','789')

```

Is there a way to create a variable that will hold those 3 values, so that I can instead just say

```
SELECT * FROM SALES
WHERE CLIENTNUMBER IN @CLOTHING_CLIENTS

```

The list is longer than 3 client numbers of course. And there are different categories etc. I think it would be MUCH simpler to do as a separate table but of course I don't have the ability to create new tables. I could do `JOIN`s and the like too but that's getting even more work than just putting in the client numbers each time.

I'm trying to simplify things and make it more readable for other people, not make it more efficient for the database or more "correct".