Hi Ryan,

It works wonderfully.  Thanks for your patience and help!

Ryan,

"208,2294,2341,399" is OK.  208,399,2294,2341 is OK too.

In the database there is a code table:

ID      description

----------------------

208     Project208

399     Project399

2294    Project2294

2341    Project2341

What I will have to do next is take 208,2294,2341,399 or

208,399,2294,2341  and replace...

Ryan,

"208,2294,2341,399" is OK.  208,399,2294,2341 is OK too.

In the database there is a code table:

ID      description

----------------------

208     Project208

399     Project399

2294    Project2294

2341    Project2341

What I will have to do next is take 208,2294,2341,399 or

208,399,2294,2341  and replace...

Hi Ryan,

Thanks for proposing some solutions.  However my data comes in some rather ad-hoc format.

Samples below did not yield expected results. 

declare @t table (Col1 int, Col2 varchar(100))

insert @t

          select 917,...

Sushila,

1.  Col2 is of data type NTEXT so there can be any number of  values in it.

2.  Yes the values stored in Col2 are always type integer and separated by...

I will look into coding NOLOCK on all select to avoid impact on the updates.  Thanks for the tip, TDuffy.

Thank you, GilaMonster.

KH,

What will have to change when the table in step 1 is laid out as below:

Col 1 (type Int) :  UserID

Col 2-12(type ntext):  string of integers.

So a sample data will...

Thank you, KH for sharing your knowledge and script code.  That works like a charm.

You can try this SQL query:

select *  FROM OPENROWSET('ADSDSOObject',

 'adsdatasource;', 'SELECT  cn, mail, co, distinguishedName, displayName

 FROM ''xxxxxxxxxxxxxxxxxx'' where objectClass = ''User'' ')

Note that xxxxxxxxxxxxxxxx can be 

 GC://something.com or LDAP://something.com where something.com...

Thank you, Michelle.  That works fine.

Many thanks to both Fred and Charles.  Both suggestions work well.

It works like a charm.  Thank you, Farrell.

I like your approach.  It will probably help with performance.

I may have to ask more questions with implementing it but I think this implementation calls for my existing SP1-SP6 to return...

I am looking for anything that is "simple and clean".  My approach at this time is terrible.

Step 1:  create COUNTSP1-COUNTSP6.  What COUNTSP1 does is to

select count(*) from (exact same select...