I'm probably just missing the glaringly obvious but is this equivalent?

UPDATE Table1

Set field1 = field2

go

ILIT

Steve Hendricks

MCSD, MCDBA

AFS Consulting Group

shendricks@afsconsulting.com

(949) 588-9800 x15

quote:

---

I always use singles, not plurals, for table names: tbl_employee, tbl_employee_history.

---

The advice I received was...

I don't know if this is a by-product of submitting a simplified schema or not but the UniqueField column is defined as being NOT NULL but doesn't have a default...

My two cents...

I just wanted to amplify (vent, rant, rave, etc.) on what has already been said about third party support restrictions.

We work with a mid-market accounting package...

It's not clear on what exactly you are trying to accomplish but you may want to look at creatingh a DMO based application.

BOL has details on the COM (ActiveX) interface....

In your stored procedure definition you have listed the parameters as being of type VARCHAR. Since you have not supplied the optional size (e.g., VARCHAR(10)), it is defaulting to...

I much prefer a book to a class. The Microsoft Training Guides are a good place to start but they seem to lack the depth necessary to pass the...

And the answer is...

There was a set of replication triggers defined from a previous attempt to configure replication. They should have been dropped when the other replication objects were...

From within the EM wizard, on the dialog where you define the articles, there is a button where you can define the defaults (Lower left hand side). One of...

I found out that there is a system sproc that can clean things up on either the publisher or the subscriber end of the configuration.

sp_removedbreplication 'DBName'

This resolved my immediate issue......

You might want to consider using the INFORMATION_SCHEMA to reference the database objects. These names are not subject to change.

HTH

Steve Hendricks

MCSD, MCDBA

AFS Consulting Group

shendricks@afsconsulting.com

(949) 588-9800 x15

MKumari,

Your solution assumes that only one record has been inserted/updated.

create trigger TR_InsertUpdate1 on dbo.tblAddress

for insert, update

as

begin

update dbo.tblAddress

set education = 'True'

from dbo.tblAddress a

join inserted i on i.Primary...

Does the DISTINCT keyword solve the problem?

SELECT DISTINCT

Customers.Cust_Name,

CASE WHEN Accounts.Account_No IS NOT NULL

THEN Accounts.Account_No

ELSE 'NO ACCOUNT' END

FROM Customers

LEFT OUTER JOIN Accounts

ON Customers.Cust_Name = Accounts.Cust_Name

AND Customers.Location = Accounts.Location

AND (Customers.Acc_Type...

joepin,

I'm coming late to the party so forgive me if I'm covering old material...

It looks like you are blurring the line between the join and the where clauses. The...

A table is an UN-ordered set of data. Even with a clustered index, the data is NOT guaranteed to be returned in order. It often will come back...