John Hanson,

Thanks for the DTS/ActiveX suggestion.  That's not an entirely implausible suggestion...  But let me round out the situation, and maybe others can let me know if I could make...

Razvan Socol,

Thanks -- I tried that too.  It does get me past the first hump, but then slams me into the next.  The first hump is the scope of the...

hanslindgren,

Thanks, yes, I remembered that there was such a stored procedure...thanks for reminding me of its name.  It might prove useful sometimes.  We generally need to run our scripts on...

Rockmoose,

Thanks for the suggestion.  I considered that too, and it has some attraction.  But a globally-visible temp table brings up the same issues as a plain old table that's saved...

Thanks stacenic,

I thought of that, too, but it doesn't solve my problem.  I don't want to INSERT new rows into the table, I want to change existing values. 

Turning SET...

One important clarification occurs to me to make...

We don't ever want to replicate all the data from one db to another, just the selected personnel records and the supporting FK'd...

Thanks!

After fiddling with it, I did have to make a minor change in your example code, but you gave me exactly what I was asking for.  Much appreciated. 

I'll put...

David,

Wow.  Thank you!  That was very generous of you, especially considering I didn't provide table-defs.  You put a lot of work and thought into that, and I am already making...

With regard to the start and end dates of the month, don't forget that a query like this...

SELECT * FROM Members

WHERE effective_dt >='02/01/2004' AND

termination_dt <='02/28/2004'

...will leave out all the members...

Brian,

All of these MSSQL installations/instances were registered through EM at one time -- but the two puzzling ones were long ago unregistered and their underlying data files deleted.

- Tom

Okay, half of the problem is solved. 

Why isn't Instance B showing up in Query Analyzer?

Because my crappy old firewall software decided today that it was evil and needs to...

quote:

---

A bit late but if you want a solution without CASE then

AND (@id = 0 or @id...

quote:

---

Thanks tkc, but this returns only records with Not NULL csid records and moreover

if GMCSids = '5,6,7' ( some csids )...

Someone just helped me answer a question similar to this (I presume). If I'm correctly translating the technique someone showed me, then you can do this...