[Code]SELECT TOP 1 EMPLOYEEID

FROM SALARIES

ORDER BY SALARY DESC[/Code]

Thanks, Sergiy, I learn something new every day.

Yes, two tables which contained a binary (image) field failed to import and a couple of others for reasons I could not pinpoint. Also, I want the imported data to...

[Code]UPDATE tblTemp SET fkProgram = (select id from tblProgram WHERE description = t.ProgramBuy) FROM tblTemp t[/Code]

Pardon me for nitpicking, if the alias 't' is assigned in the outer query, how...

Sergiy, Thanks for the helping hand to OP. I have a question to add:

How can I create a table to hold the recordset without knowing its schema?

Thanks, Sergiy, I'll pass it on.

No, sir, I have never used WITH ENCRYPTION in my sprocs.

This is just a pointer I've slapped up fast:

[Code]SET DATEFORMAT DMY

DROP TABLE TABLE1

DROP TABLE TABLE2

CREATE TABLE TABLE1 (INITS VARCHAR(10), EFFDATE DATETIME, RATE NUMERIC)

INSERT INTO TABLE1 (INITS, EFFDATE, RATE)

SELECT 'aaaa',...

GROUP BY returns records that have been "summarized" and "grouped" in the order of fields you choose. When you add fields to the SELECT clause without a summary function, you...

Praja, do NOT "cut and paste" the code - it will definitely not work. Use only one of the options in brackets separated by "|".

[Code]SELECT Customers.CustomerID, Orders.OrderID, Orders.OrderDate

FROM Customers,...

No, there is no replication whatsoever on our servers.

I restored an October backup, and found the stored procedures appeared intact. But when I restored the last backup and tried to...

I myself am on the same learning curve as you, though I have made good headway in my research. You could try these:

[Code]SELECT Customers.CustomerID, Orders.OrderID, Orders.OrderDate

FROM Customers, Orders

WHERE...

Thanks, guys. You've all been a great help.

Phew! What a big world I have dared step into! Thanks to both of you, Jeff and Phil, I'll remember your advice.

As the name implies, a primary key has to be unique for each record in the table, so SQL will definitely test if it exists before committing an INSERT or...