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

Must have been staring at it too long and didn't see it. Thanks so much for your help. I appreciate it.

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

There is a space between them so I'm guessing that the instr will work. I'm still not very familiar with ActiveX Script in a DTS package, (or VB for that matter.) Could you give me an example of the instr? I would really appreciate it. Thanks.

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

Thanks so much rosenk. You saved me some time!!

Running good ol' Windows 2K.

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.

Perfect, thanks so much!!!!!! Kelley

When I do UPDATE LMSALESRPT SET PY_AMT = (SELECT B.CY_AMT FROM LMSALESRPT B, LMSALESRPT A WHERE A.PY_DATE = B.CY_DATE AND A.ACCOUNT = B.ACCOUNT AND A.ACCT_UNIT = B.ACCT_UNIT AND A.SUB_ACCT = B.SUB_ACCT AND A.DESCR = B.DESCR) I get an error that it is returning more than 1 result. I'm...

Oops, typo I meant that I tried: UPDATE LMSALESRPT SET PY_AMT = (SELECT CY_AMT FROM LMSALESRPT WHERE CY_DATE = PY_DATE AND ACCOUNT = ACCOUNT AND ACCT_UNIT = ACCT_UNIT AND SUB_ACCT = SUB_ACCT AND DESCR = DESCR) Thanks

Nope, it doesn't return anything. I tried: UPDATE LMSALESRPT SET PY_AMT = (SELECT PY_AMT FROM LMSALESRPT WHERE CY_DATE = PY_DATE AND ACCOUNT = ACCOUNT AND ACCT_UNIT = ACCT_UNIT AND SUB_ACCT = SUB_ACCT AND DESCR = DESCR) Any other ideas? It'd greatly appreciative.

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

Here is what I have tried. In the script SLTRANS is the original table and LMSALESRPT is the new one. I added the Description field to match on since the ACCT_UNIT, ACCOUNT, and SUB_ACCOUNT could be the same for several entries and the DESCRIPTION would be the only thing that differentiates...

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