I must say this post brings back memories. I got my start doing water/waste-water utility billing data conversions into an Access system. The company got a bid from...

Great question. I have needed to use this technique when producing door tags for temporary water shutdowns. Each Service that we have has a Unit Count. Most...

Thanks for that example. Truth is hard, and it gets even harder when we want to communicate the truth. There is so much room for interpretation. I...

All this date math is fun but wouldn't it be easier to update the valid bit for all

records that have the same policyID and a Start Date that is...

"Put your trust in systems, not in genius I can't do that. But I can work within a system, when I know that the system will change when...

Lets see if I can talk like one of karens developers. As I developer I think of objects with properties and methods. So If I want to buy...

I found the article sound. His use of the term bridge table might not be my choice but he gave us his definition of the term, and adaquately described...

Well said. We have a very small IT dept (3 people) and our primary role here to serve the others (about 50) in our orginization and make their work more...

Maybe I have thick skin or maybe I am just thick. Comments like "You shouldn't have done that." I take at face value and move on. It...

Hey trucks have locks just like the family car. Security and stability are of primary concern on all our servers. But, going back to the truck analogy, I...

It is a great Idea! When a automobile company designs a car, or developers design an application. They focus on the capabilities they want to include. Then...

We must be looking at two different function here is the link again. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56499 If we are I apoligize. I hate to see some ones code called a...

You don't have to manually inspect each name pass in a flag to get the function to run.

Given a table of full names in my earlier post.

[Code]

SELECT...

I am not insulted. I think you that haven't evaluated the function correctly. The function returns the name you supply in the format that you ask for. ...

Sorry you feel the coded is useless. I was thinking of using format Name function from SqlTeams posting something like the code below, . or perhaps altering the...