Search results for query: *

I know that this has been a problem that has been posted all over the web. I have read all the posts and still can't resolve my problem. I am running VS.NET 2003. My problem is when I try to bring in a crystal report that already exists into my web application. It is created using CR 8.5. I...

I know that this has been a problem that has been posted all over the web. I have read all the posts and still can't resolve my problem. I am running VS.NET 2003. My problem is when I try to bring in a crystal report that already exists into my web application. It is created using CR 8.5. I...

I am writing a script that will take a file and add a '/' at the end of the line if the line begins with '16' and it currently doesn't have a '/' at the end. I can get it to find the lines that start with 16, but it adds a second '/' even if the line already ends in one. I am writing this on a...

I have a .xml file that is generated when our company completes an order. What I am needing to do is find when an item is rejected and print it to a file. I have posted a portion of the .xml file. I have never used XML:Parser before and am beating my head against a wall to figure it out so...

I am currently comparing 2 tables to one another based on their respective date fields. One has the time listed as 00:00:00 and the other has an exact time. I need to set the one with the exact time to 00:00:00 so that the dates will match up properly. LIKE won't work in this instance because...

I am creating a DTS package to import a .txt file that is pipe delimited. I am bringing it into a SQL2K db. My problem is that in the file, the date is listed as dd/mm/yyyy hh:mm:ss. I need to only bring over the dd/mm/yyy part. I know that there has to be a way to do this in the...

I have 62 files that I need to make one. The file names are listed in a file named exist.txt. I need to loop through all of those names and append their content into a main file named main.txt. Is there an easy way to do that? Thanks in advance.

Currently have table with following structure: CY_DATE PY_DATE ACCOUNT ACCT_UNIT SUB_ACCT DESCR CY_AMT CY_UNITS PY_AMT PY_UNITS I am looking for a way to insert the PY_AMT and PY_UNITS. It is going to read in the CY_DATE, ACCOUNT, ACCT_UNIT, SUB_ACCT, DESCR, CY_AMT, and CY_UNITS from a file...

I am creating a table that is pulling information from a table that is already in existance. The current table contains sales information for a given date. The new table is going to take the current date and compare it to the sales from a year ago. The structure for the new table is CY_DATE...