We have a problem with a table giving us deadlock issues and we can't figure out why. It's a table we write to fairly often perhaps 50 times a...

Don Vaillancourt

01-14-2006 11:34 AM
John Bell

I have the time of an event stored on each record as a datetime field.It includes the year,month,day, etc. Suppose my user wants to search the...

Andrew Chalk

01-13-2006 05:37 PM
Eric J. Holtman

Hello guys, I'm not an sql expert but I need to pull out some data from SQL database. I hope you can help me here. I need to find out how many time...

pipe.jack@gmail.com

01-13-2006 04:43 PM
Erland Sommarskog

I have SQL records as follows REGION PRODUCT Amount Week IMDS A 100 Week1 IMDS A 250 Week2 IMDS A 150 Week3 IMDS B 525 Week1

vedavyas.rao@gmail.com

01-13-2006 04:40 PM
Hugo Kornelis

I have an "Issues" table for my technicians. An issue can be on "hold" or "assigned". I want to get a count for each tech with a column showing...

jonescv@gw.ccsd.net

01-13-2006 03:42 PM
David Portas

Hi, This is my basic sql shape query: ------------------------------------------------------------ SHAPE {select * from tbl1} APPEND({SELECT * FROM...

doar123@gmail.com

01-13-2006 03:19 AM
doar123@gmail.com

Please here with find the requirement details as follows. ATG Dynamo Developer Location: Minneapolis, MN Duration: Long-term Startdate:...

Radhesh Reddy

01-12-2006 07:09 PM
Radhesh Reddy

Please here with find the requirement details as follows. ATG Dynamo Developer Location: Minneapolis, MN Duration: Long-term Startdate:...

Radhesh Reddy

01-12-2006 07:08 PM
Radhesh Reddy

I 'm using SQL Server 2000 Enterprise Edition in Windows 2000 Sever box. Now , message "SQL Server has encountered 1 occurrence(s) of IO requests...

NiponW

01-12-2006 04:55 PM
Erland Sommarskog

I am trying to write a query in access that will pull results that are in the database in a text field and convert to where I can get a average...

2redline@gmail.com

01-12-2006 04:10 PM
Hugo Kornelis

Sr. Java Developer Location: Denver, CO Duration: Long-term Stratdate: ASAP Mandatory Skills : · Proficient in Core & Advanced Java · Proficient...

Radhesh Reddy

01-12-2006 01:51 PM
Radhesh Reddy

I have a customer who wants to SELECT records based on a partial match in a text field. For example, in a list of telephone numbers they want to...

Andrew Chalk

01-12-2006 01:41 PM
Andrew Chalk

Hello, I need to be able to select only the numeric data from a string that is in the form of iFuturePriceID=N'4194582' I have the following code...

Tim Groulx

01-12-2006 11:54 AM
Robert Klemme

I'm planning to establish a recovery plan for my SQLServer 2000 databases. How to change home and data directories?

hazly

01-12-2006 02:35 AM
hazly

installation of their softwares? If there has NEVER been a backup of the Database (.mdf), Recovery Model Set to Full, and there has never been a...

bd420

01-11-2006 04:25 PM
Erland Sommarskog

There a stored procedure or query that will count all the records in all my tables in a database. One of these two - exec sp_MSforeachtable...

digispace

01-11-2006 04:09 PM
Erland Sommarskog

Hi: Does anyone know if IBM (or any other IT Software company) offers store procedure classes anywhere in the country? Thanks Marc

Marc

01-11-2006 03:16 PM
Marc

I am trying to query a table of items There is a field for the name of the item, price, quantity etc. When I query I would like to return a "total...

Erich93063

01-11-2006 01:46 PM
Erich93063

Hello, I only have remote access to the db via textual interface. Now I try to find out what an existing stored procedure is doing. I tried like...

Paul

01-11-2006 12:57 PM
Dirk Van de moortel

I orginally posted this to microsoft.public.sqlserver.ce but had not received any responses. I have a CF.NET application (C#) with a SqlCE database....

Rod

01-11-2006 10:12 AM
Rod

Hi, I have a view that looks something like this - CREATE VIEW myview AS SELECT myudf(col1) as col1, col2, col3 FROM mytable The view has an...

bsandell@gmail.com

01-11-2006 02:27 AM
Erland Sommarskog

I'm using SQL SERVER 2000 and in the process of establishing recovery guide. Tried to rebuild master using rebuildm.exe but the "Configuring...

hazly

01-10-2006 07:57 PM
hazly

Colin Spalding (pupil (AT) alottolearn (DOT) com) writes: In SQL 2000, there is no possibility to suppress the error. You will have to this from...

Erland Sommarskog

01-10-2006 04:53 PM
Erland Sommarskog

I created a new user (Joe_Reader) and gave this user the db_datareader Role. I then went and specified what tables and queries would this user see. ...

Juanito

01-10-2006 03:32 PM
Tom Moreau

Please find the details of the requirement as follows : Location :- SFO,CA Duration :- Long Term Start date :- ASAP Job Description: Seeking a...

Radhesh Reddy

01-10-2006 02:56 PM
Radhesh Reddy

Hi, Does SQL support update to multiple rows where values coming from a sub-query? e.g insert into TABLE1 select column1, column2, column3 from...

spartacus

01-10-2006 05:28 AM
spartacus

Hi How is SQL Server 2000 better than MySQL? I need to convince my boss as we are contemplating doing a website with either SQL Server 2000 or MySQL...

John

01-09-2006 07:34 PM
Greg D. Moore \(Strider\)

Hey all. Ive got a big problem with an sql statement Im working on. There are 2 tables with a master/detail relationship. The Header Table is the...

Sam.Moretta@gmail.com

01-09-2006 07:16 PM
Sam.Moretta@gmail.com

Hi guys, please help. What I did is : Step1. create a Database named , it's default owner is Step2. create a User in Database named , which...

athos

01-09-2006 04:55 PM
Erland Sommarskog

When you meant place the SQL Server on a network, you meant placing it on a central server? If that is the case, you can have one dedicated server...

adi

01-09-2006 04:34 PM
Erland Sommarskog

I have created an SSIS (think that is what DTS is called now) package to run on a SQL 2005 server. It's job is to connect to a SQL 2000 server,...

JayCallas@hotmail.com

01-09-2006 04:25 PM
Erland Sommarskog

I'm applying schema changes to a replicated database. One table has approximately 3.5 million rows and I'm planning on adding a column to it via...

Brian K

01-09-2006 02:19 PM
Brian K

One of our clients is in need of following Oracle Apps CRM Functional Consultants. Please here with find the requirement details as follows. Oracle...

Radhesh Reddy

01-09-2006 09:25 AM
Radhesh Reddy

Hi, I'm having problems constructing a nested join. It's quite complex, so here's a simplfied example of the problem. Any thoughts on what I'm doig...

Steve C

01-09-2006 07:55 AM
ng@zankl-it.de

Hi all, I get this message when trying to update a tabel i have which has nested hierarchies. The current hierarchies beginning from root = 1 are up...

coosa

01-09-2006 05:15 AM
Erland Sommarskog

Hey all. Ive got a big problem with an sql statement Im working on. There are 2 tables with a master/detail relationship. The Header Table is the...

Sam.Moretta@gmail.com

01-09-2006 02:32 AM
Sam.Moretta@gmail.com

Hi guys, please help. What I did is : Step1. create a Database named , it's default owner is Step2. create a User in Database named , which...

athos

01-08-2006 01:49 AM
athos

Visit http://www.dbnest.com/dbexperts.php for listing of DB Experts.. Saghir Taj MCDBA www.DBNest.com: The Nest of DB Professionals.

saghir.taj@gmail.com

01-08-2006 12:24 AM
saghir.taj@gmail.com

I have a database whose transaction log has swelled to 70 Gig Overnight. Disk space free is only 30 gig therefore it won't let me back it up. Any...

Barry

01-07-2006 01:51 PM
Greg D. Moore \(Strider\)

Hi all, I have posted the same topic under ASP-NET-Developers but had no reply; I then posted it under ASP.Net Community and had also no...

coosa

01-07-2006 11:09 AM
Dan Guzman

Søren Larsen (sblar1 (AT) surfpost (DOT) dk) writes: An error in a trigger aborts the batch. Thus, in SQL 2000, there is no way to handle the...

Erland Sommarskog

01-07-2006 06:03 AM
Erland Sommarskog

In a stored procedure (SP1) I am looping through a cursor with records from Table1. Each record in the cursor is inserted into Table2. Insert trigger...

sblar

01-07-2006 04:55 AM
sblar

each table has a auditime field which keeps the last data who modified. I set this field as a datetime datatype and default value is getdate(), so...

TGEAR

01-06-2006 10:28 PM
Alexander Kuznetsov

Thanks. SQL User Defined Functions only allow you to save one template. Do you know which one is the default installed by SQL Server 2000?

jhmosow@gmail.com

01-06-2006 04:45 PM
Hugo Kornelis

I am doing a mass update of our SQL script files by adding dbo. to all references to the tables. The code is also adding dbo. in front of existing...

serge

01-06-2006 02:39 PM
John Bell

Hello, I am new to Google Groups, my name is Derek Comingore. I have just recently started an online sql server community at...

comingdt@hotmail.com

01-05-2006 09:01 PM
comingdt@hotmail.com

Hello, I am new to Google Groups, my name is Derek Comingore. I have just recently started an online sql server community at...

comingdt@hotmail.com

01-05-2006 08:34 PM
comingdt@hotmail.com

I'm having problems upgrading to 2005 Trial from 2000 Standard Edition. Despite the ms docs saying this was a valid upgrade path and running the...

Rich

01-05-2006 04:08 PM
John Bell

Hi, all... Is there a tool out there which will allow me to save/export data from SQL Server 2000 (SP4) tables as a series of insert statements? I...

BD

01-05-2006 02:16 PM
BD

Dear All, Our project was done in SQL 2000, now we are migrating to 2005. however, there are lots of command such as: a) SELECT * FROM...

athos

01-05-2006 10:49 AM
athos