Try something like

CREATE TRIGGER tr_Update

    ON tableA

    FOR UPDATE

AS

   INSERT INTO tableB (<FIELDS>)

     SELECT...

Piggybacking on Andy's response.

You could add a separate table with the tree depth for each parent ID. You should keep this up to date using triggers on the parent and...

A second approach could be to attach the machine 1 databases on machine 2 on a different database. If that's done, you can copy only those objects from one database...

First of all, you cannot use a variable to return from a dynamic SQL.

Something like

 EXEC 'SELECT @val=Field FROM TABLE'

does not work.

You can use...

Allan, great that I got you off in the right direction. I can see my (stupid) error now...

This is still a hard problem to tackle. Especially the parsing of the string in Table1...

If you have a working solution for that, you can get all possible combinations using...

Try this

SELECT PM.Client_StaffId,

       PM.PhoneNumber_Email,

       PM.Extension,

       PM.PhoneTypeId

FROM t_PhoneMail PM

WHERE...

This is a general 'feature' of UDFs. They tend to be slower than a native T-SQL solution.

The reason for this is the fact that the query optimiser treats a UDF...

Like you said before, IP traffic does not carry MAC addresses over WAN links. So you cannot use that.

When the identity reaches the maximum for an int. It will stop accepting records (overflow error).

The only way around this is using a GUID column, but that adds some overhead...

By the way alzdba, IDENTITY does not reuse values that have been deleted...

Try this...

SELECT ISNULL(min(BudgetId),

       ISNULL((SELECT max(BudgetId) + 2

             ...

This would give you the customers that are in this situation :

SELECT cust.* FROM Customers cust

WHERE cust.dup_code = 1

AND EXISTS

(SELECT 1 FROM Customers c2

 WHERE c2.surname...

Uday, first of all, your second part does not take a set based update into account.

This might give you some problems if more than one device is updated in one...

I'm using Enterprise Developper.

Architect is interesting if you need the design tools like Visio (to do UML and database modeling) and Enterprise Templates (to build your own templates to start...