I made it through using the case statement...

FallNotWitnessed = ISNULL(Sum(Case when TypeName ='Fall - Not Wit' then 1 end),0),

FallWitnessed = Isnull(Sum(Case when TypeName ='Fall - Witn' then 1 end),0),

Regards,

Hi,

Thanks for the tip.

I have removed 'Hours' from the GroupBY clause. But, no luck.

I am 100% sure that ActualDuration is a valid column.. It could be am doing some thing...

Hi Team,

I have started putting together the logic for the above requriement..

CASE

WHEN RecurrenceType =1 and Recurrenceinterval =2 and datediff(day,'07/01/2013', RecurrenceStart)/ 14 < 7 then 'Week1'

When RecurrenceType =1 and Recurrenceinterval...

Hi,

That option is ticked already..but, no luck...

Regards.

Ahh great..thanks for the tip..

here is the original requirement in the VB script...

Dim Recurrence As string

Select Case RecurrenceType

Case Is = 0

If Interval > 1 Then

...

Hi Team,

Thanks all for your replies. On the same topic, I did the following approach and it is throwing an error, if I include the statement which I have highlightes...

Hi,

You can try this

ColumnB = Right(colname, LEN(colname) - 4)

Regards.

Hi Adi,

Thanks for the prompt reply.

is this of any help?

create table sampletable

apptid int not null,

starttime datetime,

duration int,

ESO int,

LSO int,

insert into sampletable values (1,2013-01-12 09:45:00:0000, 10,15,15)

regards,

krishna.

Thanks for the reply.

Since I already have the data in the database.. do I need to declare those variables OR I can go directly to the date funtcions as you...

Hi Lutz,

Thanks for your reply.

What happens, if I want to make my select statement dynamic.

My actual request from client is to get all the incidents that are raised as a...

Hi Ron,

Thanks for your time. I found the solution.

Thanks.

Hi Ron,

Thanks for guiding me to make sure my posting are readable and understandable.

I need the o/p to be CustomerNo, Date, Detail ans the specs are as follws

Date Column:

A customer...

Thanks for your help..

Cheers,

Krishna.