I figured out that SPID -2 is some kind of SQL server process and is visible in Activity monitor.

But, why is it blocking my process? :ermm:

this is because _ is a wildchard character for single character

Thanks Mark!!

The process goes in suspended mode if some...

Roy Ernest (2/26/2009)

---

Thanks both of you for queries.

But here it runs into a small complication.

Let us say Customer 1023 Deposited one amount yesterday (TranID 1) and he also made a...

I don't know how this will perform on large number of records (As row_number is used, the above query requires sort operation.)

But it works even if you have multiple debits...

execute sp_who2

and check whether your job is blocked by some other process

to see what command is executing execute dbcc inputbuffer([yourProcessID])

(you can get the process id from sp_who2)

BTW what kind of...

I don't think this is possible. According to me you have to create 2 different SPs and have 2 datasets for each to get the result.

If someone knows the solution(using...

Thanks Rudy!!

I too doesn't have SQL 2000.

sqlcmd -s ip,port -i [file path] -U usename -P passwrd -Q "Query"

Save the SQL statements in a .sql file and use SQLCMD.EXE to execute this file from the batch file

Hey Gail! Was this possible in SQL 2000 also?

As the code is not posted, I am guessing you are doing something like:

INSERT INTO @yourTableVar Execute yourSP

Please note the following things about the table variables

- You can not use...

can you post the code?