There really is not a simple answer , but its all down to understanding the query plan.

Heres a link to an ebook on the subject.

Please see this[/url] article on how to help us to help you.

In that case you could try inserting to a temp table with an identity column rather than using row_number(). Havent tried it myself but no reason why it shouldnt...

Hi ,

see my blog here for an article on analysing contiguous ranges.

My personal option would be

DECLARE @Date1 DATETIME, @Date2 DATETIME, @Date3 DATETIME, @Date4 DATETIME

SET @Date1 = '1991/06/01'

SET @Date2 = '1991/06/29'

SET @Date3 = '1991/08/01'

SET @Date4 = '1991/09/04'

;with CteDates(Dates)

as

(

Select @Date1 union Select...

Which part are you particularly needing help with the cte (common table expression ) or row_number() ?

Google is your friend ...

If will work for as...

The error is happening as @Date1 is out of scope inside the dynamic sql statement.

There are a few potential solutions i can think of , but how are you receiving...

Assuming 2005 +

create table ali

(

code varchar(16),

fromcol integer,

toCol integer

)

go

insert into ali values('ali1',1,5)

insert into ali values('ali2',6,15)

go

with ctenumber(rownum)

as

(

Select rownum = row_number() over(order by id)

from...

Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

No to both counts on that one 🙂 , or...

First use SQLProfiler to find out which query is long running.

http://www.developer.com/db/article.php/3482216

Then see gails article on how to post performance issues

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

It will stop all the guess work

I dont think you can do that with DRI , but one solution is :

Create Trigger COACH_DEL on COACH for delete

as

Update TEAMTab

set Coach = NULL

from...

You really must be thinking of someone else,...

Ok now i really read you post with you..

SqlSlammer: Small world, cant say i remember are specific permissions issue though :ermm:

Not true. By way of demonstration...

drop table t1

go

Create table t1

(

col1 integer)

go

create clustered index idxt1 on t1(col1)

go

insert into t1 values(1)

insert into...