Search results for query: *

This is very complicated for my tired little brain! I hope you can help me. There is a calendar view (html) which can be viewed 7 days at a time always starting on a Monday. it could be any week. The events that display on that 7 day view (columns are days rows are every 15 minutes) are...

There are four tables, all contain info needed in the result Subscribers table --------------------- SubscriberID(PK) ListID(fK) Subscribers details List table ---------------------- LitsID(PK) List Details Message table ---------------------- MessageID(PK) ListID(fK) Message details...

Sorry but I posted this in the ANSI forum first without realising it. Hi folks using SQL Server 2000 I am having difficuly sussing out how to join while using a group by clause. table one is a variable (@t) constructed thus: declare @t table ([id] int IDENTITY(1,1) PRIMARY KEY...

Hi folks I am having difficuly sussing out how to join while using a group by clause. table one is a variable (@t) constructed thus: declare @t table ([id] int IDENTITY(1,1) PRIMARY KEY CLUSTERED, cid int) I do some manipulations on it then I select a results list thus: select Count(*)...

Hi Helpfuls I am having difficulty working out how to group the results of a select into groups but those groups need to be ordered randomly. So this is my query without grouping, SELECT dbo.Machines.MachName, dbo.Machines.class, dbo.Machines.MachineID, dbo.Companies.Name...