如何只连接第一行(存储过程)

Hi i have following stored procedure which returns multiple photosnames. i want to return just first row. i tried TOP 1 but i'm sure i am making some syntax error. pls helpHi i have following stored procedure which retu