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 Chriss Miller 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 bogjacket

  1. bogjacket

    XP workstation as intRAnet server

    Good Morning, I have a Windows XP Pro machine (machine1) on our Windows XP network from which I'm trying to serve an intranet site. The web application is ASP.Net 2.0, and I can run it locally, with the URL "http://localhost/intranet." It is set up as a virtual directory, off of the Default...
  2. bogjacket

    query multiple tables named from values in another table

    Thanks rac2. This above the level of anything I've yet to do with SQL, but I'm glad to have an excuse to learn more. I'll get started on this today. bborissov, I understand what you're saying, but these tables are part of a larger third-party software that I did not build. Thank you both!
  3. bogjacket

    query multiple tables named from values in another table

    I'm sorry. When I wrote: "-dbo.jsmith -dbo.johnson -dbo.echarles" I meant that each username is in it's own row all in the same usertable. There is one user table, and a history table for each username contained within the user table.
  4. bogjacket

    query multiple tables named from values in another table

    Let's see if I can make sense of this... I have a user table, holding the names of active users: -dbo.jsmith -dbo.johnson -dbo.echarles ... I also have a history table for EACH user, and these tables are named "history" & the username: -dbo.historyjsmith -dbo.historyjohnson...
  5. bogjacket

    Tough grouping/formula problem

    Sorry, lbass. Each time a payment is made to a portfolio, a record is created and a [table.datepaid] field is set to the current date. If a payment posted today. datepaid(datetime) would be 09/01/2006, systemmonth would be '9', and system year would be '2006'
  6. bogjacket

    Tough grouping/formula problem

    Yes, Carol. That helps a lot. I'll get started on that. THanks to all for the responses, so far.
  7. bogjacket

    Tough grouping/formula problem

    OK, I think I see what I've not been telling you. Each record in the source table represents a payment made to a particular porfolio, and there are multiple records per month, per portfolio. So, each record in the source has: portfolio name, payment, date, sytemmonth, systemyear. For each...
  8. bogjacket

    Tough grouping/formula problem

    No, sorry. It's difficult to explain what I don't really understand. I'd like to have one group per page, and that group should be the portfolio name. Within each page I'd like to repeat a set of calculations for each month that the portfolio has existed in the db. So, a group for a...
  9. bogjacket

    Tough grouping/formula problem

    Please bear with me, as I'm no CR expert. I'm running CR XI and SQL 2000. I have a xls workbook that we loosely call a stairstep report, which tracks (manual data-entry) the performance of portfolios as we add them to our system. The report shows the performance by month. So, the date each...
  10. bogjacket

    How to copy new records & overwrite existing ones

    That certainly sounds helpful, Denis. Thanks to everyone else for their responses. I'll be working with these today.
  11. bogjacket

    How to copy new records & overwrite existing ones

    Hello, I need to copy one table into another. If a primary key from the source matches one in the destination, I need to overwrite the existing record in the destination with the new one from the source. FWIW, I've searched online, and I've bought a book on sql syntax, but I can't seem to...
  12. bogjacket

    INSERT .csv formatted records into SQL w/o dupes

    The first field in the feed is the primary key for the destination table. I think it should be pretty easy from here. Here is what the feed will look like: "Loan Name","Borr First Name","Borr Last Name","Borr SSN","Subj Prop Address","Subj Prop City","Subj Prop State","Subj Prop Zip","Subj...
  13. bogjacket

    INSERT .csv formatted records into SQL w/o dupes

    Thanks, Denis. I got the BULK INSERT working. SQLSister, Thank you so much for all that info. I do need to consider most of those things, and I'd be thrilled if you'd help me write the correct statements. Let's see: - I will need to use UPDATE. How do I account for dupes? - No DELETE -...
  14. bogjacket

    INSERT .csv formatted records into SQL w/o dupes

    Yes, it looks like I'll need to look into my permissions and making sure that the text file is in the right spot, because the csv file is on my machine, while the server is not. Also, if I just copy and paste the stuff you gave me into Query Analyzer, where will it create the object...
  15. bogjacket

    INSERT .csv formatted records into SQL w/o dupes

    Thanks again, Denis the SQL Menace! Could you take a look at my BULK INSERT statement and help me with the syntax? BULK INSERT sql.mvdata.Table1 FROM 'c:\LoanRecords.csv' WITH ( FIELDTERMINATOR = ' , ', ROWTERMINATOR = ' \n ' ) It told me that my syntax was incorrect near ',', and it also...
See more

Part and Inventory Search

Back
Top