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 Rhinorhino 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: *

  • Users: Ultradiv
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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(*)...
  5. 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