That's a way of doing just what I said......

Can you not accomplish this with an inner join, rather than the exists statement....maybe against a pre-aggregated table of subscription counts?

You should build your concatenated string prior to the statement, and use a single variable for it......it doesn't like concatenating the strings within the statement.

The way I do it is to alias the table and use the standard conventions.....ie...

Select A.Field1

, A.Field2

, A.Field3

, B.Field1

From Server.Database.dbo.TableName A

Inner Join Server.Database.dbo.TableName B

On A.Field1 = B.Field1

and so forth....

I...

SELECT 'ForKey',

 child_table   child_table,

       obj.name      constraint_name,

       child_column  child_column,

       child_pos     pos,

       parent_table  parent_table,

       parent_column parent_column

  FROM (

       SELECT tab1.name child_table,

              col1.name child_column,

              CASE col1.colid

                 WHEN ref.fkey1 THEN 1

                 WHEN ref.fkey2 THEN 2

                ...

Is sequence number actually a sequential number, such as an identity field, so that the results can be sorted that way?

Include Object scans for the event, and object id and index id for the columns......then query the reulting table of data.....standard group by and counts......

Declare

@Mon Money

Set

@Mon = 1345.00

Select

convert(varchar(30),

Try one of these:

RESOLUTION

The blocking and blocked by columns show the spids of the processes that are blocked by the process or are blocking the process. If you trace this chain to the...