Search results for query: *

Hi, I have an Excel sheet with two columns, DATETIME and BYTES. I'd like to chart this but alter the Y-axis scale to show the values in MB or GB. This has to be done without altering the raw data or adding additional columns etc. So an example row is: 05/05/2013 00:00 742436864 So in the...

Hi, I need to extract information contained within the message header (or "Internet Header") in Outlook 2010. I'd like to pull out the To:, Subject: and Date: information from each email in my inbox and put it in to Excel. The following post thread707-1253839 has almost got me there...

Hi, Is there any way of finding out which version of the firmware maintenance CD (now rebadged "HP Smart Update Firmware DVD") I have installed on my server? I've taken over a box from someone who has left the company and need to understand which CD/DVD he used to update it. I know the CD is...

I have a PC with 2 partitions, XP is installed on the first, nothing on the second. I want to put WinPE on the second partition and be able to boot between the two. I understand I'll have to replace the XP boot mechanism with the Vista Bootloader which comes with the version of WinPE I'm using...

Hi, I've got the following macro which runs through my spreadsheet looking for the word 'Heading' in column A. It deletes any row which contains the word 'Heading', great. However I would like it to keep the first occurance of 'Heading' and then continue to delete the rest. I'd then like it to...

Hi, I've got the following macro which runs through my spreadsheet looking for the word 'Heading' in column A. It deletes any row which contains the word 'Heading', great. However I would like it to keep the first occurance of 'Heading' and then continue to delete the rest. I'd then like it to...

Hi, I have a text file called "Params.txt", it contains the following... start Servername = IP Address = end I'm trying to append a server name and IP address on to the corresponding lines. I've got the following code that will happily append the server name but I can't figure out how I can...

Hi, I've set up transactional replication between two databases (first time I've tried doing this). ServerA is the source ServerB is the target. I ran through the replication wizard on ServerA and published the articles I wanted. Then I created a new Push Subscription on ServerA that sends the...

Hello, Is there any way around the 8-string limit on the concatenate function within Script Editor?? I have a database from which I need to extract 10 fields and populate a peripheral variable with the result. Does anyone know of a way around this concatenate limitation?

Hi, I've got the following problem and not sure where to start with it. I've got a database on ServerA with a table called Customers. I want to copy this table to ServerB, I cannot use replication. I want to schedule a copy twice a day. I created a DTS package that copies the table, fine...

I have 1000’s of files generated every day that are in the format… “xx_12345678901_ tbdy _garbage.txt” (yes there are lots of spaces between tbdy and _garbage) I’d like to end up with… 1234567890_tbdy.txt So this means removing xx_ and also everything after the tbdy and...

Does anyone have any ideas how I might achieve the following in a SQL query? I have an application that generates a date & time in a fixed format. I want to update a Date/Time field in SQL with the date generated by my application. Unfortunately the date created is in the wrong format, for...

I've been asked if the following is possible... Scenario: ClientA sends a mail to CompanyA. CompanyA doesn't handle the email themselves but forwards it to CompanyB who deals with the query. An agent, employee1@companyb.com, picks up the email and writes a reply. The mail then is sent back to...

I've been asked to write a script that will parse a text file which holds licensing information. I need to strip out the numeric values and write them to an SQL database. I have only very basic scripting knowledge and I'm having a couple of problems, the first being getting the numbers out as...