Lynn/Flo,

Thanks for all your help, the query works the table is now down to 5000 rows instead of 1M.

Des.

Sorry Lynn.

I understand that I change the table variable, however the result I get is:

10.1.8.0 3GPM,3GPM,3GPM,3GPM,3GPM,3GPM………………………………………….3GPM,

The code I am...

Lyn,

I understand that if i manually enter the ip addresses and services the code handles this, as I said it assumes I know all the IP addresses AND services, this...

Flo,

More or less, the code you sent assumes that I know the IP addresses and Services, however this is not the case, is there a way that I can use...

Markus,

I have checked the setting & changed it 8000 and it still truncates.

Flo,

Thanks for the answer, the problem I have is that I have multiple IP's over 10000 and multiple services, not all IP's have the same services. I do not know...