Search results for query: *

I know this version is very old/outdated but our company continues to use old solutions. :) I'm tasked with documenting all open TCP ports by this tool. I've searched SAP's site and have turned up nothing in the way of ports and port ranges for all the various services for CR 8. Would...

What's a good way to break up the time values returned in your average BSD-styled ps? The format is generally dd-hh:mm:ss.ss. As you know, the days portion is not always populated if days haven't accumulated depending on the aspect of time we are looking at (ie, etime, cputime, etc.).

I have searched and read a few sites but I thought I would ask here from professional users for what exists as a good viewer of either csv or xls attachments. I can generate the reports in a number of formats but the users prefer a csv and/or xls format for easy manipulation of not incredibly...

Got a slight issue and would like a little insight in how some of you have approached it. I receive data via an uploaded CSV file and would like to select that data from that file and insert into a table of my complaints database. I currently have a DSNless connection to the CSV file that...

Due to the storm we are migrating our applications to another vendor's server for which we don't have full access. We weren't given the full path to our page directory. It's been a while so please forgive my ignorance but how can I determine the full path of an executing script?

I've recently taken over a database that has SQL server 6.5 compatibility set due to the nature of the vendor. I am to write a few scripts to dump some of the data for a 3rd party. This data, of course, needs to be fixed width text. Does anyone have any recommendations for a good string...

What's the easier approach for handling inserts where a duplicate record may exist? ASP/MSSQL are the language and db in use. I would like to display a pop-up indicating that a record already exists and list the keys attempted to be inserted.

Without additional coding, what are convenient methods for importing flat files with dates that are of the form yyyymmdd? I have customized import scripts to account for the different format but I was wondering if DTS had an "intelligent" operation for date data-type imports.

I have searched with some limited success but I would like to color code some values in a resulting report. If the value exceeds a maximum, then a particular color would be applied to that value. Anyone approach this idea before?

I am implementing a stored procedure to dump a list of previous days work orders. The recipient of this lovely list of work orders is utilizing an older system of fixed length flat files for import and processing. Each row in the output file is 500 bytes and must be 500 bytes to be cosidered a...

I have taken over a database that has some not-so-normalized data in a field that contains phone numbers. Some fields are all numeric and some have the dashes. What's a good method for removing the dash character? I have looked at a couple substring functions but I need something tiny and...

I am trying to devise a query such that I can produce rows that are similar. An example should give an idea of what I am trying to accomplish. My prospective data set is similar to the following: FName Address InvoiceFlag BusPartner --------------------------------------------- Bob...

With the search feature unavailable today, I'm hoping no one will mind a direct question. :) I have created a DTS package that will drop and recreate a table within my database based on a flat file received from an external vendor that is placed on an internal common server share. What I...

I have a table that, among other columns, a 6-character string that represents the time. Anyone suggest a nice way to convert that field to a valid non-24hour time string or a text/character equivalent such as example: 165304 4:53:04 PM Possible? Suggestions?

I have an instance of two tables that I would like to join some resulting counts by date: Table A ----------------- entry id date part # -------- ------ ------ 1 1/1/04 1 2 1/1/04 1 3 1/1/04 2 4 1/2/04 1 . . . . . ...

I have an interesting question posed by peer of how to select only records from a table that the currency field has cents. The following table can be considered: ID FName LName Dues_Paid -- ----- ----- --------- 1 Bob Smith $14.00 2 Susan Allen $12.32 3 Tom Jones...