below86 (3/10/2015)

---

I quess erything I deal with is batch...

I agree with the others.

-Format the query so that it is easy to parse sections and keep track.

-Use intuitive alias names so you can easily trace back...

TomThomson (3/7/2015)

---

This is a rather early repeat! We had an identical question on Jan 13th, less than 2 months ago; and then on Jan 20th we had another question...

What if you create a view on the remote server that queries the table with nolock and then join to that?

Can we start with a deeper examination of why you feel nolock is necessary?

TheSQLGuru (3/6/2015)

---

Your "real time" doesn't make any sense to me. Real time happens in SQL Server all the time. You INSERT data - it goes in in "real time"....

This would be far easier if instead of ACTIONS in a history table, what you maintained was EFFECTIVE AND EXPIRY dates for the record. Then you can see a...

No.

So if your query worked, what would the output from your sample look like?

It sounds like you want a query where each row has a different number of columns

Ok, the following assumes you have a calendar table . If you don't have one and are unfamiliar with how to make one, look here[/url]

I essentially created the Calendar table...

Ok, well I started to do a sample for you keeping things roughly the same as you had them (using date math to pick the next one), but if...

Phil Parkin (3/5/2015)

---

Nevyn, the idea of having multiple environments in the same SSISDB instance for Dev/QA/Prod etc makes me shudder.

There is too much risk of running a package with the...

Ron Kunce (3/5/2015)

---

Thank You much! I'm Sorry, I got environments and environment variables mixed up in my first post. I also specified "Data Model" where I meant "Data...

Ok,

1) You changed the test data

2) Can you explain why the last 5 rows should pick tuesday the 24th instead of Friday the 20th?

I made an empty sample package with a connection manager, and a sample catalog so I could give you some screenshots.

They are attached.

EnvironmentVariable shows setting up a variable called 'ServerName'...