I assume you are using SSMS for this?

SSMS is not designed as a presentation layer so doing something like this is not really possible.

Use a front-end report system such as...

Why write your own windows applicaiton to do this, when you could jsut use SSIS and save yourself weeks of work.

use a lookup component and send the non-matches to a OLE DB connection for the inserts,

for the updates either;

write the update statement in a SQL component with parameters and assign...

you have too many ')' in the 3rd line.

SELECT C.Clstr_Nm,C.CH_typ,

Sum(C.MTD_TRCDMA) 'MTD_TRCDMA',

SUM(C.LMTD_TRCDMA)'LMTD_TRCDMA',

'%Growth' = (Round(CAST(sum(MTD_TRCDMA)AS FLOAT)-CAST(sum([LMTD_TRCDMA])AS FLOAT) / CAST(sum([LMTD_TRCDMA])AS FLOAT),2))

from TR_RECHARG C

Left outer Join ER_Main E on C.CRT_Cod=E.CRT_Cod

Left outer...

To kill a connection you just need to use the KILL statment with processid that you need to Kill.

though I agree with the others that this approach seems a bit...

Check the dataypes of the parameters and what the data types of the variables are; to make sure that they are consitent with the column data types in the...

This sounds like a case of parameter sniffing, where an inefficent plan is being used due to parameters being passed in.

it is explained nicely here

http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/"> http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/

one of...

well at least you are guaranteed to win the world series of baseball..

Steve Jones - SSC Editor (10/5/2011)

---

BTW, noticed of the last 8 teams in the Rugby World Cup, 6 are English in origin (England, South Africa, Wales, Australia, NZ, Ireland). France...

Big games on this weekend its all business now we are down...

Can you post the query and actual execution plan?

Also if your goal is to go from an Index scan to a seek , then this is not always possbile...

have you tried using the phone-book anaolgy?

prakash 67108 (10/4/2011)

---

yes...

it must be done through SSIS...

i have a column name ISHOLIDAY in OLEDB..

also i need to check, if the datetime column value from excel sheet is january 1st...

if you have a staging area in place to write queries you could do this by reading the start data into a varaible from excel,

then use this variable...

For...loop could do this,

are you able to explain a bit more about what you are trying to do?