Changing into Stored Procedure is not a problem,but it is the same query which is going to run in the Server.IS THERE ANY WAY WHERE WE CAN HAVE SIMULTAENOUS QUERIES...

MY CPU usage at Server reads 100% when those reconcilation happns and Vb doesnt support multithreading ,is there anyway i can multithread in SQL server

Thnaks a lot buddy,if u can give me u r yahoo messenger/MSN messenger Id i will add as my friend and can have regular chats,if u r intrested in

Here is the stored procedure code:-

Create proc sp_ActsDetailsNew (@fromdate as datetime, @todate as Datetime, @compname as char(30), @linked as char(1), @retValue as int OUTPUT)

as

BEGIN TRAN

Set @retValue = 0

WHILE (select count(*)...

hi Antares686,

now i have made all stored procedure into one and havent heard problems from the client yet(for the past 3 days).

Still i am puzzled why this has happnd,anyway i...