Glad we could help.

I think thats just the process/session/request info, including the waiting lock summarized at the request level. But it doesn't have the detailed lock info, like entity_id.

Sorry, I can't think of a good way around it either.

Yes, but did you check for error messages in the Logtable? That was the point of my change.

You can't do anything to the 'sys' objects, unless you are 'sys' and you cannot make yourself 'sys'. The sys scripts contain some weird syntactic conventions to indicate things...

Like this:

SELECT

CRM_StatusCodes.TRANSACTION_ID

,CRM_StatusCodes.CREATED_AT

,CRM_StatusCodes.USER_STATUS, CRM_Serials.SERIAL

,CRM_PartsLabor.DESCRIPTION

,CRM_Orders.PRIORITY_DESCRIPTION

,CRM_Orders.PRIORITY

/*,CRM_StatusCodes.START_DATE*/

/*,CRM_StatusCodes.END_DATE*/

,CRM_CodeTexts.ABCDE_CODE_DESC

,CRM_Partners.DESCRIPTION AS [Function]

,CRM_Partners.ADDRESS

FROM

(

SELECT

CRM_StatusCodes.transaction_ID, count(*) TotalCount

FROM

CRM_StatusCodes

GROUP BY CRM_StatusCodes.transaction_ID

...

That looks like a perfectly good CSV to me. What's the problem?

What PaulB said: we need to see what you saw in the Activity Monitor wrt to the locks.

Yes, this is correct, for most case if a search condition wraps a function around a column, then SQL cannot use an index on that column to resolve that search-condition...

The problem is that in you ELSE clauses you are RETURN-ing before you get to your COMMIT. You will need to write the ELSE's like this:

ELSE

Begin

...

(puzzled) What do you mean by "a container"? I have never heard that term applied to something that costs money or in your context?

You're getting errors probably, but you are only logging the Command, not its output. Change the last few lines to this:

...

insert into logtable (query) select @query

insert into logtable (query)...

You know, it just occurred to me that the For Loop container should be able to handle this (duh).

Karthik:

There is a course in most graduate & undergraduate math & CompSci programs called "Numerical Analysis", have you taken it yet? I ask because it is really...

Not AFAIK. Installation is how you create an instance.