Is this Access 2000?

This sort of behaviour often is related to the indexes (within SQL-Server) on the table. If Access isn't sure which one to use for what then you can read data...

Can you tell us specifically what you're trying to acheive...

The way I read this, if you can do it using temporary tables then you should be able to do the...

I'm not really sure I follow... Can you not do the calculation of the primary key as part of the SELECT statement or is it too complicated. If that's the...

Hi

Sorry for the stoopid question but what are you writing this in?

I've never seen the "user!userid" construct within  T-SQL. Perhaps it's just something I've missed.

Sam

Fair point but this wouldn't work if your SP was kicked of by another server process (say, a batch job).

I do generally dissagree though... you should always have error handling...

Just as a totally off-the-wall idea, have you thought about building your your argument string into an XML stream from your ASP page (which you'd pass to your stored proc...

Hmmmm, very odd.

The only thing I can think of is, are you sure that the 2 servers are set up the same way (sort orders; collation and that sort of...

Hi

Yes this will work and it gives you the flexibility that a person could work for more than one company and a company could (of course) have more than one person...

Hi

Are you sure this is a SQL-Server problem.... it sounds to me like it might be that you need to do a REFRESH of the combo box values. It's a...

Hi

Frank's right - only use a cursor if you have a death wish.

But this should be fairly straight forward. In your new table make colum 1 you PhoneNumberID, and set it...

Hi

What I mean by "loads more flexible than a stored procedure" is that with a view you've effectively got another table that you can do selects, order, joins and anything...

Hi

Sorry if this is a bit over-obvious but it looks to me like at the time it "fails" that tables 2 and 3 don't have a Col1 value that matches...

Well, yes...

Effectively a view is giving you another table to work with, and is therefore loads more flexible than a stored procedure.

You can select specific columns, add "where" clauses or...

Hi

Do it in 2 steps using a table variable (or temp table)

First do your initial select "Return <account information> between <2 dates> or <condition regardless of dates>"  where marketing campaign isn't...