Search results for query: *

Hi Mikrom, The code did not return any error but the result is still the same where I am before. See my comments below -- select t1.id as id, t1.DocName as DocName, case when len(LTRIM(RTRIM(t1.col1))) = 1 then '' -- Length varies so it can be more than 1. I did > 1 but it empty my col1 else...

Mikron, Thanks for your response. The strip and length functions are from python and I am using TSQL. I replaced it with LTRIM & TRIM and LEN. It did not resolved my problem but getting the same result. Any ideas? select t1.id as id, t1.DocName as...

On the same table I have table rows that are broken from the import and went to the next row. I need to bring it back to the parent row. For example ID 1 Col3 supposed to have the value 'GHI' but the 'I' went to the 2nd row or ID 2 Col1 cell. Same applies to ID3 supposed to have 'GGG' but it...

I am looking for examples to use Java Script to parse and import word and pdf into SQL server table. The word or pdf might have format from the link below. Can this be done using Java script? Thanks http://naturalbuffdog.com/assets-and-liabilities-spreadsheet/examples-of-assets-and-liabilities/

Thanks everyone.

I think I did not make self clear. In the \\servername\Data directory there are many different formats of files and I only want to archive the .txt files and add the dates to the end of each file. Is that possible? Thanks.

Hi, I am using VB script for Active X DTS. I have mulitple files like (AA.txt, BB.txt. CC.txt) in a directory \\servername\Data and I need to archive it to the directory \\servername\Data\Archive once it is exported through DTS. I like to archive it and add latest date after the original names...

Actually, I resolved my own problem. I have data come in as Female and Male and instead of F and M. So I changed my format to Female = F Male = M and that resolved my problem. Thanks for your help.

HI ,I am new to SAS and I have a 9.1.3 SAS installed on my workstation. When I executed the script below I ran into error stated "The format $SEX was not found or could not be loaded"'. Below is my script and I have commented with "ERROR HERE !!!". Please advise. Thanks. libname dummy1...

Hi, I need to create a DTS to output and SAS xpt format. The DTS will connect to SQL 2000 server and Ther SAS include comment and label. Where do I start and how is the connection establish for SAS to SQL server in DTS. Please advise. Thanks.

any example you can show?

Hi, I have a table below Table A ID ModDate InputDate Type 1 12/1/05 12/3/05 2 2 1/13/06 1/30/06 5 3 2/14/06 2/23/06 4 and I need to create a trigger to capture only if there is an Update on 'ModDate' with the 'Type' = 5 or an Insert row with the...

Hi nice95gle, First of all, I want to thank you for your help and patience. I finally found out my problem. I have saved the Books.xsd and Books.xml in WORDPAD instead of NOTEPAD. WORDPAD has added invisible format texts more than I needed that caused the problems. Gob bless you. Thanks once again.

Most of them I have answers except question 1. see my Answers. <?xml version="1.0" encoding="UTF-8"?> This will go on the line above <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" Ans -- I have tried placeing the UTF this but to no avail. But here is a quick check list for you...

Here you go on the errorlog, <?xml version="1.0"?><Result State="FAILED"><Error><HResult>0xC00CEE2D</HResult><Description><![CDATA[Schema: unable to load schema 'books.xsd'. An error occurred (Incorrect document syntax.) at line 1 column 1.]]></Description><Source>Schema...

Below is my Books.xsd codes and I don't see any different. Any ideas? Thanks. <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:element name="Book" sql:relation="tblBooks" > <xsd:complexType> <xsd:sequence> <xsd:element...

I do not have a Northwind DB my table was created on DTESTDB since I started this test.Any ideas, Why the books.xsd failed? Thanks.

Wow, I never even realized that there is a \ before the C:. Good Catch. That resolved this problem but I ran into another error on books.xsd. ------------------------------------------------------ Error source = Schema Mapping Error Description =unable to load schema 'books.xsd'. An error...

Hi nice95gle, That fix my problem. However, I executed the Active X I got another error on the books.xsd. The error stated below. My books.xsd codes is exactly what you have given me.Here is the error "unable to load schema 'books.xsd'. An error ocurred(unKnown error) P.S my tble created is...

Hi nice95gle, I created another test using global variable and code error out on "Object doesn't support this property or method: 'oCnn.Open'. Do you have any ideas? I hope this is the last question. Thanks. '********************************************************************** ' Visual...