Pretty vague specs from which to write an application. What else can you tell us? Specifics would be really appreciated.

Try this:

select

A.EmployeeID,

A.Name,

sum(B.reg_hrs + B.ot_hrs + B.sick_hrs + B.vac_hrs + B.hol_hrs) TotalHrs

from

employee A

...

I'm pretty sure your requirements are more specific than what you have provided in your original post. If you could be more specific, provide DDL for your table(s), sample...

Sergiy,

Double check for me, but I think the code in the original post is missing a group by. I didn't catch that as I reformatted the code. That...

WayneS (6/10/2009)

---

Lynn Pettis (6/10/2009)

---

WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along...

This is whate of Sergiy's suggestions would look like:

select

ma.memid,

ma.attributeid,

ma.thevalue,

ma.effdate,

ma.termdate,

...

FYI, It is always a good idea to test any code you provide in a sandbox database to ensure it works correctly. We are volunteers on this site, and...

Still waiting. We are here to help, but we need your assistance to do that.

WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes of...

Lynn Pettis (6/10/2009)

---

jcrawf02 (6/10/2009)

---

Lynn Pettis (6/10/2009)

---

Okay, venting...

We have our White House Window Washer, our PhD Candidate, our True-Relational Zealot. Do we call this one, The One Who Can't, or...

True, Barry, the code I provided was very basic for generating dynamic sql.

Thank you for pointing out the need to do more regarding sql injection.

Please do not cross post. It simply fragments any responses you may recieve.

Please post replies here.

Here is how I would code it.

Tried posting directly, but couldn't so it is posted as an attachment.

You are missing the point. You can't pass in the table name as a parameter to the dynamic sql in the sp_executesql. You can pass in variables where...

May be the only way to clean up the files, sorry.

I use either SSMS or UltraEdit when writing my SQL code, so I don't run into this problem.