If I'm understanding your issue correctly, I believe that UNION is going to be your friend. This is the keyword that attaches two datasets vertically, allowing you to combine...

You need a RETURN clause. Probably specifically, the "NewField = cVar" line should be "RETURN cVar".

This sounds very much like you are running into a problem with improperly normalized data. If at all possible, I suggest re-designing the table in question. Rather than...

I'm going to assume that you are using an MDB file, with a SQL Server linked table.  I've seen this behavior before, but it could be caused by any number...

SELECT Emp.EmployeeNumber

FROM tblEmployees Emp

LEFT JOIN

(SELECT EmployeeNumber FROM tblEmployeeCourse

WHERE CourseNumber = 'XXX') EC

ON Emp.EmployeeNumber = EC.EmployeeNumber

WHERE EC.EmployeeNumber IS NULL

When you're doing the export, instead of just exporting the field, export Format(myDate,"Short Date"). Your date is stored with the time, as part of the way the datetime data...

You'd also have to search for JOIN...

No problem.

Keep in mind that is still a VERY sub-optimal solution. For a number of reasons. If I were you, I'd seriously talk to whoever wrote that program...

That will work, but can be awkward to read. Separate your IF statement out into its own block.

IF OBJECT_ID('tALARMS') IS NULL

BEGIN

CREATE TABLE tALARMS (AlrmBaseTag varchar(8000), AlrmLoc nvarchar(255), AlrmPanel int,...

Okay.

First of all, don't DROP and CREATE the table. That's a lot of overhead. TRUNCATE the table instead.

Second, you should roll the functionality of your UPDATE statement into...

Are you trying to capture a record of dynamic SQL? If so, it ought to be fairly easy. Rewrite your SP to build the SQL string in a...

My clarity point was that, in an MDB, your queries, or at least parts of them, exist in the front end. The same queries that you often use as...

Can you post the query? It's hard to guess at what the problem is without seeing it.

But, just to toss out some guesses, I'd start by looking for outer...

Errrrr....

I'm not certain what exactly you are trying to do here. I don't see a derived table in your query. Or, as far as I can tell, a...

I'm going to post the incredibly helpful :/ note that I saw this done once, using something similar to codepages for characters. Essentially, you could tell SQL Server to...