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 dencom 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: ProInfo
  • Content: Threads
  • Order by date
  1. ProInfo

    Counting distinct values for multiple months

    Hi guys, Got a little problem here. I can't for the life of me, figure out how to do this. pid | firstlast | lastvisit | zip --------------------------------------- 435 | 2001-01-17 | 2012-01-21 | 46530 567 | 2001-01-18 | 2012-01-21 | 46530 532 | 2001-01-19 | 2012-01-22 | 46535 536 |...
  2. ProInfo

    Left Join? Need to combine a "log table" with an "accounts table"

    Greeting from Indiana! This is what I am working with, I have two tables. One is an accounts table, one is a visitors table where records are added as a person visits. I believe I need to use a LEFT JOIN, but I am not sure how to do it. I have tried creating one and I get errors that I don't...
  3. ProInfo

    Java is a huge cup of coffee!

    Hello, I've been developing in JSP using the Struts Framework for about 3 months now. I use Netbeans IDE 7, and it's been fun! However, I am looking to start developing some Java Desktop applications. Netbeans tells me that the "Swing Application Framework" is basically outdated and no longer...
  4. ProInfo

    Get starting date of first week in a year.

    Hello fellow forum members!!! I am using Calendar.WEEK_OF_YEAR to return to me an integer of 1-53, my week is set to start on Monday's. So the first week of 2011, was December 27th, 2010 - January 2nd, 2011. I need some help writing a function, or using built in functions to return to me the...
  5. ProInfo

    Pure SQL or SQL + Programming

    Hello everyone, I am having trouble making a decision on which direction to go. I have several users with unique ID's and I am tracking visitor information, time, day, month, year, based on that ID and the month. Plan A, 12 Select Statements (1 for each month) to get a monthly visitor...

Part and Inventory Search

Back
Top