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 TouchToneTommy 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. syenchik

    date formatting

    fixed it
  2. syenchik

    date formatting

    Can anyone tell me the correct smalldatetime format for SQL 2000? I've tried every format that seems correct but I keep getting parameter errors or type errors in my stored proc. Thanks
  3. syenchik

    sql date

    Can anyone tell me the correct smalldatetime format for SQL 2000? I've tried every format that seems correct but I keep getting parameter errors or type errors in my stored proc. Thanks
  4. syenchik

    table join

    A lot of the work I do involves taking other folks' databases, and setting them to work with ASP. In this case it was an Access database that my predecessor had built many years ago. The data structure is actually terrible . . . but I really couldn't change all that much. Initially, the...
  5. syenchik

    table join

    Thank you so much. This is the most helpful response that I've gotten on any forum. Any other ideas would be greatly appreciated. This was a tough one. s
  6. syenchik

    table join

    Sorry. The structures are as follows: actionsMB - coid [int](4), actiontype [varchar](50), and a bunch of information fields (all varchar) that don't matter to this query The info i need from this table is a count of all records for a particular coid, and a count of all records with...
  7. syenchik

    table join

    Hi. I'm trying to write a query that joins fields from two tables. The syntax is eluding me because I need to join two seperate counts from the same table with all of the fields from another table. The first table is called actionsMB, and I need a count where coid=variable and another where...

Part and Inventory Search

Back
Top