Viewing 15 posts - 1,876 through 1,890 (of 3,232 total)
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,
...
March 6, 2008 at 4:01 pm
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...
March 6, 2008 at 3:25 pm
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...
March 6, 2008 at 5:04 am
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...
February 29, 2008 at 2:03 pm
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...
February 29, 2008 at 1:38 pm
Before you go down the route of armtwisting, you should follow Matt's instructions and rebuild indexes/update statistics.
February 28, 2008 at 2:35 am
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...
February 28, 2008 at 2:23 am
Please post sample data and desired results.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 27, 2008 at 3:47 pm
.....He said, “It is finished!” And bowing His head, He gave up His spirit.
February 25, 2008 at 3:30 pm
You can use the Transfer Logins task in DTS to move your logins from SQL Server 2000 to a 2005 instance.
February 25, 2008 at 9:47 am
No problem. For what it's worth, check out this link on dynamic SQL.
February 22, 2008 at 3:54 pm
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. ...
February 22, 2008 at 3:51 pm
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...
February 22, 2008 at 3:46 pm
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 '...
February 22, 2008 at 3:28 pm
I assume that the @FieldName variable contains a column name that you want use in your where clause? You need to use dynamic SQL if that is the case....
February 22, 2008 at 3:04 pm
Viewing 15 posts - 1,876 through 1,890 (of 3,232 total)