wutang (4/30/2012)

---

TY Tyson!!!!!!

I will try this code. I appreciate you taking time to write code and share it with me.

Sean please stop replying to my threads

You are not helpful...

k.subramanyam1017 (4/30/2012)

---

for example i install the enterprise editions of sql server2005 and 2008

if u dont mind the pls tell me atleast two difference of installation enterprise editions of...

Just google for "sql server 2012 new features". You will find a whole laundry list of changes.

Please read the first link in my signature about best practices for posting questions. We need ddl, sample data and desired output. In this case we probably also need ddl...

If you have no DTS packages you want/need to migrate then don't worry about it. The packages you don't want/need will not be created. If that is your only warning...

Again if you want detailed help you need to provide ddl, sample data and desired output. This is pretty straight forward code but without something to work we are shooting...

Actually this is not a good approach as far as performance is concerned. The set based solution suggested in the original thread...

OK that is what I thought. This shouldn't be a big deal. I would stay but I have to go pick up the kiddos.

I hate it most when I lose the arguments. :Wow:

OK so you want the most recent TO_PAY_RATE? I think we can do this.

The only thing I changed from your original was to remove the extra temp table. No need...

That can be complicated for sure. I have been in that situation and the way I handled it was to make the process a little more formal. After meetings I...

ColdCoffee (4/27/2012)

---

Sean Lange (4/27/2012)

---

Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment. Perhaps the guilt...

OK I realized your first select was filling your temp table and then you selected from it. Still not 100% what you want for output but here is a shot.

I...

SQLRNNR (4/27/2012)

---

Sean Lange (4/27/2012)

---

I particularly liked his last comment.

I know exactly where the problem is...that big blob right between...

Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment. Perhaps the guilt of that is...