tnx you

and for all

for the help and the support

it working

Chirag (5/29/2008)

---

Hi.. What about this

declare @STR varchar(100)

select @STR = @STR +','+ + fld_index FROM table_index where table_index in (select distinct fld_index...

hi

any new

tnx

hi and tnx for the help

i am apprais your help

if you see in my tow stord prosege

i have the conditions there !

and it work 100%(but slow !!)

explain...

TNX for the help

11111 19/03/2008 3

11111 18/03/2008 2 --<< SHIFTS COUNT FORWARDS FROM HERE

11111 17/03/2008 1 --<<BASE DATE MUST HAVE SHIFT = 1 FOR THIS EMPLOYEE

11111 16/03/2008 8 --<<SHIFTS COUNT...

Jeff Moden (1/26/2008)

---

So, why do you have to count down from the middle of the month and count up from that same date to the end. And, why does...

Jeff Moden (1/24/2008)

---

WHY? Why...

ok

see my code for backward insert

my code start from last day and insert the list of shift backward

my code all the time start with the same shift

whan i try...

i am appraiser all the help for all the wonderful, people

but i think this is sum bug

i don't know what is the problem

the list work backward the date work backward...

hi i work on it

but thre is BUG

if you run this code i you see it not work ok

after shift 1 must be 8 (8,7,6,5,4,3,2,1)

SELECT 111111,1,CONVERT(DATETIME, '02/03/2008', 103), CONVERT(DATETIME,...

please see this

after i change the "on #empshifts(empid,shiftdate DESC)"

i get this

1111112008-02-24Sunday 1

1111112008-02-23 Saturday2

1111112008-02-22 Friday 3

1111112008-02-21 Thursday4

1111112008-02-20...

see

i do this and still

create unique clustered index uc_empshifts on #empshifts(empid,shiftdate DESC)

the list don't go backward

hi and welcome! my best teacher

everything work wonderful

and the day go backward

BUT the list not

in my old code i fix it and i do like this example and...

ALZDBA (1/22/2008)

---

can I have a go ?

Since I try to avoid hints ...

how about ....

.....

I know it needs the extra run, you might consider just to

insert the initial StartingShiftType...

can you help please

on the shift order

tnx