Not a batch file, but a VBScript file that uses CDO:

http://www.paulsadowski.com/WSH/cdo.htm

I suggest you read this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp

If possible, grab a test PC, start tracing the perf counters mentioned, and run the .Net client app.

It sounds like the SQL connection mantra of...

What's the architecture ? Are these smart client apps running on 50 individual PC's all making connections from each PC to the server, or is it an ASP.Net web app...

Something like Apex SQLEdit would provide this:

http://www.apexsql.com/sql_tools_edit.htm

Also, tools like TextPad and UltraEdit have add-on syntax definition files to syntax highlight various source code types:

http://www.textpad.com/add-ons/synn2t.html

http://www.ultraedit.com/downloads/additional.html

SET NOCOUNT ON|OFF

It's not entirely clear what you're trying to do. Why is data in the form:

3, '5,6,7,8,9,10,11'

Wouldn't you have to parse that up again ?

You can call xp_cmdshell to execute an external process with parameters.

>>And very often the table is filled up with nulls up to 65554 rows (just like the length of an excel sheet).

This is a known bug in DTS. When processing...

The existing contents of the 3 columns being updated can have an affect on performance. If they are previously NULL and you're updating any of them to non-NULL, it changes...

You are missing the FOR keyword on your cursor declaration:

declare get_email_id  cursor FOR Select ....

>>The dyamic code works great

Until your 1st SQL Injection attack from the ASP page ...

Re: The above example using Functions. This will never execute faster than a normal set-based approach. Using a Function in the SELECT posrtion of a query, where the function itself...

How about left-joining @aging to a derived table that contains all the required cd/bkt combinations:

Select a.dt, dt.cd, dt.bkt, IsNull(a.cnt, 0) as cnt, IsNull(a.amt, 0) As amt

From

(

  Select Distinct a.cd, b.bkt

 ...

>>we need to notify that the particular field has changed.

Kinda vague. What form does 'notification' take ?

Assuming each record has a primary key column:

Insert Into Notifications (PKeyColumn, ColumnName)

Select i.PKeyColumn, 'Column1'

From inserted As i

Inner...

Can you run with SET SHOWPLAN ON and post the results ? It would be useful to see what execution plan the optimizer is actually choosing.