Hi Piotr - thank you for your reply

I thought about that but not sure how to do it.

For instance I want to insert 3 fields into my main table after...

Hi Matt and Lynn,

This whole process in run inside a stored procedure, which is why I thought of trying a UDF for this Insert. I do need teh Scope_Identity...

Hi Lynn,

Thanks for your reply, but I'm not using the cursors anymore. Just a straight TSQL Insert Into x Select y

There must be a way to do what I'm...

Hi Jeffrey,

It is set for 'FULL' but when I asked the user about backing up the Transaction log - there was a sad, blank look. So, the transaction logs...

Hi Jeffrey - you're very right. The log file is 38Gb - who/how/what can I do to shrink/truncate this beast?

THANK YOU

Thank you for your time - here is more sample data

5665312Administratoramr\xx_xxxxxxxxx_xxxxxDDDDDDDDDNULLamr\sys_eamsqlACCOUNTNULLNULLNULLNULLNULLNULLNULL

5665412Administratoramr\ad_xxx xxxx xxx xxAAAAAA\MMMMMMMCreated and managed by AAAAAAamr\AD_XXX XXXX XXX XX_1AAAAAA\MMMMMMMCreated and managed by AAAAAAamr\ad_bsbsbsbACCOUNTCreated and managed by AAAAAANULLNULLNULL

5665512Administratoramr\ad_xxx xxxx...

Thanks Jack

Thank you Jeffrey - the middle solution fit right into my stored procedure and returns exactly what I needed. 🙂

Hi Jack - thank you for your answer - very close to what I need. I'm building a stored procedure to populate a control based on another control. ...

Exactly what I needed.

Blessings on you and yours,

Tom

Hi Jeff,

I was researching cross-tab like products and your postings come as one who knows how.

I need to produce a of Cases and comma-separated list of Jurisdictions, like this

Case ...