I have inherited a database that tracks if a customer ordered a product, with 1 being a yes and 0 being no. What I want to do is sum those columns...

azriley@gmail.com

06-27-2007 12:09 PM
azriley@gmail.com

Hello, I need to alter fields in all my tables of a given database, and I would to do this via a t-sql script. Example, I want to change all fields...

rcamarda

06-27-2007 10:25 AM
rcamarda

All, I'm new to MS SQL Server and I'm wondering if there is a free client that will allow me to connect to a remote SQL Server instance. Currently I...

Sashi

06-27-2007 07:07 AM
Erland Sommarskog

Hello, I currently have Table1 and View1. View1 is a query from 2 or 3 tables that works fine on its own. However in my current query if I try to...

Yas

06-27-2007 05:55 AM
Erland Sommarskog

If I have table1 and table2 with table2 having multiple rows tied to a single row in table 1. What I am trying to do is set up a view that has one...

M@

06-27-2007 02:29 AM
Erland Sommarskog

I've got a weird one here. I'm running a DTS package on SQL Server 2005. It copies a bunch of stored procedures. I renamed them on the originating...

jshunter@waikato.ac.nz

06-26-2007 09:07 PM
Roy Harvey

Hi, I got 'Invalid Column Name NewCol1' when I query the following: Select col1, col2, (some calculation from the fields) as NewCol1, (some...

sweetpotatop@yahoo.com

06-26-2007 03:29 PM
Hugo Kornelis

Hi, I have a question regarding best practices in database design. In a relational database, is it wise/necessary to sometimes create tables that...

nyathancha@hotmail.com

06-26-2007 03:14 PM
Hugo Kornelis

I have a customer using our program with SQL server and is occasionally getting a "Transaction (process ID xxxxx) was deadlocked on lock resources...

Altman

06-26-2007 12:36 PM
Alex Kuznetsov

Hello All, I am trying to create a DTS package. I have two tables tbl_A and tbl_B with similar data/rows but no primary keys. tbl_A is master. I...

jb1

06-26-2007 11:12 AM
Ed Murphy

Hello, Using SQL 2005. Columns: ID, int (PK, auto-increment by 1) WorkHours, int Name, varchar(100) I can't seem to get the following query to...

webdevaccount@gmail.com

06-26-2007 10:54 AM
Ed Murphy

I am trying to compare the last two values in the same column of a table. First of all, I have a column titled Row_Index that uses an index which...

mcolson

06-26-2007 08:19 AM
Roy Harvey

im trying to understand how the profiler works. so i started 2 profilers,one listen to another and I saw the profiler is running: exec...

ofirmgr@gmail.com

06-26-2007 06:55 AM
Dan Guzman

Hello, We are using SQL server 2000 on W2k Server and MS Access 2000 ADP (like front-end). Now we try to change operating system for SQL Server 2000...

Maciej07@gmail.com

06-25-2007 05:02 PM
Erland Sommarskog

I am doing an update to set a field value = anothe field value (in the same table) where it is not supplied. I'm handling this in the trigger, but am...

DennBen

06-25-2007 04:56 PM
Erland Sommarskog

Hi folks I have a little problem converting from an access database to the SQL server I need to have a highscore that shows the top 10 scores,...

zuuperman

06-25-2007 07:32 AM
Roy Harvey

Hi Folks, I'm not certain if this is the correct group to post this question in, if there is a more appropriate one please advise. We have a cube...

Tim

06-25-2007 04:50 AM
Tim

I'm trying to get into an installation of v.6.5 to use with another server and I need the following information: Database hostname Database...

MackTheKnife

06-25-2007 02:26 AM
Erland Sommarskog

Hello, I have a problem. I've linked MySql server to MsSql, in MySql I have a table with Latvian data(character set is ucs2, ucs2_general_ci) and the...

=?utf-8?B?UMSBdmVscyBNaWhhaWxvdnM=?=

06-25-2007 01:48 AM
P vels Mihailovs

Hi Friends, Is there any way to get the table name which is referenced by the foreign key for example: consider two table "Staff" and...

ArunDhaJ

06-23-2007 08:00 AM
Marcin A. Guzowski

All, Just want to make sure that I understand what's going on here. I have a table with IGNORE_DUP_KEY set on a unique, multi-column index. What...

Weyus

06-23-2007 04:09 AM
Erland Sommarskog

Jim Lawton (usenet1 (AT) jimlawton (DOT) TAKEOUTinfo) writes: In SQL Server, you need to provide an alias for the derived table: SELECT * FROM...

Erland Sommarskog

06-22-2007 04:33 PM
Roy Harvey

I have read all of the posts regarding this subject as well as 3 "Dummies" guides and I keep having the same problems. I have a very simple...

Billy

06-22-2007 04:29 PM
Erland Sommarskog

CREATE TABLE ( (10) NULL ) CREATE TABLE ( (10) NULL )

rshivaraman@gmail.com

06-22-2007 09:00 AM
rshivaraman@gmail.com

Hi, I am looking to check and set the encoding of the database using sql commands that work both for SQL-Server and JET. something equivalent to...

maarten

06-21-2007 05:18 PM
Erland Sommarskog

Hi Friends, Is there any tool or assistant to upgrade SQL 2000 to SQL 2005. Thanks, Arunkumar

Oonz

06-21-2007 05:10 PM
Erland Sommarskog

i have a copy of a SQL Server 2000 database on an external hardrive. I have SQL Enterprise Manager 2005 on my laptop and was wondering if it is...

Steve F

06-21-2007 05:02 PM
Erland Sommarskog

Hello I have a VB6 application using classic ado (MDAC 2.8) for connecting ms sql 2000 server. Application uses a lot of server side cursors. Now I...

szymon.strus@gmail.com

06-21-2007 04:48 PM
Erland Sommarskog

Hello everyone, I have a fairly unique need :) I am trying to determine the use/clients for databases in my corporation that I am maintaining, but...

