In my SQL Sever 2000 database, I have approximately 30 or more concurrent users. Almost every other day (sometimes more than once a day) I have to kill a process because it has caused a block. Most...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21257727.html
Hello,
I need some help populating some parameters in a stored procedure.
The Start Date parameter must be sunday morning at 3:00 AM of the current week and the end date must be the sunday of t...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23289551.html
Hi Experts,
I would like to default my datetime field to the current date NOT to the current date AND time.
If I use the following as a default it seems to work. Is this the correct way to do...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20828072.html
Hi,
Im a newbie to SQL but have been struggling with this for a while:
I have a large table(approx 2M records) as shown below called test. I have to strip the eighth digit and add one to the ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23113217.html
Hi experts,
I have a query that returns a list of courses attended. One of the courses is shown twice. It turns out the individual was registered, didn't attend the first date, so attendance dat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23200143.html
I have two differnet databases that have different field names, and different datatypes. I need to compare the data between these databases to find out which PK's exist or do not exist. My task is ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23583727.html
I have a stored procedure that creates a pivot table with data from a view in SQL Sever 2000. Neither the sp or the view has changed in months. However for some reason the order in which the data i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23859921.html
I have a query on a MS SQL Server called vMaxID that has this code:
SELECT MAX(RefID) AS Expr1
FROM dbo.Referees
When I run the query in SQL Server; it returns the maximum value ...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21381643.htm...
Hi,
I have an application that allows the users to enter a date through a date picker. The date goes into the textbox as mm/dd/yyyy. I then run an INSERT. In the table I have the field set up as...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23124159.htm...
The following query returns a set of results starting with the below. Once the items start changing, the results are as expected - one row per item and everything is as expected. I checked the ta...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23214747.html
