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 SkipVought 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: mrliam69
  • Order by date
  1. mrliam69

    Running Date Difference

    No thats the total run time for the script.... it takes roughly 8 - 9 secs for it to get to your routine while it builds up to the final temp table and your routine is 1 sec or less
  2. mrliam69

    Running Date Difference

    Your quite right George I am trying to do a complicated sorting query using temp tables and I am using an idcol so all the row numbers will be consecutive and your second example runs in under 10 secs in my total query.... The machine is a 4 core Xeon with 2GB ram running W2K and SQL2K
  3. mrliam69

    Running Date Difference

    Thats a lot faster gmmastros .. Thanks for pointing me in the right direction with that and Monksnake I too have seen that cursors are a bad thing and your more of an expert than me but I'm learning all the time.... Thanks you guys
  4. mrliam69

    Running Date Difference

    Cheers for that Gave it a go and it works but very slow Tried it on 4200 rows and cancelled after 20 mins tried it on the first 1000 rows and again cancelled after 20 mins 100 rows = 45 secs 200 rows = 89 secs 300 rows = 208 secs would a cursor routine be quicker and if so any tips on...
  5. mrliam69

    Running Date Difference

    so for instance record 57 would return 0 58 = 0 59 = 3 60 = 11 48 = 0 49 = 12
  6. mrliam69

    Running Date Difference

    I have been trying to setup a running date difference (DAY) query for this table that resets on StockCode Change but with little luck as I have been trying to modify a running sum one I use... Can anyone help SELECT RowNum, StockCode, ReqDate FROM temp6 Data example 47 E0038...
  7. mrliam69

    File Synchronisation

    Cheers for that but I was after something more automated
  8. mrliam69

    File Synchronisation

    I need to setup something to synch a master folder to all clients.. We have an accounts package that uses Crystal Reports and for some stupid reason the Invoice, credit etc.. templates need to be on the local computer and cannot be shared from a central point. Currently when I make a change to a...
  9. mrliam69

    Pivot Table (Last hurdle)

    Cheers guys that worked a treat spot on with the code pwise
  10. mrliam69

    Pivot Table (Last hurdle)

    I am trying to group some quantities together but I keep getting stuck on the last stage.... SELECT SM_STOCK_CODE, sm_type, YEAR(SM_DATE)AS smyear, CASE WHEN sm_type = 'P' THEN SUM(CASE WHEN sm_status = 'O' THEN 0 - sm_quantity ELSE sm_quantity END)ELSE 0 END AS Bought, CASE WHEN...
  11. mrliam69

    Update SQL Table from Excel

    Starting from scratch on this one. Our production team use a spreadsheet to manipulate data pulled into it from our SQL Server and they then want to send the updated data back to the SQL Server. Luckily for me it is just the Production Date they want to update. All they need from the...
  12. mrliam69

    The ADP file is not in the correct format for a Microsoft Access proje

    ref thread958-1119077 I have one machine that throws up this error when trying to access an adp over the network, googled and found nothing an anyone help
  13. mrliam69

    Dynamic Table Selection

    Cheers for that.... You learn something new every day :-) Figured the select statement out but now my prequery thing is bugging me.. I need to generate DT092006 but I return DT92006 here's my test code declare @mnth int, @yr int, @curmnth int, @curyr int set @curmnth = month(GETDATE())...
  14. mrliam69

    Dynamic Table Selection

    Before we start this is not my database.... We have a Time and Attendance System that stores all the clockings in seperate tables depending on the year and month i.e. DT102006 = Oct 2006 DT112006 = Nov 2006 What I am trying to achieve is to extract out of the tables certain information and...
  15. mrliam69

    Netfinity 5500 not booting

    Dohhhh ! 1 - 1 - 4 = BIOS Checksum failed Had a mental block then just need to find out what to do with that now
  16. mrliam69

    Netfinity 5500 not booting

    I'm trying to ressurect an IBM Netfinity 5500 server and I get beep codes that aren't in the book beep beep beep beep beep beep No display is shown either Can anyone help ?
  17. mrliam69

    Row Result font Size

    Seeing as I am learning PHP HTML etc... by my usual method of reverse engineering where would I put the above style please <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title></title> </head> <table width="500"...
  18. mrliam69

    Row Result font Size

    Cheers for that but I Found the answer print "<td style=\"font-family:arial;font-size: 12px;\"><b>".$row['AccountName']."</b></td>";
  19. mrliam69

    Row Result font Size

    Wonder if anyone can help a HTML / PHP Newbie How can you change the row result font and size ? --------------------------------------------------------- $msresults= mssql_query($msquery); $i = 0; while ($row = mssql_fetch_array($msresults)) {if ($i > 0) { print "<tr...
  20. mrliam69

    Newbie ... PHP to SQL2005

    Cheers for the links ... managed to figure it all out..

Part and Inventory Search

Back
Top