I concur with Jeff.

[p]Some of that was just simplifying the problem for the post, and some was due to the legacy tables and code thrust upon us. This...

Thanks very much, Dwain. I really appreciate your help with this.

Jeff Moden (3/26/2015)

---

I have some questions, please.

1. What do you want to show on pay periods that are before the first entry for a given employee. For example,...

Luis Cazares (2/5/2015)

---

Do you always query by employee? I'll guess you have more employees than payperiods. Assuming that, your columns should be EmployeeId, PayPeriod, CompanyId. If the queries use more...

Alan.B (2/5/2015)

---

Dave-148053 (2/5/2015)

---

I am most often returning all the columns in the table.

As far as the primary key, that's part of my "what's a good strategy" question. Should I...

I am most often returning all the columns in the table.

As far as the primary key, that's part of my "what's a good strategy" question. Should I be using...

I think if you have a convention where you write synonym names a certain way, you will increase readability.

Thanks, PaulB and Dev. My goal is to increase readability and maintainability but without doing anything to slow down processing. I will rewrite this code using synonyms and...

This is why Obama uses a teleprompter. Or you could always scribble an outline on your palm...

jen-1118637 (1/6/2010)

---

First, a non-IT example: I worked at Wendy's for two years in high school. My favorite station was grill, but they consistently gave it to whatever guy was...

They are us. ...

I have to add my vote for appreciation. I have been at this current job just under three years, and I have five hand-written thank you notes lined up...

LinkedIn was mentioned. Is it worthwhile putting your professional info on LinkedIn? Or will I be setting myself up to receive emails from Nigerian bank managers or MLM...

Thanks, but I'm trying to narrow permissions down, not grant sa permissions to everyone who uses that linked server.

I applied SP1 on Monday, and was able to connect to AS. But it took probably a minute to connect, then was very, very slow according to my users....