InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:57:50 GMT20http://www.sqlservercentral.com/Forums/Topic988702-1633-1.aspxstored procedures is an alternative...but i am concerned why query is doing this on its own..even when i write is corretly and save...its saving its own way.Tue, 21 Sep 2010 00:30:08 GMTmasqazihttp://www.sqlservercentral.com/Forums/Topic988702-1633-1.aspxWhat about making it into a stored procedure and then making the call to that? That would absolutely fix the issue.Mon, 20 Sep 2010 09:09:00 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic988702-1633-1.aspxi have a query select name, name2, type, date, status from table1where (name = '' or name <>name2) and status =0but, ssrs is converting this query automatically to select name, name2, type, date, status from table1where name = '' and status =0 or name <>name2 and status =0this is giving wrong results... the reason is brackets are missing in operands..the correct way could beselect name, name2, type, date, status from table1where (name = '' and status =0 ) or (name <>name2 and status =0)how to solve this ??Sat, 18 Sep 2010 02:15:55 GMTmasqazi