using multiple in operators with and conditions

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

my following query is giving wrong results.how can i correct it.

SQL

select (partyname + ' ' + ',' + '  ' + Contact_person) as name, (mobile + ' '+','+'  '+Email + ' '+','+'  ' + phone) as contactdetails,Address,(City + ' '+','+'  '+ Area) as city_area, Status,CallType,Visit_time,visit_purpose,Interaction,Already_Computer,Software,area
  FROM [CallRegister].[dbo].[MarketingCall] where Status in('')or City in('') or Area in('') or  Software in('') or CallType in('')

I want every in condition to be satisfied if it has some values and filter the rows according to itLike if "status" and "city" has some values it should filter only on this criteria.Should i use and operator.

help me..

Posted 18-Dec-13 18:56pm

pwavell

Updated 18-Dec-13 18:59pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-18T21:37:00

Try this:

SQL

SELECT (partyname + ' ' + ',' + '  ' + Contact_person) as [Contact name], (mobile + ' '+','+'  '+Email + ' '+','+'  ' + phone) as [Contact details], Address, (City + ' ' + ', ' + '  '+ Area) as [city area], Status, CallType, Visit_time, visit_purpose, Interaction, Already_Computer, Software, area
FROM [CallRegister].[dbo].[MarketingCall]
WHERE [Status] = @status AND City = @city

For further information about building search criteria, please see: WHERE (T-SQL)[^]

Alternatively, yoou can build dynamic queries[^].

By the Way: rather than using + operator[^] i would suggest to use CONCAT[^] function.

SQL

SELECT CONCAT(partyname, ',  ', Contact_person) as [Contact name]...

using multiple in operators with and conditions

1 solution

Solution 1

Add your solution here

Preview 0

using multiple in operators with and conditions

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us