I am having some issues with syntax for the following MS SQL Query
SELECT iif((count(type) > 0)'Y','N')
FROM dbo.tbl_NoneImpairedLoop where wirecenter = 'LSANCA03'
group by wirecenter
I basically want to return a Y if there is more then 1 record and N if there is no record found.
Also in my world there can be either 0, 1 and 2 records. The difference of the records is in the field type
which can have wither a value of DS1 or DS3. Is there a single query which can return a Y or N for
a record based on value in type field
Ideally I would like to get basically something like
DS1 | DS3
Y | N
I know this might be to much to ask but hopefully someone has an idea..