December 6, 2011 at 3:53 am
Below is the query in my store procedure..
SELECT distinct a.[CollegeId],a.[CollegeName], a.PaidClientPage,b.[CourseTypeId],b.[DegreeId],[CollegeDescription],[TypeofCollege],[Grade],a.[TrustId],[TrustName],a.[UniversityId],[UniversityName],a.[ApprovedId],[ApprovedName],a.[AccredationId],[AccredationName],[Status],[YearofEst],[CollegeAccType],[AddressStreet],[AddressPin],a.[CityId],[CityName],a.[CityGroupId],[CityGroupName],a.[StateId],[StateName],a.[CountryId],[CountryName]
from collegemaster a inner join
college_degreestreamtransition b on a.collegeid = b.collegeid inner join College_UniversityMaster c on a.universityid=c.universityid inner join College_AccredationMaster d on a.AccredationId=d.AccredationId inner join College_ApprovedMaster e on a.approvedid=e.approvedid inner join College_TrustMaster f on a.trustid=f.trustid inner join College_CityMaster g on a.cityid=g.cityid inner join College_Citygroupmaster h on a.citygroupid=h.citygroupid inner join College_StateMaster i on a.stateid= i.stateid inner join college_countrymaster j on a.countryid=j.countryid
where b.coursetypeid=@CourseId and b.degreeid=@DegreeId
and b.streamgroupid LIKE '''%,'+@streamid+',%'''
and b.streamgroupid LIKE +@streamid+',%'+''
and b.streamgroupid LIKE ''+'%,''%'+@streamid+''
and b.streamgroupid LIKE +@streamid+'%'
end
Thanks & Regards,
Pallavi
December 6, 2011 at 4:17 am
direct responces to this link http://www.sqlservercentral.com/Forums/Topic1216888-146-1.aspx
December 6, 2011 at 4:24 am
In Where Condition Remove the AND Operator and Try With ''OR'' U will get the Results...
I think This is Condition Error...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply