Age old problem,

How do I get the ID for the thing I just wrote.

@@Identity immediately after the insert works but you do need a return trip from the database.

If the...

hi,

could you give what you are really trying todo/

bassguy

good points EM

hi again,

I talked to one of the security guys. It was Macafee Intrusion detection that was causing problems.

anyway thats all I know

Yeah I thought that a bit....um....brash

rudy,

there was nothing until we put a trace program on the server. we had the problem on the test env not the production...then found out the security folks had...

hi,

As I mentioned earlier I think of the surrogate key as a proxy for the real key, hence my loss of the true name "surrogate".

More to your question "So,...

Hi,

You have it but do not know it.

as I tried to say (albeit poorly) is that the primary key in your address table is more than one column. The...

hi,

i think you are getting it backwards.

you have created a primary key on the address table that in reality is a "Proxy" - (I cannot think of the correct term...

without knowing specifics this may not apply, but, I have found it easier to use excel to pull the data rather than try and push it.

please tell us more of...

hi again,

after I played with it some I am making the assumption that it is not applicant based. Here is a solution.

First Whenever I am making a table that...

So, If I understand you are looking for a way to find out how many would sell at or below the price rang from 500-800$ so for instance:

Price ...

hey,

just be warned that sometimes linking to an excel file can give you data types other than you would expect. if your column has numbers in the first row,...

We had a similar issue here win2k sp4 and sql2000 sp3.

It turned out to be a problem with Macafee and some of the anti virus.

don't know if that...

hi,

I have never heard that concatinating in and of itself causes any problems. maybe if you were using a cursor to achieve it. 

I suppose in the strictest sense if you do anything...