Well it's like asking us if 3<5 = true !

Depends how much less data is transfered vs how long it takes to create...

There's no exemple I can think of that couldn't be read on performance tuning articles.  You'll have to look there or send us the exact query plan.  We can't just...

Then start looking at both edges .

We can't provide any help unless you post the execution plan on the site. It's like trying to show you how to go somewhere and you don't tell us...

Looks like or is Jeff ?

Ya I know. But it's always good to see both sides of the coin on this one ... before it goes too far!

Just have a look at the execution plan.  I'm sure you'll find it to be the same in this case and I would assume 99.999% of the cases.  The remaining...

Why can't you let the application display the data correctly to the users??

The server is there (mainly) as a datastore, not a report viewer!

I'm a little worried here... Why exactly do you need to modify a table at run time without first knowing the column name??

I know that it happens sometimes when the sessions times out.  But twice in a row is a new one!!

if you want to use where AuditCount = ....

No you can't do that.  You have to use a derived table, then you can use the new colum alias.

However if the...

Great, thanx for the help.

A good place to start would be to read this topic and all subtopics in the books online :

execution plans [SQL Server]

Also once you start unsing it just reffer...