Thanks Jeff , hindsight on the isnull issue 😉

http://beyondrelational.com/blogs/dave_ballantyne/archive/2010/05/19/null-or-coalesce-what-s-the-difference.aspx

Apologies , my bad

Then you can use a derived table as Kingston suggested, or a CTE

Probably be easiest to create a view if you need to use the calculation in multiple statements

Well i would of said that way back but you stated ...

Which would rule out parameter sniffing.

GilaMonster (6/24/2010)

---

And you...

As far as i know ,probably wrong, but fn_trace_gettable is the only way to read .trc files. The trace file wont tell you how many transactions there have been...

Not really , but your distribution database would be growing in size.

Follow the links i gave you before.

+1

Investigate the windowing functions in Books on line

Start here

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Then here

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Worth pointing out that 2008 does have some additional logic to test for date equality

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/09/11/datetime-lookups.aspx

!= is a C style not equal operator and works just fine in SQLServer.

declare @x int,@y int

select @x = 0

select @y = 1

if(@x != @y) begin

Select 'not...

Very apt 🙂

troy2.net (6/23/2010)

---

Well gud answer

It has been asked for , i do no , i would like to know the answer so through this i will learn those things to do...