Recent content by bogjacket

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

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!

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.

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

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'

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

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

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

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

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

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

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

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

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

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