Hi

I solved the problem mysef by reading below topic.

http://www.petefreitag.com/item/169.cfm

Thanks

Anitha

Thanks .

Sorry ,i thought 101 as Historic one.

Your query is perfect

Thanks a lot..

Anitha

No bteraberry .

I am getting still 101 ,i dont want see 101 as it is historic (Final Status).

The query which you supplied excluding only row ,not the metercode.

I am expecting...

Hi Jeff

The Reason is If reading type is final that meter will be historic one.

Thats why i dont want to see 101.

Thank you very much for your help

Thanks wayne,

I did not realize that you need create and insert statements.

i am very sorry.

I will add next time!!!!!!

Anitha

Thanks for quick response.

this code is very useful to me ..

Thanks friends,

It worked excellent..............

Once again thanks for your help...

Hi

I tried in different ways and got the solution finally.

Solution:

AND (

(@Expiry = 'In...

Hi

Thanks for your time.

I tried in below 2 ways.

AND ((@DTStart IS NULL )OR (lft.Expiry_Date BETWEEN @DTStart AND @DTEnd))

AND ((@DTStart IS NULL AND @DTEnd IS NULL )OR (lft.Expiry_Date BETWEEN @DTStart AND...

Thank you vey much for your time...

I will modify my code as you mentioned format.

Thanks Jeff.It works awesome.

Kind Regards,

Anitha

Hi Jeff

The SQL code what you provided worked well.

Unfotunately If notetext does not have searching strings ,its giving error.

Here is the example,Can I know how to solve this issue.

DECLARE @TestString...

Thanks for your time,i did as you expanined..it worked well........

Regards,

Anitha