John: You're right about the variable not substituting. The literal "*_GOL_*" returns the correct list.

Any ideas how to make this work?

$Code = "GOL"

This returns all the groups having "GOL" in their names:

Get-QADGroup "*$Code*"

This returns all the groups having _GOL_ in their names:

Get-QADGroup "*`_$Code`_*"

Both of these return nothing:

Get-ADGroup -Filter {Name -like...

Matt: Yes, that can be handled in my design. Although as I mentioned, I'm going to have to do some serious testing in order to determine if this is even...

You're now technical talking about *bi-temporal support*, not just temporal. As in - in order to provide the correct history in your OLTP, you will need to keep track of...

That's what I'm getting at: there won't be a separate warehouse anymore. Although historical reporting will not be done against the live database.

And yes, the application will be managing the...

Our product *is* the information in our database: if some of that content does in fact change 10 times in 10 minutes -- an unlikely scenario, but theoretically possible --,...

Where is gets complicated: our DB is effectively both OLTP and DSS/warehouse. For many years, we've been able to segregate the roles on separate servers, by refreshing the DSS server...

Hmmm. I see I've used the wrong term: I guess that should be "Temporal Database".

Although to be honest, I can't really see how they differ... tables have valid-from and valid-to...

Hi Shawn,

Thanks for the response.

1) Yep, as long as I know the password, life is fairly simple. But I don't. Which brings me to...

2) Execute As or SetUser would...

I like that, a little easier on the eyes.

Something like this?

http://mspowershell.blogspot.ca/2013/01/executing-tasks-in-parallel-in.html

Using my credentials (I'm a member of local admin on domain_1 SQL servers, and member of sysadmin on the SQL Servers. I'm an average user on domain_2.)

Msg 15404, Level 16,...

Hmmm....I wonder if we changed the SQL Server account to one from the other domain?

D'oh! Too easy.

Thanks Gazareth!

This should find you the rows in the result set that have the same jobno:

;with temp as (SELECT r.jobno

, r.proref

, p.proadd1

, p.propstcde

, pr.decode

, re.code

, wo.wfeedname

, m.mnodename

, wn.payval

, s.statedate

FROM repository r

INNER...