Hi phil,

Thanks for helping all these while. With all the help from amazing users of this forum, finally i am wrapping up my first project in my new dept. Now...

Hi phil,

I heed ur advice and did a debug. It was strange it doesnt return me any data. Hence i read through my script and realize it may be...

HI phil,

thanks for helping once again. I will trying what u suggest later, currently out of office. But i guess the problem is most likely to do with getting the...

anyone?

Hi michael,

i nv exp this before and i couldnt help. sry. I writing becuz i am interested in how ur report works. I am trying to derive something like yours,...

Hi Lynn,

Thanks for all the effort, modification was great. U mention Execute SQL task? I tried that 3 days ago but failed. Maybe thats becuz my statements are messy....

Hi Lynn,

Yup i tried, it doesn't. Thanks for all the help over here, i have successfully created all the statements needed for my requirement and my target table is derived....

Hi Lynn,

Firstly, i am sorry, Lynn.

Secondly, i am using SQL Server 2005

Lastly, that sentence is the entire error sentence. It appears when i click the ! functions in query builder.

Regards,

10e5x

Hi lyn,

I tested your solutions and it works. However they keep prompt me "the OVER SQL constructs or statements is not supported". I just ignored that. Do u have...

Hi Lyn,

Thanks for ur reply i will test that soon. Currently i just do not know how to implement my 8 SQL statements in SSIS. TROUBLED:( Just by using this...

nigelrivett (12/12/2012)

---

Could probably be simpler but this separates out the steps.

declare @t table (s varchar(10), dt datetime)

insert @t select 'A', '20120101'

insert @t select 'A', '20120102'

insert @t select 'A', '20120102 01:00'

insert...

Hi Cadavre,

Thank you v much for ur help. Btw may i tried and your method returned my all 1 as numberofdays.

Oh yes u are right, i should have uploaded a...

Thanks Ray for the information. Maybe i am too use to asp.net, thinking every report should have all these. Btw what about search functions? Read the thread too.

Btw in any...

thanks, i will try those codes when i get b to office. Any simpler suggestion anyone as this is quite complicated.

Hi,

Thanks for replying. We should ignore whether it is weekend or pub holidays. Just derive consecutive from the entry date. For example: staff a enters on a fri sat sun...