OK, will do tomorrow... heading out for the day

Thanks

PS, Awful late in the day for you Frank

Could be the "contents" comes from the .COL file ????

How about something I can...

Generally speaking, the WHERE clause of the SELECT statement limits the number of records the query will return. As with most any client side application, you want to query for...

Also, does the SP produce #Temp tables with data you are "massively" processing or have many rows in them.

Did you know that SQL Srv. will effectively "drop" a table from the execution plan if:

1. View is like SELECT ... UNION ... UNION ... UNION ... UNION ... etc.

2....

That will work(around) fine.

BTW, Are you "vertically" partitioning for the purpose of query performance against the VIEW? so that SQL Srv. "drops" curtain tables from the execution plan as the...

Can you post the queries you are using in context?

Andy, I can sometimes edit even when the left banner is not "complete".

I can always edit when the left banner is complete.

Ozamora, 

A GUID will produce a globally unique identifier, if that is what you need, then that's the ticket.

If you just need some ever incrementing unique numbers, then the...

Above should work for as many tables as you want...

Table1 ... GlobalUnq INT IDENTITY(1, 100) ... 101, 201, 301, 401...

Table2 ... GlobalUnq INT IDENTITY(2, 100) ... 102, 202, 302, 402...

Table3...

You could use the IDENTITY [ ( seed , increment ) ] property with varying seeds and increments.

Table1 ... GlobalUnq INT IDENTITY(1, 3) ... 1, 4, 7, 10...

Table2 ... GlobalUnq...

Frank, the "en" is most likely because you have the ENglish BOL on a German language O/S ???

I just have to SQL80.??? files.

Copied the tsqlref.chm (2MB), got "mismatch version" message, copied...

Do either of you have an SQL80.chw (~ 5+ MB) dated appropriately?

I think that's the one.

Sorry, edited chm -> chw.

Shortcut just points to that 12KB "SQL80.COL" file in ...\80\tools\books dir

Did you at least get your "wireless" setup out of the deal?