Uh, I'm for hire. 🙂

Both Jeff and SQL Oracle are correct. This to me sounds like a good place for some VB script in DTS. ...

That's the problem with the *= operator, it leads to an ambiguous query. Try moving the condition into the JOIN clause

SELECT a.return_indic,

...

That's because this is not an OUTER JOIN. Your original query is looking for rows where the cust_id is not equal. When you re-wrote it, you say cust_id...

Why use 2 statements? If the isolation level is read committed, why not just run the update? By filtering on the LockStatus column, SQL Server should lock other...

You could just as easily (and more preferably in my opinion) create a stored procedure to do all of this for you. Instead of updating your Approved field and...

Roy,

I am in favor of using AppLocks for locking certain application level resources. I have not used it to lock a range of rows like what Allen is...

Before you go down the route of armtwisting, you should follow Matt's instructions and rebuild indexes/update statistics.

The ALTER TABLE ADD COLUMN command will add the new column to the end of the table. If you need to change the position of a column within a...

Please post sample data and desired results.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

.....He said, “It is finished!” And bowing His head, He gave up His spirit.

You can use the Transfer Logins task in DTS to move your logins from SQL Server 2000 to a 2005 instance.

No problem. For what it's worth, check out this link on dynamic SQL.

http://www.sommarskog.se/dynamic_sql.html

Also, if you are using this column as a flag and later scanning this column for whatever reason, you are going to get poor performance out of the scan. ...

Your description is still too broad to make a guess at what you are trying to do. As Lynn suggested, read the best practices article for posting and revamp...

Assign your SQL code into a variable and then execute the variable. You should look into using sp_executeSQL when executing dynamic SQL.

SET @sqlcmd ='Select * FROM Table1 WHERE '...