Give me the $10,000 and I'll tell you what you should do. Just kidding.:-)

If this is an annual benefit I would try looking long term at what you want...

Christian Graus (1/7/2014)

---

As far as I can see, the due day is either the starting day, or it's the next day, which is meant to be calculated, using that string...

Based...

If the values you are trying to match are set values like the example data you provided, then you should be able to come up with coding to match each...

Since 'File ID' is on all three tables you should be able to join using that, then just pull in the values from each table.

Select a.*, b.*, c.*

from table_1 a

...

Is there a place on this site where these type tips and tricks can/are posted? Under 'Scripts'? Or is there a place under the 'Forums'?...

dan.tan (1/3/2014)

---

I'm a developer who fell into the DBA role because we had no DBA. So for years I was 80% developer, 20% DBA, before I switched into full-time...

hakim.ali (12/31/2013)

---

SQLServerCentral, and the SQL community (PASS, SQL Saturday etc), have played a very important role in my career development as a data professional. Thank you...

majorbloodnock (12/19/2013)

---

Jim Youmans-439383 (12/19/2013)

---

At my last job, we had a use it or lose it policy. If you did not use your two weeks, then you lost it. ...

I've got the personality to be able to shut this place off as soon as I walk out the door, for the most part. I try and do this...

Thomas Abraham (12/16/2013)

---

below86 (12/13/2013)

---

I'd like to use my one time for that tonight....

I'd like to use my one time for that tonight. 😀

Great idea! It will really come in handy on...

Maybe some kind of electrical shock device, like a tazer, I could use on the plane when the person in front of me decides to lean their seat back into...

I thought about the Samsung watch/phone, but you have to have carry around the smart phone. At least that is what I understood. I just want the watch to...