Search results for query: *

sorry cant see how to edit my post last table should be populated thus insert @output select 2,'1 sep 2008',500,530,0 union all select 1,'1 sep 2008',530,575,1 --overlap union all select 3,'1 sep 2008',545,560,1 --overlap union all select 4,'2 sep 2008',840,930,0 union all select...

/*Run this script to get two tables One is sample data the other is expected output. Earliest Start and Latest stop times are declared but not actually used here, they will be in the real thing of course */ declare @schedule table( cleanID int IDENTITY (1, 1) PRIMARY KEY, AccountID int NOT NULL...

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

Oh I've done it :-) this is how: SELECT Lists.ListName, b.campaignID, b.DateOpened, b.CountOpened, b.DateLastOpened AS DLO, a.SubscriberID, a.Name, a.Subscribed, a.Email, a.Format, a.ListID, a.NumClicks, a.MessageLastOpened, a.SubjectMLO FROM Subscribers a INNER JOIN Lists ON a.ListID =...

Thanks for that Denny, but I still can't get it to work. Even if I reduce it to two tables, the second (Tracked) may or may not have a row corresponding to the first (Subscribers) determined by the supplied MessageID and the first tables' SubscriberID So this does not do the trick: SELECT...

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

Hey guys thanks very much I now have it working! Donations on the way best regards Andy

Hey guys thanks very much I now have it working! Donations on the way best regards Andy

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(*)...

wow! thats a good one! cheers Andy

NOt quite within each group they are random

Cracking Toast Grommit... er Dennis!! Thanks a stack, I know where to come in the future Andy

yeah its more complicated than that Andy

William, looking at your existing code, are you simply using the event of an update on the table to trigger the highlighting of the next ondate? or Is the data that is updated the same data that is being manipulated by your trigger? If the answer is the first then you wont be needing the...

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