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

    Is it possible to get average log backup size?

    I need to capture some database growth stats for a hardware purchase. I'm currently doing backup with weekly fulls, daily diffs, and t logs every 15 mins. I was thinking I could get an average of my t log backups to figure out future growth. thanks for any help.
  2. cwbrumett

    need help with a self join query

    Basically I have a flat table that contains contact details AND order details (I didn't make it .. just inherited it) The pkey is a auto-incrementing field, what I need to do is get what the "previous" id is for a given contact, null if there was no preivous. sample data: RecID ContactID...
  3. cwbrumett

    using first occurrence of a found record in a join

    I've been working on this all day and just can't seem to figure it out, i'll try to explain the best i can. I have a table that holds price points by week, by year, by brand and sometimes by event. I have to join via left outer join as orders don't have to have to have a price point. the...
  4. cwbrumett

    search for text within jobs

    I was wondering if there was anyway to search all of the jobs for a table name (or any text for that matter). something similar to searching DTS via: http://www.sqlservercentral.com/Forums/Topic181665-8-1.aspx and searching Sprocs and views SELECT Distinct SO.Name, SO.Type FROM sysobjects...
  5. cwbrumett

    update problem when subquery returns multiple results

    I'm having a weird problem, I'm trying to update a table where the pkey is InvItemNum and InvCompanyCode (on both tables) ... the problem is when I try to execute the below statement it returns the error Server: Msg 512, Level 16, State 1, Procedure trg_UpdateItem, Line 4 Subquery returned more...

Part and Inventory Search

Back
Top