hi and tnx for all for the great help i get here

-----------------------------------------

1)i dont see the shift value (1 , 2 ,3, 4, 5) in the square day

2)how to generate report...

hi and tnx for all for the great help i get here

-----------------------------------------

1)i dont see the shift value (1 , 2 ,3, 4, 5) in the square day

2)how to generate report...

perhaps someone

show me how

TNX for all

:D:DWOW WOW WOW :hehe:

it work i love you men

---------------

please

but there is a problem for me i need the unit also

id ...

ok

how to add this to this StoredProcedure

add another field "UNIT

so the table be like this

|empID|...

can you please to generate the code to build the tables

1 ) emp_shift

i get error

----------

Msg 155, Level 15, State 1, Line 19

'mon' is not a recognized dateadd...

hi am stuck in

someone can fix this for me

------------------------------------------------------------------

this is my problem and i need to add this (add pattern)=UNIT

add another pattern 1 , 2 , 3 ,...

i am sorry

you right

ilan

HI TNX

CAN YOU SEE WHAT I mean

1) loop and insert 3 employees one after one to shift_table

2) evry time i generate the Stored Procedure i need only the next...

HI TNX

any idea how to insert to table with the employee and the val shift

maybe make 12 tables for each month in the year ???

TNX

shift

1=morning

2=evening

3=night

4=rest

5=home

what i mean is that

i need to to generate the next month that depending whre the last month end !

and i must check whre this employee ID (in...

a link to the picture pattern

http://www.turboimagehost.com/p/29550/1.jpg.html

TNX

what i need is

only to generate from sql mail the file "ICS" and to send it as email attachment

can i get any help to do this

TNX

no answer ????