I just tested it on 2008 R2 and it seemed to work.

szeitzp (8/4/2016)

---

1. The full_name column may not a practical one. It is brings more problem than profit, if you think about the possible sequences of the first_name and last_name it...

We have a similar structure as your original example. I could see where some slight improvements could help. We have a computed column for the full name.

Great training article, thank you.

Nice little tool.

I can't quite read that phone number...

I've always taken the position that when a staff member leaves, we never call him/her for help afterward.

Seems like I've seen these before but thanks for the reminder.

This sounds like a useful query. We've had some issues on our night jobs. Thank you.

We have started using finger print scanners at our work stations. I love it.

We just don't make data changes through a view.

I haven't been to a SQL Saturday. I would go if they had one in my local area.

Good article. We just try to avoid it altogether. We have some and are in the process of getting rid of it.

Thank you for this.

I'll see if this works for our backup database needs.