I have a query which can return anything between 0 and 5 results -
I.Image AS Image
from dbo.[Direct-Product-Image] I
where I.ProductID = 39 AND I.[Default-Image] = 'N'
But really what I want is for the query to do the following -
Return First Record as Image1, Second Record as Image2, Third as Image3 etc
in one row, so instead of have a recordset with 5 records, i have a recordset with 1 record and 5 columns...
Is this possible???