Access, I believe simply represents the FALSE boolean value (both in data storage and in VBA script) as -1. Both systems actually just look for the absense of zero,...

Use the BIT datatype. SQL Server will fit up to 8 BIT fields in the space of a single byte. It handles NULL values in a separate BITMASK...

try:

CREATE TABLE DoorAccess

(

  DoorID INT

, EmployeeID INT

, AccessTime DATETIME

)

--This code will get the number of times

--doors accessed in last 6 hours

DECLARE...

Check out BOL for DATEPART and SET DATEFIRST.

Use:

SET DATEFIRST 1

SELECT DATEPART(dw, GETDATE())

Another way:

--In Inventory:

SELECT ProductId

FROM tblProduct

INNER JOIN TblStoreInventory

ON TblStoreInventory.ProductId = tblProduct.ProductId

--Not in Inventory:

SELECT ProductId

FROM tblProduct

LEFT JOIN TblStoreInventory

ON TblStoreInventory.ProductId = tblProduct.ProductId

WHERE TblStoreInventory.ProductID IS NULL

You should run both in...

The version of Visio included in Enterprise Architect .NET Studio can reverse-engineer from tables to ER and vice versa. A bit costly, but not when compared to ERWin, which...

Wow. Where do we start.

1) Don't use cursors. This procedure can be rewritten using standard SET-based SQL commands. First, do the update on current date records...

I think I could help more if I understood what the overall objective is. Are you trying to get a scalar or table-type value from the procedure? If...

If you are trying to get the "meassages" output from a SQL statement or procedure executed through ADO (version 2.5 or later), you can use the ADODB.Recordset.NextRecordset() to get to...

Would you mind posting the table structures. I am not sure whether you have an unnormalized structure or not. If so, it may be advantageous to normalize the...

Also, it might be a heck of a lot more efficient if you were filtering on a MFG_ID, instead of a name. Is that possible, given your query requirements?

...

Try the query without the NOLOCK hint, without the 4-part JOIN (use WHERE instead). If still slow, take out the LIKE expression and rerun. If you determine the...

Have you verified with the host provider that the SQL user has been set up correctly? You had mentioned earlier that they had "reset" the user/passwords.

Are you using Windows Authentication, SQL authentication or mixed mode?