Search results for query: *

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

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

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

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