Slightly off-topic:

Anybody interested in helping me out here?

I'm starting (already started?) to leave my comfort-zone and don't want to misguide the OP...

Please have a look at the CrossTab article referenced in my signature.

If the number of uniqueNum columns is unknown, you might want to have a look into the DynamicCrossTab article...

What type of guidance do you ask for?

The kind of "Follow that path over there until you reach a crossroad at the hill. Then take a left because if you'd...

The following code worked as bad as a [c u r s o r] is supposed to but at least it gave the expected result (had to change it to...

You need to assign to @Tablename instead of @x in your first fetch statement.

Also, just use "set @x ='select..."

instead of "set @x =@x+'select..."

You probably benefit from the time zone difference / foreigner issues...

If you want it to retry the step you have to define the status "failed".

That can either be done within your sproc uspMortgageData or you define an raiserror() statement as...

One more side effect of the "bouncing method": sometimes it's done row by row (get one row from the source table and insert it into the target table). That would...

Why do you need to run a cursor for what you're trying to do?

Wouldn't it be easier to do it set based? As a start something like

SELECT empid,

SUM(CASE...

Another subject you need to focus on is how you handle date formates both within your tables (e.g. stored as character... :pinch:), and within all queries/stored procedures.

If you provide any...

Please explain a little more detailed what you're trying to do. Especially in terms of the stored procedure.

It might be the case you're trying to do a row-based approach where...

It seems like you're trying to do an existence check and run the proc based on the result. If so, the following code should work.

Note: it checks if there is...

I'd say there is a mismatch between the table size you're using and the size you allow tempdb to grow to. You'd fill one of those tempdb files completely if...

Step 1:

use a split string fuction to separate your comm separated list (for a sample function please see the tally table link in my signature).

Step 2:

Either use PIVOT or a...

Did you try to google for a solution?

I just tried "sql server sms" as key words and found several solutions.

One is

http://www.siccolo.com/Articles/SQLScripts/how-to-create-trigger-to-sms-email.html

But there are a lot more....