Yes Surrogate primary key,  All I had in my head was proxy primary key

thats exactley what I meant

What I gave you will show what you wanted

tal

Hi,

First, I am color blind so the whole thing is lost on me.  lol

Second,  you will have circular references -- (i.e. red matches Orange and Orange Matches Red)

Third,  Your data...

Hi,

Are you Saying:

and

If That is the case....What do you want to do with them?

It seems you are troubled by your own success.

If you want an easy solution, make multiple databases.  This is however Kludge in that you are not able to share any of...

Hey,

It is an extra IP at work. it is only a half of a t1.  I would think it is ok to list unless you have a million readers that hit me...

I really like "SQL for Smarties" by Celko.

He posts here and is very active in google groups as well.

tal

Hi,  I had to make a bunch of fake data as well.  I took the most popular firstnames and lastnames from the census folks and just crossed them then I created bogus SSN...

Hi,  We had to deal with the same thing,

We used the "with encryption" clause on all of the stored procedures ect.

a few warnings:

Once you encrypt the stored procedure you cannot...

good to hear,  at least I am not craazy or an old grump.  well in this instance at least

OK,

there is something your not saying in all of this or it would work.

this works if your login has permission to use both northwind AND Pubs

use northwind

select * from pubs.dbo.authors

this...

Well,

In My Opinion you are opening a big kettle of fish by passing the queries to the sql server. Among them:

1.  Your SQL server is vulnerable to ad hoc queries...

I agree....way too broad to answer....

Somewhat like saying tell me about Religion....

Just meant as a friendly reminder.  I am not a newsgroup Nazi, if i was I would not have answered it.

First, I do not know why you are posting in the administration forum.

second,

if you want a variable amount of records to be displayed. Like a web search "show 25" or "show...