Did not get.

Both statements - my and Mark's - do UPDATE Orders.

What did you mean by "He's updating the OrderDetails table from the Orders table"?

If it's really the case, than I need to change my statement.

It's a right time to update your resume and try to go before they bankrupt or cancel IT project.

This...

They must by log files for other databases.

Check the file names and try to find out which database(s) create(s) it.

See "PERMISSIONS function" topic in BOL.

And topics linked from there.

Try create unique constraint on VALIDACCT ([curryear], [currmonth])

See if you really have single record per item.

So, you need just include date into the list of key columns.

No problems here.

The only question is: what does that record with old date represent?

Why do you need deleted...

1st of all it will fail if there are 2 or more rows with the same order_nbr in OrderDetails.

2nd, don't use varchar columns for joining tables.

3rd, it must be...

Unfortunately, Joe is quite right.

If you are newbie in SQL Server you better start from reading some essential books about relational databases and managing data. Or refresh your memory if...

You datagrid contains calculated data not data from column.

That's why you cannot update it.

You may wish to create a view with select statement you posted and set INSTEAD...

Do you create a new records for Recipient and Plan even if there are existing records with same values?

I would suggest revising this approach. You must have logical unique key...

Bad call.

Not apropriate datatype for storing passwords.

1st, there is no point for using ISNULL.

ISNULL(Whatever, 0) may be > 0 only if Whatever > 0

2nd, Try to avoid IN (Condidtion). Use INNER JOIN or WHERE EXISTS instead.

3rd,...

If there are no indexes then there is nothing to eliminate.

Right?

If you need to find all chapters which mention "index" in a book having no index you need to scan...

To get exact match you mast store passwords in VARBINARY strings, not VARCHAR.

'dba         ' = 'dba'

'         ' = ''

But

'         dba' < 'dba'