As gail suggested first read that post.

by the way , press CTRL M and then execute the query , it will provide you the execution plan , save...

Post your Execution plan

and IO statistics.

No, query is returning correct results.

i have planned to add event_duration column as include column.

Will it help ?

create nonclustered index idx on #emp (e_name)

create nonclustered index idx on #dept (dept_name)

select

e.e_name,

...

Why u require User defined variables , what exactly u want to do, post some details about your issue

RESOLVED !!!!!!!!!!!!!

i simply opened it in notepad and replace d: with t::-P

can u post the link ? where i can find the difference between them

GO

CREATE TABLE dbo.PENDING_ANSWER_FILE

(

acct_id dbo.ut_synthetic_key NOT NULL,

qstn_stub dbo.ut_stub NOT NULL,

entity_stub dbo.ut_stub NOT NULL,

evt_stub dbo.ut_stub NOT NULL,

invitee_stub dbo.ut_stub NOT NULL,

entity_type_id smallint NOT NULL,

answer_file_stub dbo.ut_stub NOT NULL,

physical_file_name dbo.ut_medium_description NOT NULL,

friendly_file_name dbo.ut_medium_long_description NOT NULL,

file_image...

amar , try to run the script i pasted in my previous past and u will find reply

i read that (you had asked me in my prior post)

but how it will help

when we have table (with Pk + non clustered ) on one filegroup

and clustered...

is this what u looking for ?

create table #tmp

(

Roll_No int,

S_Name nvarchar(100),

Subject nvarchar(100),

Branch nvarchar(20))

insert into #tmp

select 1 , 'jack', 'Bio', 'A' union

select 1 , 'alex', 'tech', 'f' union

select 1 , 'Sona',...

send some sample data and ur requirement ?

Thanks

it working well

Gail ,

Thanks a lot , your links helped me a lot.

i am very curiuos about how index works and found very interesting them.

mean while, i am also...

hi

i read somewhere in your blog ( missd that ) . where you have mentioned about the link

from where i can douwnload eBook of Sql server 2005 :...