I apologize Sean,

but can you please give me an idea or code example how you would go about writing this stored procedure:

Note: Please include emp_name, emp_organization and emp_department from employee...

but I needed for all employees, not just the one field.

In the column(employee_other table) pictured above, there are a bunch of XML files, need to take those XML files and convert it into the 4 columns mentioned above.

Name:

WEB_HR_GetRateHistory

Parameters:

@org_level_id, @emp_id

If @emp_id is 0 – get me all rate change history for all active employees within this org_level

Tables:

select * from employee

select * from employee_other

Resultset:

Employee Name

Center

Department

--Date

From Pay Rate

To Pay...

I apologize, just nobody was responding to the old reply. OH yes, I do not need the time for the datetime field.

i know how to join the two tables, but need help with the XML column.

Name:

WEB_HR_GetRateHistory

This is the procedure I have to write and it has to include only date_changes, From Pay Rate, To Pay Rate and Changed By.

Note: The columns above are combined...

GilaMonster (2/20/2012)

---

XML generation and parsing is one area I would actually recommend C# if at all possible. Probably not appropriate...

GilaMonster (2/20/2012)

---

Then there is something seriously wrong with the XML generation code (which piece I can't tell), it's generated a piece of XML over 2GB in size. I think you...

SQLKnowItAll (2/20/2012)

---

njdevils39 (2/20/2012)

---

GilaMonster (2/20/2012)

---

You have this code towards the bottom

SELECT week_num, work_date, u.unit_description, s.shift_id, sh.shift_description

FROM #GET_ORG_SKED

WHERE work_date...

GilaMonster (2/20/2012)

---

You have this code towards the bottom

SELECT week_num, work_date, u.unit_description, s.shift_id, sh.shift_description

FROM #GET_ORG_SKED

WHERE work_date = d.dt

There...

Now how do I get this one to execute: Its same thing, but different code.

It works, but not executable:

Msg 4104, Level 16, State 1, Procedure WEB_SO_GetEmployeeOrgSchedule, Line 100

The multi-part identifier...

GilaMonster (2/20/2012)

---

Replace

AND

es.work_date between '@start_date' and '@end_date'

with

AND

es.work_date between @start_date and @end_date

By putting the quotes, you made those literal string values, not parameters and SQL was trying to convert the string '@start_date'...

Thank You ToddASD, now I have to study the fucntionality of everything inside the Stored Proc, but Thank you all very much.

How would I insert the names of the employees and their date of births from the employee table into the declared test table.

DECLARE @test-2 TABLE

...