How about a server side trace ?

Why is profiler no good ?

I see what you are saying, IMO, for the sake of brevity the question is fine.

It would be a much larger book if every question had a footnote for all...

Derived tables are not temp table (either # or @)

What, i think, that question is doing is drawing a distinction between...

create table #table

(Cola int)

insert into #table

Select cola from tablea

select *...

Absolutely.

Since 2 is just a subset of 1 , try something like ...

Sum(case when datediff(mn,DateTimeIn, DateTimeOut) < 60 then 1 else 0 end)

Additionally , you may find...

Try this video from Brent Ozar

http://www.brentozar.com/sql-server-training-videos/perfmon-and-profiler-for-sql-server/

Cast and Convert can use a series of known formats

http://msdn.microsoft.com/en-us/library/ms187928.aspx

However DDMMYYYY is not one of them , it would be nice if you could provide a User Defined format,...

Build the date using substring as you have done , but to the format YYYYMMDD and you will be fine.

Steve ,I like the use of the values clause 😎

I dont normally post other forums "posted questions getting worse" but this one i had to share.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/ce4bc469-c62a-4751-8524-062cd67df730

Q1 ) How to make dateadd subtract.

Q2) How to subtract not 15 but 30...

An optimal solution would involve changing the query in some way.

SQLServer cant do magic. It is *probably* returning the optimal query plan for the query it has been asked.

Damn Damn Damn, ive mislaid my sql magic wand.

http://www.sqlservercentral.com/Forums/FindPost937995.aspx

Perhaps if i shouted at the server .....

Please post DDL, sample data and the code you have so far.

If you do you will probably get better responses.

Myth.

http://scarydba.wordpress.com/2009/10/13/table-variables-are-only-in-memory-fact-or-myth/

Good stuff.

Hope you understand your mistake.

How does

Select TableA.TableAName

from TableA

where TableA.TableAName like 'H%'

union -- ALL (possibly!!)

select TableA.TableAName

from TableA

join TableB

on...