jlaustill@gmail.com

06-21-2007 08:08 AM
jlaustill@gmail.com

Is there a way to read a backup file to see if it contains a file without restoring the backup file? We are missing a record from a table, and I...

Neil

06-20-2007 04:58 PM
Neil

I have googled by heart out trying to find answers to this and am only more confused. DB Server: Windows Server 2003 Enterprise 4 GB memory SQL...

michael

06-20-2007 04:17 PM
Erland Sommarskog

I need to find the rows that exist in one table but not in the other with this condition: (prod_name exist in table1 and not in table2.prod_name )...

yuval

06-20-2007 03:55 PM
Hugo Kornelis

Hi! I am trying to do a simple udpate on a table and I am getting the error: "Cannot insert duplicate key row in object 'UserInfo' with...

SJ

06-20-2007 02:27 PM
Roy Harvey

Hi. I have an 'Attendance' table like this: PIN Year Category Days 1 2006 Authorized 1 1 2006 Available ...

Radu

06-20-2007 10:12 AM
Jason Lepack

Hi I`ve Ms SqlExpress 2005 and question how to export/import all databases to/from file. Bcp.exe can do it but only for a table I think. Pls...

mw

06-20-2007 05:32 AM
Dan Guzman

I have a problem. I created a dataset in visual studio 2005 which use tables of SQL Server Mobile. When I create insert query in the relative...

marcosalvadeo@gmail.com

06-20-2007 12:19 AM
marcosalvadeo@gmail.com

Is there a way to limit what user will see in Enterprise Manager? I would like them to only see there db's and not all them.

OVDaddy

06-19-2007 05:18 PM
Plamen Ratchev

Hi, After sending a request, I would get the possible error message. Not the code @@error, nor the exact content of sysmessages, but the message...

TSalm

06-19-2007 04:21 PM
Erland Sommarskog

Hi, I have two seperate production machines that I'm trying to get to play nicely together. This setup has worked for years before - until recently...

xx75vulcan

06-19-2007 04:12 PM
Erland Sommarskog

Title DBA/Database Developer Overview Our client is seeking a DBA/Database Developer to join an up-and- coming leader in the internet social...

Miriam

06-19-2007 03:06 PM
Miriam

DOTNET DEVELOPER Location : Raleigh, NC Duration : 6 Months Start Date : ASAP Required: · Minimum of 3 years experience as a VB.NET...

deepak.kspectraforce@gmail.com

06-19-2007 10:03 AM
deepak.kspectraforce@gmail.com

Hello, Please can you point me in the right direction. I have a table (JobMain) that holds a list of all jobs that out engineers need to work on or...

roblowein

06-19-2007 08:45 AM
roblowein

I'm trying to write a query to associate to an alternate key. Can someone provide the right syntax/keyword I need to accomplish this? Here's the...

jeffejohnson@hotmail.com

06-19-2007 06:56 AM
M A Srinivas

HI IS THERE A WAY TO GET MY PROC FASTER IT RUNS OK NOW BUT I JUST NEED IT FASTER THANKS. CREATE PROCEDURE SP_ORDERSUBMISSION @SENDRECORD BIT, @TYPE...

Uncle Rico

06-18-2007 05:34 PM
Erland Sommarskog

I am working on a server/client application where the client scans a computer for all available mac addresses and stores the information in a...

rhaazy

06-18-2007 04:26 PM
Erland Sommarskog

Hi : 1. I import data into sqlserver, from an excel file, from a worksheet within it, named 'input_data' 2. then i scrub the data in sqlserver 3....

rshivaraman@gmail.com

06-18-2007 10:41 AM
rshivaraman@gmail.com

I am trying to write a user defined function that will allow me to strip off the last carriage return and line feed from a text field. We have...

whitej77777@gmail.com

06-18-2007 08:09 AM
whitej77777@gmail.com

Hi group, being pretty new to setting up sql server, I am stuck. Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via...

finn clement hansen

06-18-2007 12:38 AM
finn clement hansen

Hi Masters , Please have a look on the following issue : We have a MS - SQL Server 2005 Server which is accessed through many client machines . We...

Phoenix

06-17-2007 11:08 PM
Phoenix

Hello, I am working on an Access VBA application, working in client/server mode, with a shared SQL Server base. I have to INSERT some data in the...

ByB

06-17-2007 08:35 AM
Erland Sommarskog