how can copy, paster the execution plan?

Even I tried by executing the SP 'with recompile' Option. Still its taking the same amount of time.

Thanks.

SELECT college_id,department_id,student_id,SUM(marks) as SUM

INTO #temp

FROM student a INNER JOIN college

ON a.college_id=b.college_id

GROUP BY college_id,department_id

SELECT * #temp

SELECT MAX(sum),MIN(SUM) FROM #temp

I am doing as above instead as shown below.

SELECT college_id,department_id,student_id,SUM(marks) as SUM

FROM student...

I need to get all the result set and max ,min values,not only max and min.

SELECT * #temp

SELECT MAX(sum),MIN(SUM) FROM #temp.

I need results of both the results without using temp...

create table #ids( n int,name varchar(20))

 insert into #ids (n,name) values (7534,'tt')

 insert into #ids (n,name) values (7535,'tt')

 insert into #ids (n,name) values (7536,'tt')

 insert into #ids (n,name) values (7537,'nn')

 insert into #ids (n,name) values...

Still I could not make the solution with ur tip. Can anyone give the straight solution to my problem.

Thanks.

num  name   

7534  tt

7535  tt

7536  tt

7537  nn

7538  nn

7539  tt

From the above data set how can get the following result

start  end name

7534 7536   tt

7537 7538   nn

7539 7539   tt

How can I get  the...

Id

----

7513

7514

7515

7516

7517

7518

7519

7520

7521

7522

7523

7524

7525

7526

7527

7528

7529

7530

7531

7532

7533

7534

7535

7536

7537

7538

7539

----

7568

7569

7570

7571

7572

7573

7574

7575

7576

7577

7578

7579

7580

7581

7582

7583

7584

7585

7586

7587

7588

7589

7590

7591

7592

7593

7594

7595

7596

----

7688

----

7695

7696

7697

7698

-----

7700

-----

IF I have these Ids with me and the data between the two dashed lines is a series of contiguius data.

how can I get  the following result. Starting and ending...

I am still working with the above hint.Not successful so far.

Its for the same name.

no, I will have only 1 record for the same date.

Thanks.

If there are 10 then only the first. If there are 11 then first and eleventh.

yes,please.

yes,group of tenconsecutive minutes in the same result. Suppose if i have 25 consecutive minutes I need to get first and eleventh record.

Thanks.

HI Remi,

WE are collecting the department info.

Every department was set two electric power levels one High and the other low. Suppose if The electric power is beyond the higher level...