What's the best way of removing duplicates records?
Tue, 15 Jul 2008 15:03:28 -0400
Hi All,
What's the best way of removing duplicates records? I need to check for duplicates records based on first name, last name, address phone and zip. It always could based on a different fields set.
Thanks,
Joe
...
|
Computed value question
Tue, 15 Jul 2008 14:24:11 -0400
Hello, here is what I am trying to accomplish;
I have a table students with a field that I would like to calculate a
current balance, this balance would come from another table transactions
they each have the id_num value that ties them together
students:
id_num
f_name
l_name
balance
transactions:
...
|
Stored Procedure Security Question
Tue, 15 Jul 2008 17:16:23 +0100
Hi
I have two databases. For simplicity, lets call one Vehicles and the other
Sales.
In Vehicles, there is a view called Fleet.
In Sales, I have a stored procedure, called FleetDetails_Read. It takes a
Client parameter, and return vehicle details for that Client, by reading
from Vehicles.Fleet
I'm wonder ...
|
Email alert
Tue, 15 Jul 2008 10:35:53 -0400
I am dumping some information into a table from another database. I need to
periodically run a routine on this table that will calculate/update the
hours in the table and if the hours go above 24 I need it to send an email.
Can someone point me in the right direction to make this happen. I am very
new to SQL ...
|
Buying a new server
Tue, 15 Jul 2008 12:37:53 +0100
Hi
I've being put in charge of buying a new machine, to host SQL Server 2005.
Currently using SQL 2000, with the largest database at 10Gb. About 500
transactions per hour. At nighttime, there is a bulk import from another
system, for the reporting databases.
I'm a bit confused about the disk layout. From wha ...
|
Silent installation of SQL Express
Tue, 15 Jul 2008 10:17:51 +0100
Hi,
I'm trying to create a silent installation of SQL Express which will create
an instance name of MYPC\MySQLExpress instead of MYPC\SQLExpress
I have tried the following
sqlexpr32.exe /qb INSTANCE=MySQLEpxress
but, even though I had the silent installation, the instance was still
SQLExpress.
Whe ...
|
Winform sql server app
Mon, 14 Jul 2008 21:00:32 +0100
Hi
I am new to sql server and need to build a one-many winform app with visual
studio 2008 and sql server backend and need some pointers.
I have the following questions;
1. If I create the app by creating a relationship between master and child
tables in dataset and then dragging the master table and r ...
|
|
|
Restore Problem
Mon, 14 Jul 2008 15:13:41 +0100
Hi
I have used the backup option on one server to create a .bak of a database
I copied over to another server and then tried to use the restore option but
whatevever I tried I got error 5 access denied on the .bak file
I am logged in as administrator an as far as I can tell I have full control
on both t ...
|
Can't figure out Stored Procedures
Thu, 10 Jul 2008 16:34:42 -0500
SQL 2000 SP3a; named instance: WCTIntranet
DC: Windows Small Business Server 2003 Premium SP1
Application Server: Windows Server 2003 R2 SP2
The DC has SQL bundled in it. I want to place the database files/logs on
the Application Server (were I have MUCH more room).
I deleted the sample databases. I have ...
|
Transfer of records from one table to another
Thu, 10 Jul 2008 12:02:39 +0200
Hi....
I have a problem ensuring the integrety of a move between som busy tables.
I basically have a buffer table into which different processes are
delivering data, these records comes in via some odbc conenctions in random
order, and the number of records can vary from 1 to more than 100.000
between th ...
|
