This is a very good site for that information

Although I don't really understand what you want to do, take a look at C2 auditing in BOL. Should give you what you need.

...and a whole lot more of...

Maybe you should post what you have so far, along with some sample data and what you expect to get. Sounds like there is an easier workaround.

For your last quesion:

No,...

In QA go to Extras-> Options.

Click on the result tab, select the appropriate settings in both combos (Sorry, I have the German version of QA, so i don't know their...

Hehe, posting this on behalf of a very knowledgeable, but shy friend

SELECT IDENTITY(int) AS ID, Order_No, Item

INTO #TempSeq

FROM Seq_T

ORDER BY Order_No, Item

...

Unfortunately I know some accounting, so this is very confusing to me.

Hey Jonathan, that's more than the guys at Enron and MCI Worldcom can say

I pretty often pipe the result of a query in QA to a *.csv file and print it with Excel.

Well, I would probably wait if someone comes up with a solution to this and if not remove dups. Right out of the head I can't find a solution. However,...

Easy is not equivalent to better

After all the formulae should not change frequently, or?

Touchè, brilliant answer

Bit rough round the edges, but this might be a solution

set nocount on

if object_id('seq_t')is not null

drop table seq_t

go

create table seq_t( order_no...

What front-end do you use?

Do you want a copy of your table?

If not, you can always give an alias when querying the data of the table.

Please see my answer here

Well, not mine, but Kalen Delaney's.

Quotation from Inside SQL Server 2000:

Explicit and Implicit Transactions

By default, SQL Server treats each statement-whether it's dispatched individually or as part of a batch-as independent and immediately commits it. Logically,...

So, why don't you run the query when it works?