Function F_AGE_IN_YEARS in the script on the link below calculates age in years from @START_DATE through @END_DATE and returns the age as an integer.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74462

Shrink DB File by Increment to Target Free Space

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355

"previous employers" I hope you...

Gary Varga (3/8/2010)

---

jay holovacs (3/8/2010)

---

Gary Varga (3/8/2010)

---

From a truly serious viewpoint (sorry to spoil the party - hic), I believe that IT practitioners should be regulated like the legal and...

Roy Ernest (3/1/2010)

---

USA has a world cup winning team? I did not expect that for the next 5 yrs because they are so new to the world cup.

I...

Oh, no! His GOOGLE search bot is sure to find this thread now!

george.greiner (3/1/2010)

---

As with most Access it is a hybrid of Access SQL and VB... You write the queries...

That is not Access SQL, that is Access Visual Basic.

Using identity columns as a PK key and putting unique constraints on the candidate keys is the way to go. In many cases, there is no way to know...

Tom.Thomson (2/28/2010)

---

...The next Monday I walked into the office where the people who owned the affected code were and said something like "Listen up guys, I've fucked up and we...

Kingston Dhasian (2/26/2010)

---

Paul White (2/26/2010)

--------------------------------------------------------------------------------

If you have a pain in your finger, chopping your hand off is not the solution.

In fairness, it is *a* solution, just probably not optimal...

Welsh Corgi (2/26/2010)

---

So there are no DBA's that recognize that there are risk to Dynamic SQL?

If I'm wrong then I respectfully respect that you forgive me for...

Michael Valentine Jones (2/25/2010)

---

In a public forum like SSC, I think it is more important to correct errors in the thread directly than to worry about someone’s feelings. The...

Welsh Corgi (2/26/2010)

---

Thank you Jeff. I read your link concerning the SQL Injections.

However there is a lot more to consider that what is addressed in this article.

You are...

Dynamic SQL is a very good tool for situations where you have stored procedure input parameters that may or may not be used for selection criteria. By constructing the...