Just be aware that when the procedures compile, SQL Server will resolve the SELECT * into column names.  This means that if you change the underlying view (not saying that...

One way would be to calculate the difference between the two datetime values in seconds and mutliply this by an random number and add the result to the first datetime...

Is there any reason why you do not have any join conditions between Indicator and emp tables?  As it stands, it will produce a cartesean product (cross join) between the...

A couple of ideas:

1.  Use a function pass parameters of policy_urn and row number.  Then set the rowcount to the row number and return that row: eg (not tested but...