Database

Mohammad Daba`an wrote:

May you explain me the flag you wrote? or what do u mean by a flag?

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Rule]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Rule]
GO

CREATE TABLE [dbo].[Rule] (
	[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
	[Name] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
	[Solution] [int] NULL ,
        [Deleted] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO

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 />