Search results for query: *

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

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

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

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

Greetings! I'm basically a sql newbie or novice. I have a need to take a comma-separated file and add those records to an existing table. The existing table has different field names and far more fields than the csv file. One of the fields I'm inserting is the primary key and I'll need to...

Hello everyone, I have a field that needs to be viewed on the report in a standard way. For instance, the field might contain the strings "CitiMortgage", "CITIMORTGAGE, INC.", OR "CITI". I'd like to create another field that will represent any of these as just "CM", so I can use it for...