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!

Recent content by r937

  1. r937

    MySQL Date range or IS NULL

    php is a pretty powerful language write an IF test in php so that if no date range is specified, then remove those lines from the sql statement easy peasy r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  2. r937

    mysql to mssql

    all those datatypes are okay except LONGTEXT which should be TEXT however, you must also remove the "length" from the numeric datatypes int(11) --> int tinyint(1) --> tinyint tinyint(4) --> tinyint etc. r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  3. r937

    Select all last results from a range of hosts

    SELECT AVG(t.result) AS avg_result FROM ( SELECT id , MAX(time_of_execution) AS max_time FROM results_tbl GROUP BY id ) AS m INNER JOIN results_tbl AS t ON t.id = m.id AND t.time_of_execution = t.max_time r937.com | rudy.ca Buy my new...
  4. r937

    Select all last results from a range of hosts

    SELECT t.id , t.time_of_execution , t.result FROM ( SELECT id , MAX(time_of_execution) AS max_time FROM results_tbl GROUP BY id ) AS m INNER JOIN results_tbl AS t ON t.id = m.id AND t.time_of_execution = t.max_time r937.com |...
  5. r937

    Help with Query

    not easily best you can do is code up one SELECT for each custom table, and then UNION ALL all the results together SELECT * FROM customa UNION ALL SELECT * FROM customb UNION ALL SELECT * FROM customc ... the better solution, based on what i see in customa and customb, is to combine all...
  6. r937

    How does joining without 'JOIN' work?

    cannot emphasize this enough r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  7. r937

    return numbers only in SELECT query?

    sure, but you have to use the REPLACE function to replace those characters with null strings r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  8. r937

    PHP Code won't post to DB (newbie question)

    thought about posting in the php forum? that's likely where the problem is r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  9. r937

    Why do these two strings equal each other?

    wish i knew however, <cfif Evaluate(varA) IS Evaluate(varB)>true<cfelse>false</cfif> produces false r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  10. r937

    Query results - Month and Day on a seperate row

    looks like you posted an oracle question in the microsoft sql server forum but anyhow... SELECT TO_CHAR(TO_DATE('dec 7,2012', 'mon dd, yyyy'), 'Mon, yyyy') as Month , TO_DATE('dec 7,2012', 'mm dd,yyyy') - LAST_DAY(TO_DATE('nov 7,2012', 'mm dd,yyyy') )as Days FROM dual UNION ALL...
  11. r937

    routine issue

    why keep bringing this up? i never mentioned sql server try using SET instead of DECLARE r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  12. r937

    routine issue

    why post that then? r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  13. r937

    routine issue

    dude, you're welcome, but i knew that :D r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  14. r937

    SELECT UNION statement works in MSSQL but not in Oracle

    i have no idea, because i don't do oracle but i would guess Oracle release 11g or whatever one corresponds to the version you're using r937.com | rudy.ca Buy my new book Simply SQL from Amazon
  15. r937

    routine issue

    use @iNewCId instead of iNewCId r937.com | rudy.ca Buy my new book Simply SQL from Amazon
See more

Part and Inventory Search

Back
Top