I posted the following question yesterday: [Multiple 'in' statements in a where clause that need to match against each other](https://stackoverflow.com/questions/8721784/multiple-in-statements-in-a-where-clause-that-need-to-match-against-each-other/8721851#8721851)

In this there was some discussion about a feature in Oracle which doesn't exist in Microsoft SQL, the specific line of code being:

```
where (suite_id,lease_id) in (('CCBG08','205059'),('CCBG14','152424'),('CCCF048','150659'))

```

Assuming that we have a table of (however with more rows):

> 
> suite\_id lease\_id 
> 
> 
> CCBG08 150659
> 
> 
> CCBG14 152424
> 
> 
> 

I extrapolated on this to create the following solution for Microsoft SQL:

```
select  *
from    property.lease_period
where   (suite_id + ' ' + lease_id) 
        in (
            ('CCBG08 205059'),
            ('CCBG14 152424'),
            ('CCCF048 150659')
        )

```

Unfortunately the performance implications of doing something like this are quite significant (as indexes aren't being used). I was wondering how this could be improved?