Question: I have a (SQL 2005) stored procedure that processes a giant table and groups old data from the past (up til one year ago). It has this main steps:

* copy old data grouped to a new table
* copy recent data as is to the new table
* rename table

Now I want to log every run and every step in logging tables. However I start a transaction in the beginning so that I can rollback the whole batch if something goes wrong. But that would also rollback my logging which isn't what I want.

How can I resolve this?

Answer: 
The `web_reg_save_param` function in LoadRunner is used for this. The following line will save the current page URL to the parameter (URL).

```
web_reg_save_param("URL", "LB/ic=Location: ", "RB=\r\n", "Search=Headers", LAST);

```

If you know what the ID is that your looking for, ie. <http://www.example.com/?id=298374293847> you can adjust the call accordingly.

```
web_reg_save_param("URL", "LB/ic=Location: http://www.example.com/?id=", "RB=\r\n", "Search=Headers", LAST);

```

Hope this helps.
This is going to sound belligerent, condescending and downright offensive. It is not to be meant as a reflection on you, but upon your management who has placed you in this position.

The topic of Correlation is one covered extensively in the class for LoadRunner web script development. It is the topic of a full 1/3 of the class and an additional appendix. All told some four different techniques for collecting dynamic data are covered, presented or documented as a part of the class materials. This capability, the handling of dynamic data, is a foundation tool skill.

Vardges, your management has placed you in a tough spot. Personally I would bolt for greener fields, for any management which is willing to do this to a line-of-business employee is also willing to toss that same person under the bus to salvage their own hide or a client relationship. Blaming you for something that management is unwilling to address is not a question of "if?" when training and mentoring does not occur, but only "when?" will the blame be placed on you.

James Pulley

Moderator: YahooGroups Advanced-LoadRunner, YahooGroups LoadRunner, SQAForums LoadRunner, LinkedIn LoadRunner, GoogleGroups lr-loadrunner