Any inputs ?

Any Inputs ?

Sergiy,

You mean , we need to create an index on DOC_RECEIVED_DATE column.

right ?

Excellent article !:)

Actually you gave a variety of good & tasty food in a single box. If you write more articles like this , it would help very much for...

Andras,

Nice comments ! Thank you !

Andras,

Thanks a lot for your prompt reply ! So when we think performance we need to use your method, when we think maintanance we can use my method. Am i...

Andras,

Can you post both the query plan method ?

Andras,

Wonderful explanation ! It is really very nice !

My requireent is just to check out the input parameter values.

Andras,

How about my method ?

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

Declare @Str varchar(50),@Cnt int

select @Str = '1,C,C'

select @Cnt = count(*) from

(

select ascii(substring(@Str,1,1))

union

select ascii(substring(@Str,3,1))

union

select ascii(substring(@Str,5,1))

) a

if patindex('[01C],[01C],[01C]',@Str) =1

Begin

If @Cnt = 3

Begin

Print 'Success...'

End

else

Begin

Print 'Failure...'

End

End

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

Andras,

It is working perfectly. Thanks a lot !

A small modification in the requirement.

the same character should not repeat twice. if the same character repeat twice then we need to throw the failure error message.

say for example,

0,0,C ...

Andras,

Thanks for your idea.Your method is working fine.

More ideas are welcome !

Chris morris,

I do know he knows exactly what the output will be. I...

Chris,

My point is, just i wanted to confirm which query is performing good.