My bad, sorry I removed few comments and the update statement as well.

Below is the updated query:

DECLARE @emp_num VARCHAR(30)

DECLARE @begin_date DATETIME

DECLARE @end_date DATETIME

DECLARE @emp_num1 VARCHAR(30)

DECLARE @begin_date1 DATETIME

DECLARE @end_date1 DATETIME

DECLARE @outerEmp...

Lynn,

Actually I'm preparing for my interview and I came across some of the question on DB, I'm at C++ but not done much work on SQL-Server. I want to learn...

I'm facing the out of memory error on executing the cursor query.

Then I modified my query, I thought using two cursor may get rid of 'out of memory' but the...

Thanks for your expertise.

Its working now.

could you please give me an example of this?