Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Ultradiv

    Extrapolating Scheduled Events

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

    Extrapolating Scheduled Events

    /*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...
  3. Ultradiv

    Extrapolating Scheduled Events

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

    Results from four tables even when one is empty

    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 =...
  5. Ultradiv

    Results from four tables even when one is empty

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

    Results from four tables even when one is empty

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

    Join with goup by

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

    Using a group by and a join

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

    Using a group by and a join

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

    Join with goup by

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

    Need group by, but random

    wow! thats a good one! cheers Andy
  12. Ultradiv

    Need group by, but random

    NOt quite within each group they are random
  13. Ultradiv

    Need group by, but random

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

    Need group by, but random

    yeah its more complicated than that Andy
  15. Ultradiv

    Remember this trigger?

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

    Need group by, but random

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

Part and Inventory Search

Back
Top