hi

i think the problem is in this line

for the shift order

............................else 1 end)%8+1

i am only think i know

and you know what to do 😀

TNX

hi an thnks for all

but i have strange behavior on the backward code the shift don'T GO backward (the shift)

please RUN THIS CODE

the order for backward IS "8" AFTER...

is this code for my pivot table can Unpivot

tnx for eny help

DECLARE @Employee TABLE (ID INT, Date SMALLDATETIME, ShiftID TINYINT)

DECLARE @WantedDate SMALLDATETIME, -- Should be a parameter for SP

@BaseDate SMALLDATETIME,

@NumDays...

i UNDERSTAND the code

and vry appraise what you did for me and for the help

i only shar me idea with you !

and only ask your opinion

i can do it...

Matt Miller hi

i want to do something smart

for evry employee want to use only one date!!!

because of i do it evry month for the next month

in...

please one more question

now i use tow stored procedurelike

1 ) from 17/03/2008 to 31/03/2008(end month)

2) from 16/03/2008 to 01/03/2008(start month)

because i must to start from middle of the month

evry employee...

men this fast like rocket !!!

you are cannon !!

TNX

1) question - what to do if now i need to use it forward and also the shift list go forward...

hi and TNX

but i get an error

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

Msg 102, Level 15, State 1, Line 73

Incorrect syntax near '8'.

Msg 319, Level 15, State 1, Line 78

Incorrect syntax near the keyword 'with'....

Matt Miller (1/16/2008)

---

I'm not sure what you mean by okay. You're the one who determines what "okay" is.

If it returns what you want it to return, then...

can you see this i do it is ok like this ???

DECLARE @tbDate table (id int identity, dt datetime)

--While (@effectivedate > '01/03/2007')

--begin

--Insert into @tbDate (dt)

--values ( @effectivedate )

--set...

Matt Miller

i love you men :D:D:D:D

it working

you are genius !!

tnx

any recommendation for this code ?

i am look for solution over a month !!!

you make my day 😀

Matt Miller (1/16/2008)

---

skip the d*** loops. Use a numbers table to do this:

INSERT INTO @empShifts ([empID],[ShiftDate],[ShiftType],[StartDate] ,[EndDate])

select @input_empID ,

@current,

...

tnx for the help

how can i use al, the help and put it in this part of code

while

@@Fetch_Status = 0

begin

-- loop to insert info of emp shifts

while

@current<=@EndDate ----------------generate date...

midan1 (1/13/2008)

---

hi need help

how to calculate column

empid name date ...

hi i am sorry

Code Block this is the code for View v_un

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

SELECT empid, shift

FROM dbo.v_51

UNION ALL

SELECT ...