The database is on different server which has SQL Server 2005 developer edition with SP2
The java application and SSMS we running from Client PC...
Stored procedure takes 50 mints if we run from SSMS(SQL Server 2005 Developer edition) and same store proc takes 2 mints from Java applcation...
I do same job using command prompt calling from sp.
Look into 7zip or rar exe to run from command prompt then use is same in your stored procedure....
I have 2 tables as follows:
TABLE 1TABLE 2
5921/12/2005 00:003.6600121/12/2005 00:00
Separate names with a comma.