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

    how do i setup a sql2k server to allow user to connect via Ent manager

    need to allow remote access. thanks
  2. jamiec1

    error problems

    i used like because i was passing in either open, closed or % from the asp page
  3. jamiec1

    error problems

    thanks bperry that has solved the problem .. I have been working with access too long and it has made my brain grow weak..
  4. jamiec1

    error problems

    it works with the query below but i will loose info if field over 8000 long SELECT [JobRecords].[JobID], [JobRecords].[DateTimeCreated], [ContractType].[ContractTypeName], [CustomerContracts].[CompanyName], [CustomerContracts].[UnitsRemaining], [CoveredSites].[SiteName]...
  5. jamiec1

    error problems

    nice one thats it problem is i need that field thanks for your help
  6. jamiec1

    error problems

    the error i keep getting is Server: Msg 306, Level 16, State 2, Line 1 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Not sure why it is throwing up error but a bit rusty on my sql code is SELECT [JobRecords].[JobID]...
  7. jamiec1

    wrong number of arguements

    hi steve that query returns the same results as b4 .. the cust id is a variable that i have to pass in via an asp page so it will change, and the recordset must return only job records for a specific customer. the problem is that i need to see all the categories in the recordset .. what is...
  8. jamiec1

    wrong number of arguements

    SELECT ProblemCategory.ProblemCategory, IIf(IsNull(Count(JobRecords.JobID)),0,Count(JobRecords.JobID) ) AS JobsInCat FROM CustomerContracts INNER JOIN (CoveredSites INNER JOIN (ProblemCategory right JOIN JobRecords ON ProblemCategory.ProbCatID = JobRecords.ProbCatID) ON CoveredSites.SiteID...
  9. jamiec1

    wrong number of arguements

    This was a different query though .. just trying a similar thing as the other one
  10. jamiec1

    wrong number of arguements

    sorry for the spread guys im new here .. will keep it together in future..
  11. jamiec1

    wrong number of arguements

    I am getting this error when i run the following code SELECT ProblemCategory.ProblemCategory, IIf(IsNull(Count(JobRecords.JobID),0, Count(JobRecords.JobID) )) AS JobsInCat FROM CustomerContracts INNER JOIN (CoveredSites INNER JOIN (ProblemCategory right JOIN JobRecords ON...
  12. jamiec1

    possibly an impossible problem

    table months contains 01/01/2002 01/02/2002 01/03/2002 etc QRY: SELECT format(JobRecords.DateTimeCreated, "yyyy/mm") AS Mnth, count(JobRecords.DateTimeCreated) AS Tot FROM ProblemCategory INNER JOIN (CustomerContracts INNER JOIN (CoveredSites INNER JOIN JobRecords ON...
  13. jamiec1

    month report to include zeros

    Thanks blom Thats got that working .. i split it into 2 querys QRY: SELECT format(JobRecords.DateTimeCreated, "yyyy/mm") AS Mnth, count(JobRecords.DateTimeCreated) AS Tot FROM ProblemCategory INNER JOIN (CustomerContracts INNER JOIN (CoveredSites INNER JOIN JobRecords ON...
  14. jamiec1

    month report to include zeros

    hi blom the JobRecords.DateTimeCreated field is date and time so without having the month table full of every date and time in each year i dont think this would work .. thanks for your help though.. i posted a cut down version of the query the full one is here SELECT...
  15. jamiec1

    month report to include zeros

    I need to display the count of jobs logged by month but include zeros where no jobs have been logged in a mth SELECT format(DateTimeCreated, "yyyy/mm") As Mnth , count(JobRecords.DateTimeCreated) AS Tot FROM JobRecords GROUP BY format(DateTimeCreated, "yyyy/mm"); this...
  16. jamiec1

    working out the number of working hours between two date times

    ps it has to take into account : working week mon to fri each day 9 to 5
  17. jamiec1

    working out the number of working hours between two date times

    this is a problem i have been trying to get my head arround but to no avail .. any help is appreciated. jamie
  18. jamiec1

    how do i work out the number of working hours between 2 dates+times

    thanks .. i will give that a go
  19. jamiec1

    best or favorite open source sites ?

    just starting flash and would find helpfull thanks
  20. jamiec1

    how do i work out the number of working hours between 2 dates+times

    bump

Part and Inventory Search

Back
Top