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

    exe details

    Hi, How can I check how long an exe has been running? Cheers Derek
  2. moleboy

    Clustered Index order

    Jim, I'm not 100% sure how SQL server uses indexes but i've been told it's a snaphot of the table data but in the the specified index order. They're implying that if you use the datetime at the top then this will always order the records by date as opposed to the areaID which can be anything...
  3. moleboy

    Clustered Index order

    Having a disagreement at the moment and hopefully someone can help. I have a database with 2 million records in a main table. The table has a clustered index on areaID, date, userID, typeid in this order. I have been told that i should change the order by swapping the the date and areaID as...
  4. moleboy

    IIS logs files DONTLOG

    Hi, I'm using IIS6 and getting huge log files (500M) each day and I'd like to remove logging of images and some other folders. I've found this <code> set IISOBJ = GetObject("IIS://localhost/w3svc/1/root") IISOBJ.DontLog = 1 ' Do not log requests. set IIOBJ = nothing </code> I'm not sure...
  5. moleboy

    onclick image swap

    Here you go. <html> <head> <script type="text/javascript"> <!-- function toggle(theDiv){ var el = document.getElementById(theDiv); el.style.display = (el.style.display == "none")?"":"none"; //--> } intImage = 2; function swapImage(name, src) { switch (intImage) { case 1...
  6. moleboy

    onclick image swap

    Thanks Dave but the first part u mentioned was a typ o. Is is set to one in the code. I've tried break; but to no good. To expain further , I click on the first image, text is visable, and image changes to minus.gif. If I click again on the same image(its minus now), text hidden, and image...
  7. moleboy

    onclick image swap

    Hi, Im try to create a cascade of information using plus and minus images. intImage = 2; function swapImage(name, src) { switch (intImage) { case 1: document.images[name].src = "images/plus.gif" intImage = 2 return(false); case 2: document.images[name].src =...
  8. moleboy

    DTS FROM SP

    HI, Is is possible to call a DTS package from a stored procedure?? Cheers Moley
  9. moleboy

    sql subtotals and grouping

    Thanks, thats done the trick.
  10. moleboy

    sql subtotals and grouping

    I'm stuck with my sp. I'm trying to get a recordset containing assessment, staff, team, score, ave score, team ave score. I'm stuck on the ave scores SELECT Score, TeamID, staffID, (??) AS AveScore, (??) as TeamAveScore FROM tblAssessment GROUP BY TeamID, Score, staffID ORDER BY TeamID I...
  11. moleboy

    mde security failing

    Hi, The mde front end opens loading a form, which is the main menu screen. This also triggers a few queries. Just recently users are reporting that when they open the mde file they get the database table view. So either Access is failing or someones hacking. Can anyone shed some light on how...
  12. moleboy

    mde file settings being changed?? How and Who?

    Hi, The mde file opens by loading a form, which is the main menu screen. This also triggers a few queries. Just recently users are reporting that when they open the mde file they get the database view. So either Access is failing or someones hacking. Can anyone shed some light on how a user...
  13. moleboy

    LOOP within LOOP in stored procedure

    seems to have done the trick, Thanks
  14. moleboy

    LOOP within LOOP in stored procedure

    My code requires two loops, the first is looping through timebands (which is OK) the second moving the @startdate+1 until @enddate This is the first loop, I've been trying to add a second (@startdate) loop without success (using WHILE @startdate<= @enddate) my code.... set @timeband =...
  15. moleboy

    pivoting data into a table

    I'm trying to manipulate some data into a table. the results of the query are date 9:00 10:00 11:00 12:00 1/09/03 0 2 7 4 2/09/03 1 5 9 15 and I neesd to insert into date timeslot Value 1/09/03 9:00 0 1/09/03 10:00 2 1/09/03...
  16. moleboy

    format time

    Thanks, it working now.
  17. moleboy

    format time

    I only want to store the time and discard all other info.
  18. moleboy

    format time

    I'm trying to format txttime using Cdate(Request.Form (&quot;txtTime&quot;)) the input into txtTime is '0800' but this returns 0 when formatted. can any one help? Moley
  19. moleboy

    add second recordset to first

    rudejohn, can you give an example of how I would use get rows do that as I cant use a join
  20. moleboy

    add second recordset to first

    sorry working from home without access to work SQL server. the queries both are generated from a stored procedure and are both dependent on a single input parameter, nothing else. the first query is a select date, code, case(when x between y return 1 else 0) AS [0-1], case(when x between y...

Part and Inventory Search

Back
Top