Recent content by klmc

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.