Database

Christian Graus wrote:

To do that, I seem to need to do group by, which then means I need to specify all my non grouped column names, is that right ?

SELECT [Year], SUM(amount) AS [TotalAmount]
FROM SomeTable
GROUP BY [Year]

Christian Graus wrote:

It's what I expected, I just felt that was a PITA

SELECT Galleries.Id, Galleries.Name, Galleries.Description, Photos.Id AS Expr1<br />
FROM Galleries INNER JOIN<br />
Photos ON Galleries.ThumbnailID = Photos.Id<br />
WHERE (Galleries.Visible = @Visible)

<br />
SELECT Galleries.Id, Galleries.Name, Galleries.Description, <br />
(SELECT TOP 1 Id, FROM Photos WHERE Galleries.Id = Photos.Gallery_Id) Id<br />
FROM Galleries<br />
WHERE (Galleries.Visible = @Visible)<br />

CREATE PROCEDURE usp_SearchItems
    @pName NVARCHAR(75),
    @pNSN NVARCHAR(16),
    @pTPart NVARCHAR(20),
    @pVPart NVARCHAR(50)
AS BEGIN
    DECLARE @pQuery NVARCHAR(1024)

    SET @pQuery = 'SELECT * FROM tblItems WHERE (fldInactive = 0)'
    IF (@pName<>'') BEGIN
        SET @pQuery = @pQuery + ' AND (fldItem LIKE ''%' + REPLACE(@pName, '''', '''''') + '%'')'
    END
    IF (@pNSN<>'') BEGIN
        SET @pQuery = @pQuery + ' AND (fldNSN LIKE ''%' + REPLACE(@pNSN, '''', '''''') + '%'')'
    END
    SET @pQuery = @pQuery + ' ORDER BY fldItem'

    --PRINT @pQuery
    EXEC(@pQuery)
END