Check BOL under "limitations-Analysis Services" and you'll get the info you need.

Phil

Jeez, perhaps I had one-too-many beers last night. Well spotted and I think I'll keep quiet for a while!

BOL suggests that TOP should be used:

"It is recommended that DELETE, INSERT, and UPDATE statements currently using SET ROWCOUNT be rewritten to use the TOP syntax. For more information, see...

I think you could do this using local variables - something like this:

declare @batchno int, @detailno int

SELECT TOP 1 @batchno = d.batchno, @detailno = detailno

FROM detail AS d

INNER JOIN batch...

How about this one? Going back to your very first post on this, if the table is called 'test' and your columns are 'cola' and 'colb':

select distinct 'cola' =...

select top 10

will give you the first 10 rows (and the specific rows which are returned depend on any ORDER BY clause in your query).

Eg, perhaps you...

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...