Thanx.. its working :-D

Thanks Richard Deeming. I try above query bur not succeed. Finally I do increase number of query lines and doing below…..

select * from Mytable where ((EffectiveDate <= @MyeffectiveDate and BillingTerminationDate is not null
and (BillingTerminationDate > =@MyeffectiveDate)) OR IsAdjustment=1)

select * from Mytable where ((EffectiveDate <= @MyeffectiveDate and BillingTerminationDate is null
and (TerminationDate > =@MyeffectiveDate)) OR IsAdjustment=1)

Right now its working as my expactation. But having doubt that after reviewing, may or may not it will give me pain.:confused:

Dear seniors, How I can use case statement in where clause….. Below query raised syntax error. @MyeffectiveDate Select * from Mytable where ((EffectiveDate <= @ MyeffectiveDate AND CASE WHEN BillingTerminationDate = NULL THEN (terminationDate is null or BillingTerminationDate > =@ MyeffectiveDate) ELSE BillingTerminationDate > =@ MyeffectiveDate) OR IsAdjustment=1) WHAT EXACLY I WANT If(BillingTerminationDate is null) then where clause should used ” (terminationDate is null or BillingTerminationDate > =@ MyeffectiveDate)” statement. Other wise used BillingTerminationDate > =@ MyeffectiveDate statement. Waiting for your need full reply. Thanks in advance.

Dear All, I'm using share point client object model to get documents form and upload documents to.Is there any way to get audit log data using client object model.? Or Is it any web service available to get aduit log data.? Please suggest me how i can access aduit log data from share point. i'm using share point2010. waiting for your favorable response. Thanks Digvijay any one can help me pls:confused:

modified on Tuesday, August 23, 2011 7:54 AM

Thnks all finally i got.

Dera Sir, Thanks for your quick response. I'm using SQL server 2008 and SQL server 2008R2

Dear sir Please explain me how i can get the reference of a primary key colun in a database. what exactly i want to do.... I have a table "[plan]" "PK column is PlanId" how many tables are using this column reference(foregin key reference) in mydatabase, i wana get these tables name. Waiting for your favorable reply. Regards Digvijay