Search results for query: *

I'm still not sure how to run this. Forgive my low level knowledge. I have an oracle table called activity with customer information. This table has millions and millions of records and I cannot go in and change anything. This table has a transaction_date column in datetime format. I want to...

Sorry, I am trying to use either proc sql or a data step. Which do you recommend?

Hi, I have an ORACLE table that has customer transaction information. I want to be able to only pull data between 2 dates. I don't know even where to begin. Your help is greatly appreciated. Thanks

This is SQL 7.0 I do understand the basics of XML and how it is structured. I just am not sure how to create an xml from a sql table. I'm guessing I would do this using a stored procedure, but I'm not sure. Thanks in advance.

Hi, I'm brand new to xml and webservices. My situation is this. Currently I have a sql server table that is loaded with information every few hours via DTS package. What I need to do is to take the information in the table and convert it to XML to be sent to another company through web...

Ok, I see what you are saying and you were right, the variable contained a null value. Now that is resolved and I have added in server.mappath(). Now I get this error on that particular line: msxml3.dll (0x80070005) Access is denied. I'm not sure what I need to do to be able create the...

Ok, so if the aru_phone variable is a number, what do I need to do to convert it so that it can written in the xml file?

Thanks, let me clarify. I have an .asp page that is called earlier that defines the path. My error currently is this: Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'text' This error is referring to aru_phoneNode.text = aru_phone I'm not sure if this has anything...

Hi, I've been asked to create an xml file that will mirror the information currently pulled by an .asp page I have created. As an example, this .asp page uses a stored procedure to pull customer information and displays it on a page. What I want to do is for the page to pull the same...

never mind let me give it a shot

This seems so useful however do I have to have ExcelXP to use it? I do have SAS 9, but only Excel 2003. What do you suggest Chris? Thanks Andrew

I have two datasets that I want to display in one spreadsheet but two separate worksheets. The below does not work because I get the error: "DBMS type excel2003 not valid for export" Is there any other way to do it? proc export data=test outfile="c:\temp\results.xls" dbms=Excel2003; run...

Currently I have a field that contains datetime called image_date. However, I only want the month and year. This is what I have done. PROC SQL; CREATE table test as SELECT store_code, datepart(image_date) as image_date format=$MONYY7., cnt FROM &image_store. ; quit; Of course the problem is...