hi,
I have to 2 select queries but only 1 works for what I need.
The simple query accepts a single parameter @City
In the table there is an "Approved" column of Boolean.
If a is set to False - then I do not want to return that row from the table
even if there is a city match
select 1 (that works - does not return no records if Approved is False)
SELECT ArtistId, FirstName, LastName, StageName, Address, City, PostCode, Website,
Telephone, Mobile, Bio, Approved, Email
FROM dbo.PlayMeArtist WHERE
Approved=1 AND
City =@City
Select 2 Still returns a row even if the Approved is FALSE
SELECT ArtistId, FirstName, LastName, StageName, Address ...
Go to the complete details ...