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 Wanet Telecoms Ltd 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: JohnSouth
  • Content: Threads
  • Order by date
  1. JohnSouth

    get next N records

    Hi I'm sure this is an old perennial, so feel free to refer me to earlier answers.. How so I get SQL to return me the next/previous N records from a table that does not have a suitable unique key I can use to fix the start point? I can get the first N with SELECT TOP, but after that it gets...
  2. JohnSouth

    E-mail reports

    Hi Using VB6 and Crystal Report Engine 7 Object Library I need to e-mail reports directly to a recipient whose address is available to the VB code. Does anyone have a simple example of how this is done. Cheers John South JS Associates Pangbourne UK
  3. JohnSouth

    Truncate Trans Log Every Night

    Hi I've a SQL 7 Application program that clears some Tables and Reloads them with new data every night. The Transaction Log grows at an alarming rate! How can I ensure that the Transaction Log is cleared down every night? I've tried various combinations of backup but it's still growing...

Part and Inventory Search

Back
Top