Query With Data In Another Table...

Hi,

I have the following problem... For these two tables I have to query, all "nrtelefone" from PABX where tronco is not between tronco ini and tronco fim....and tronco is not in there clause "troncos_cliente", the the user will provide to us...
Let's suppose that the troncos_cliente has the value "NOT BETWEEN 32 and 55", and in tronco ini there is "10" and in tronco fim there is "20" so I need to query all nrtelefone that is not between 32 and 55 and not between 10 and 20, but the problem is with cursor this process will take to much time cause htere is too many clients..




Code Block
CREATE TABLE [LOGIN] (
[COD_CLIENTE] [varchar] (50),
[TRONCO_INI] [int] NULL ,
[TRONCO_FIM] [int] NULL ,
[TRONCOS_CLIENTE] [nvarchar] (4000)
)







Code Block
CREATE TABLE [PABX] (
[COD_CLIENTE] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[NRTELEFONE] [varchar] (255) COLLATE Latin1_General_CI_AS NULL ,
[TRONCO] [int] NULL CONSTRAINT [DF_PABX_TRONCO] DEFAULT (9999),
)





So is there a way to make this query without using cursors ? (NOTE: I'm using cursor cause I need to build the T-SQL at runtime just because of the TRONCOS_CLIENTE that the user will provide the SQL clause)

Thanks