Update ...

Set val32 = ISNULL((Select vh3 FROM OPENQUERY(....)),0)

Should work. Works fine if the inner select is all local. I don't have a handy linked server to test on.

A tranaction was created by the initial delete statement and the trigger will be part of that.

BEGIN

RAISERROR('Property may not be deleted when it is on a...

You could try searching for " profit "

How are you doing the insert?

Try putting some print statements into the trigger and do an insert from query analyser. That's about the only way I know to get messages/errors...

I've never used calculated fields myself, but from what I understand they update only when the data changes, so it may save you from writing a trigger in the first...

Rule 1: You never need to use cursors

Rule 2: If you need to use cursors, refer to rule 1

I'm not sure I completely understood what you're trying to do, but the below code should be fairly close to what you're trying.

If I've missed the mark by a...

As a suggestion (I haven't read that article)

Three tables (or more as your system requires)

A person table (contans person's name, id, etc)

A Person-BudgetNumber table (essentially a many-to-many link between Budget...

Don't know whether it has much, if any, affect on the server. I have found cases where it matters on the client.

That said, I personallty prefer the format yyyy/mm/dd as...

Are you pulling data from a non-sql server source? I've before found, especially on mainframes, that dates are set to 0000-00-00 to indicate no data.

Does very much sound like you've...

It is possible, however bad database design leads to overly complex queries. and inaccurate results from queries

It is a much better solution to have a properly normalised database structure and...

no guarentees, but it should give you some idea

select count(customer), left(customer,CHARINDEX ('-', customer)-1) AS StoreName, city, st

from table

group by left(customer,CHARINDEX ('-', customer)-1), city, st

Select col1, max(col3) as MaxCol3 from tbl group by col1

Because I forgot to initialise the string first and uninitialised strings are null. Add this before the select and it should work

Select @finallist =''

This should work.

Create Function dbo.RO_TEST (@COMP VARCHAR(50))

Returns Varchar(1000)

As

Begin

Declare @finallist As varchar(1000)

SELECT @finallist = @finallist + C.[CLIENT] + ', '

FROM [_SMDBA_].[_CUSTOMER_] C, [_SMDBA_].[_COMPANY_] CO

Where...