select emp_name, emp_dob from employee

emp_dob is listed for example '1974-01-03 00:00:00' OR '1974-01-03'

So, I would need something like my first post, where it would break all emp_names into the respective...

How would I get the month breakdown

remember emp_dob column is in SMALLDATETIEM Declaration.

Here is the XML Of each employee shift schedule

<e emp_id="1" start_sked="2011-03-27T00:00:00" end_sked="2011-04-23T00:00:00">

<w wk="1">

<s work_date="03/27" date="2011-03-27T00:00:00">

<shift work_date="1" />

...

Also How would I create a time table with all the values you have given me in your query.

with emp_schedule as (

Select shift_start_time = '2011-04-01 07:00:00'

...

In the first select statement, I need to split calender into 28 days. with wk 1,2,3,4 and days from 1-7 or 0-6.

How do I make sure that the work_date is...

One of the guys told me I need to create a table with

emp_id,

emp_name,

job_description,

shift_id,

shift_start_time,

shift_end_time

but I have to parse the data into this format with w wk and day, can you...

This is how the result should be

<e emp_id="518" emp_name="Avila, Bobbie" start_sched="2011-04-17T00:00:00" end_sched="2011-05-14T00:00:00">

<w wk="1">

<s work_date="04/17" date="2011-04-17T00:00:00">

<shift job_code="38" job_department_id="31"...

emp_id = 1

work_date = 2011-04-01

shift_start_time = "2011-04-01 07:00:00"

shift_end_time = "2011-04-01 15:00:00"

The table includes the dates he is scheduled to work on for the next 4 weeks from 2011-04-01

So all...

Alter procedure [dbo].[WEB_HR_SLXSCREENTEMPLATES3](

@sourcedb VARCHAR(50),

@targetdb VARCHAR(50),

@sourcegroup VARCHAR(50),

@targetgroup VARCHAR(50),

@sourcedb1 VARCHAR(50),

@targetdb1 VARCHAR(50),

@sourcegroup1 VARCHAR(50),

@targetgroup1 VARCHAR(50),

@sourcedb2 VARCHAR(50),

@targetdb2 VARCHAR(50),

@sourcegroup2 VARCHAR(50),

@targetgroup2 VARCHAR(50),

@sourcedb3 VARCHAR(50),

@targetdb3 VARCHAR(50),

@sourcegroup3 VARCHAR(50),

@targetgroup3 VARCHAR(50)

)

AS

BEGIN

declare @sql varchar(max)

declare @sql1 varchar(max)

declare @sql2 varchar(max)

declare @sql3 varchar(max)

set

so how should the code look with the execute statement, I apologize for so many questions

4 input parameters

source database: version500_prod

target database: version5_sales

source table: version500_prod..slxhrscreentemplates

target table: version5_sales..slxhrscreentemplates

plus the output should

be @sql

so execute @sq correct?

alter procedure [dbo].[WEB_HR_SLXSCREENTEMPLATES](

@version500_prod varchar(50),

@version5_sales varchar(50),

@template_group_1 varchar(50)

@template_group_2 varchar(50)

)

AS

BEGIN

DECLARE @sql varchar(max);

set @sql = 'insert ' + @version5_sales + ' select * from ' + @version500_prod + ' where...

It is not working yet, the table in version5_sales is only updated at Admin, not the other 3 values.

Yes, give me in dynamic sql and I need an execute statement, but make sure all 4 template_group values are replaced