I think you are heading towards some sort of SQL differencing tool - ie something that allows you to compare two SQL Server dbs and identify schema differences between the...

Update and select statements are separate and exclusive in T-SQL and as far as I know there is no single statement that will do both. Can you give more...

Lots of good points highlighted and looking forward to reading part 2.

Under no circumstances should you enter '19' by hand - that's what computers are for Also, you wouldn't be able to easily...

Many thanks - will try that when I get a chance.

Phil

You should backup your database before trying this ...

In Enterprise Manager, just make a design change to the datatype of the varchar field (change it to 'datetime') and save. You...

I would add a WHERE clause to this, along the lines of

UPDATE Fee_Maxima_Benchmarks

SET Fee = CEILING(Fee)

WHERE Fee CEILING(Fee)

The slight amount of extra processing involved is worth it to...

What sort of trouble are you having? Do you want to batch the updates?

Not sure that I follow the process. Do you want to automatically create a record in TicketH whenever one is added or amended in Ticket? Is SeqNbr just...

Your UPDATE statement needs to contain a WHERE clause which specifically excludes all records which have already been updated - and this will, of course, depend on your update logic.

Note...

Try something like this:

select top 3 record, date, country, sales

from (tablename)

order by sales desc

I suspect that your problem occurs before the Select statement has a chance to run on the linked server, so your @error checking never executes.

Your method of error trapping will...

You might like to qualify 'decimal' with 'precision' and 'scale' arguments - eg decimal(9,5) gives you 9 decimal positions per number to play with - up to five of them...

Here's a routine that executes the same command for all databases in an instance.  You should be able to modify it to plug in your commands.

declare @sql varchar(400)

set @sql='select...

I too have seen this error, with queries like

select * from table1 t1 where t1.id = (select t2.id from table2 t2 ... where t2.id = t1.id)

The error occurs when...