I have SQL server table with more than 1M records which I need to update from another table with different structure and more records. Those tables have one column in common, further more this...
I am running MSSQL 2000 w/sp3a and I am running into a bunch of errors stating that I have a deadlock error. I have attached a screen shot of the error from event viewer. The other error asso...
rickchild provided this function to check email syntax
CREATE FUNCTION EMAILVALIDATE (@email varChar(100))
RETURNS int
AS
BEGIN
DECLARE @invalChars varchar(5),@valid int,@badChar varcha...
I am filling a dataset from a stored procedure on my SQL Server 2000 database and have not had any problems with it in the past few months. Now today I am getting timeout error whenever I try...
My database contains patient data. The table structure is like this:
Episode_ID StartDate EndDate
-------------------------------------------
1 Jan 1, 08 ...
I have an SSIS package; the same logic could be used for a DTS package that I need to see if a CSV file is on the SQL server. Then based on if the file is there on the server (the same server...
Are there any known "major" issues with running the 32-Bit version of SQL Server 2000 in a Windows Server 2003 64-Bit environment. We had been running a SQL app on a 32-Bit machine, but that ...
I'm writing a query in reporting services to provide a count of all activities entered by a particular user on a per month basis. The trick is, the boss wants to see a count of 0 for any user ...
I have a production SQL instance "Host1\SQL1" and a testing SQL instance "Host1\SQL2". I've trying to copy data from the Production SQL instance to the testing SQL instance, like this:
(but i...
Hello,
Iam totally new to SQL Administration and I am assigned with the task of running something like this.
osql -U sa -****@**** -S &&&&&\sqlexpress -d centers -i "c:\bfd\Centre scri...
Hi
I am doing some development on an existing classic ASP website that uses a SQL Server 2005 database running in 2000 compatibility mode. I have downloaded a backup of the remote db and ...
Hi,
I'm trying to import data from a CSV file into an existing table but having problems. The current error I can't get past is "Bulk insert data conversion error (type mismatch)".
Here ...
Hello,
string sqlString = "INSERT into MessageTable values ('" + msg + "', " + currentUser + ", " + receiverID + ", 'true')";
When I have a comma in the msg variable (like "YOu can't do ...
Hi,
I have a problem with an edited image field. I am using a pass through query and retrieving records from a SQL Server 2005 express database. I retrieve the record and store it in a loc...
Hi
I am trying to execute a store procedure from Cognos 8. When i validate the statement it does not generate any erros and it creates the data item. But when I run the report I get the er...
Hi all,
i am trying to read the output result sets one by one my stored procedure
EXEC sp_help Clients
can anybody help me how read the result sets in the stored procedure itself.
i am ...
Please see the attached code snippet. The sp will work when all of the variable are passed. How do I get it to show all records when no variables are declared. I have tried to set the initial ...
Hi there,
I have a table Customer with the following details
AcctID, Name, Ticket, Values
1 Bob 3 20
2 Bob 3 10
3 Bo...
HI all,
I need to convert some rows into a columns.
hi have this query:
SELECT
dbo.tblWebCasts.uWebCastID as WebcastID,
dbo.tblWebCasts.sTitle as Title,
isnull(dbo.tblWebC...
The CPU goes to 100% and stays there.
The same database and the related applications were working fine with 32 bit SQL Server with same amount of load.
The funny part is none of the database...
I need a sql script either in the form of asp code or a stored procedure that will search through all the tables in my database and all tbale fields and replace matched text with another piec...
I'm using the query below, which works fine, now i want to take it one stpe further and exclude all weekends....
SELECT a.number,
a.contact_name,
a.category,
b....
In this sql statement I need to fix the If Then portion beginning in line 10. Please help.
Select e.*
From [plan] ep
Inner Join plandetail epd
On epd.planid = ep.id
And 200805 between p...
Experts:
I'm new to RS and working with BI Dev Studio and I'm testing some simple reports and charts..etc.
They work fine on my CLIENT workstation, however when I deploy them to the Repo...
Hi,
like we generate the script for database in sql200 and sql2005 for database tables and objects, same as i want to generate the script for my database with the database object and also the...
