create table #cars(

carname varchar(20)

)

go

insert into #cars values('ford')

insert into #cars values('ford')

insert into #cars values('ford')

insert into #cars values('honda')

insert into #cars values('honda')

go

Select top 1 carname,count(*)

from #cars

group by carname

order by 2 desc

At a guess , that is the number of seconds from 01jan1970

try this

select (1231151827/60)

select 20519197/60

select 341986/24

select dateadd(dd,14249,'19700101')

SQLProfiler is the tool to use

try this

http://pentonizer.com/sql-server/introduction-to-sql-profiler/

If you are running over an extended period server-side traces are more efficent

Hi ,

this should do for your first query

with cteSites(SiteID, Priority , Value ,RowN )

as

(

select SiteID ,Priority , Value ,row_number() over...

Im confused as how your question relates to the query plans.

The query plans ( which are identical between the fast and slow) are a single query but you say that...

Try this link

http://www.karaszi.com/SQLServer/info_datetime.asp

Use temp tables and insert into those

something like this

Create Procedure x

as

Create #Tab1 (

Col1 integer)

Create #Tab2 (

Col2 integer)

Insert into #Tab1 Select x from yourtab where a=b

Insert into #tab2 Select y...

Bookmark lookup ?

http://www.sqlservercentral.com/articles/Performance+Tuning/bookmarklookups/1899/

Steve Jones - Editor (8/17/2009)

---

And what worries me about #2 is that people will just accept the answer and run things, not bothering to check themselves if they can't check...

Its not the 'dumbness' of question that is the issue , after all everyone has limits to their knowledge.

What may seem obvious to you may not be obvious the me.

A...

This should help you along

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

How exactly does it not work ?

Does it error or return no rows ?

Anything scheduled for the next week or two ? Might make a nice...

Jack Corbett (7/21/2009)

---

Dave Ballantyne (7/21/2009)

---

Hi ho hi ho , if off to Disney i go , see you all in 4 weeks.

Enjoyed my short time here, more rewarding than...

Hi ho hi ho , if off to Disney i go , see you all in 4 weeks.

Enjoyed my short time here, more rewarding than usenet anyway