Hi Phil, yes you're correct of course. We could just have a separate DB on the same server.

Using synonyms is an interesting idea. I'll have to think more about that.

Thanks...

Hi Phil, thanks for the input!

The idea you mention did cross my mind; but yes, I have dismissed it for now as doing such would be a major project. Not...

Andy,

Thinking through this, I can see it working. But I thought of another question. As I understand, you can't dynamically enable/disable/hide/unhide params in the param block, correct? If this is...

Andy,

I'll try it out today. Sincerely, thank you very much!

Dennis

Andy,

Thanks again. I think I'm getting somewhere. I have it working off two datasets, from 2 queries that take the date range picker variable, one for the start date and...

Andy,

Thanks a lot. That makes sense. What about keeping the date parameter fields available for manually entering the dates as well? Basically having the option to put a predefined range...

Also realized I accidentally went to the wrong forum, meant to post in development.

What we decided to try is make and run procs that update the existing seed data to trigger the push. However now the issue is that these update statements are...

Andy,

I did that, and it did the trick. Thanks again!

Hi Andy, thanks for the great stairway!

I'm having a problem with the condition in the Conditional Split. I copied it exactly as you have it:

(FirstName != LkUp_FirstName) || ((ISNULL(MiddleName) ?...