Still not sure what you want to accomplish. If the idea is to fetch the two indexvalues from the database in a single statement, consider writing a stored procedure. You would pass in the necessary variables and get the two indexes back. CREATE PROCEDURE up_fetchindexvalues @month0 int, @year0 int, @month1 int, @year1 int, @index varchar(10), […]
2003-06-12
2003-06-10
Also agreed with viacoboni. Sorry jpipes, but the question was "what is the best way to fix the problem". To me, getting around a deadlock error by making a change that potentially introduces data integrity problems is, one, not attempting to understand the root cause of the deadlock and, two, providing a bad example for […]
2003-06-10
I agree with viacoboni. The first choice would be to change the HOLDLOCK to and UPDLOCK. Not to remove the lock completely. Or rewrite the proc.
2003-06-10
I completely agree with your statement. I also think they should have had better choices to pick from.
2003-06-10
Develope an application to change sql user password and deploy it using group policy. Using group policy you can deploy an application in the client system when it starts. After deploying the application let them change the password using that application.
2003-06-05
1 reads
well, i've been unsuccesful in finding out why my newly created timestamp field does not have data on new records. Help 🙂
2003-06-03
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers