It is not entirely clear to me what this procedure is for. Can you give some answers on the following questions?

What are you trying to do with this procedure? If...

Going for the SQL coding here ...

Don't know about the difference of INSERT INTO and SELECT * INTO, but I'm sticking with your notation.

SELECT * INTO last_record_table

FROM sales_transaction st1

INNER JOIN

...

I think you should write the query like this. The remaining question is whether you want to return all the invoices from the selected customers (like this query does), or...

Have you tried adding the servername - ip address combination to the HOSTS file?

I have the same problem on our LAN. I cannot connect to the SQL Server (not in...

Glad to be of help .

Remember that everytime you write a tablename in a FROM clause, it is in fact a new 'instance' of that table for...

I believe you should be using the JET engine. Works for most file formats like Excel, Access, plain text, CSV, ...

I haven't really used it. I always used the ODBC...

And now for the short version

The difference between Query C and Query D is the number of times you reference the cdAccount table.

In Query C you...

Okay, I'll try to explain this. Just talking about the last (erroneous) query here. So no need to try to link this to any of your other queries.

First, you...

Bilster, hate to be the 'know-it-all'

I did not test the little query I wrote to proof my point (and it failed of course). I have attached complete...

I think MAPQNTY is the quantity from the WIP that is allocated to the podetail line.

E.g. in the second line, you will be using 65 items from the 75 in...

In that case, create a Login with the appropriate Name (and password), and assign sufficient rights to it for the databases you want the user to access.

Also check which type...

I think your second example (the one that does not work), is wrong. You shouldn't perform the join in the SELECT clause of the outer query.

What you are saying in...

Do you want to use SQL Server security or Windows Security?

Check your Logins (Security) and Users (Database) in Enterprise Manager, and add the user if needed.

To resolve the syntax error, try the following (parentheses around the parameter).

select...

where K.K_Forum in (@forumToSearch)

You can also check earlier posts about the same subject :

General - comma delimited string as...

This might be a method to get rid of the NOT EXISTS ... (I think). Don't know about performance though...

SELECT * INTO reporting_table

FROM transaction_history th1

WHERE th1.trans_date =

...