Viewing 15 posts - 46 through 60 (of 88 total)
Hi Matt,
I have some other factors involved in the query to use the alias and below is my original query and how would I resolve the problem with a subquery...
February 20, 2008 at 7:56 am
Thanks.
September 28, 2007 at 9:20 am
I think I found my own problem. The problem is I worked from home using a wireless DSL and the cursor return only partial rows. Nevertheless when I worked from my office...
September 17, 2007 at 3:45 pm
Here is the (@strSQLX) results below
INSERT INTO #TableB(Pcode,XText1,XText3,XText5,MKID,CUID)
Select 'BBBTTT','<SujInfo>'+'<SujInfoKey>'+'<studyNumber>ATP111</studyNumber>'+'
<siteNumber>350000</siteNumber>'+'<cID>3501</cID>'+'</SujInfoKey>'+'<SujInfoAttributes>
'+'<ScId>350000001</ScId>'+'<TARM>A</TARM>'+'<SOV>2</SOV>'+'<SRReas>'
,'</sRReas>'+'<withReas>','</withReas>'+'<stat>P</stat>'+'<sDate>2007-08-22</sDate>'+'<ftx></ftx>'+'</SujInfoAttributes>'+'</SujInfo>','382','380'
September 17, 2007 at 7:00 am
Here is my code below.. #TableA got 200 rows. After I finished the cursor #TableB got only 90 rows. Please advise. Thanks.
DECLARE X_Curs CURSOR LOCAL FAST_FORWARD for
SELECT Pcode,Prtl, StNo,cID,ScID,TARM,
...
September 16, 2007 at 9:00 am
I have a question on this VBscripts. Prior running the script do i have to create a table? Please advise. Thanks.
August 20, 2007 at 10:18 pm
Thanks. Let me know if you find out the answer to generate the create script. By the way if you do not know SAS how did you know the command...
May 1, 2007 at 10:07 am
Hi Adrian,
Any ideas after importing the csv file through import wizard and modified the formats dataset, is there a way to generate the create script from the SAS? Please advise. Thanks.
May 1, 2007 at 9:52 am
Hi Adrian,
That import wizard helps a lot but it did not show me how to execute the SAS command line. any dieas? Thanks.
May 1, 2007 at 9:04 am
Is there a way to invoke the SAS to pick up the .csv file and convert to SAS .xpt format from the DTS? Anybody?
April 30, 2007 at 10:24 pm
hi Melster,
I am having the same problem. Have you found out how to clear the unwanted data and how to include the header? Please advise. Thanks.
April 30, 2007 at 4:30 pm
I was reading this post and I wonder how does this work on DTS if I want the export it an SAS .xpt format. Also how can I establish a a...
April 25, 2007 at 12:37 pm
unless you open from wordpad you will not see the zeros. This is a automatic default from Microsoft. You might want to check if there is an option in the csv...
March 27, 2007 at 12:02 pm
I want to thank you for help. I have created 2 triggers to differenciate the Insert and Update.
March 22, 2007 at 1:20 pm
What are the differences between AFTER INSERT trigger and INSTEAD OF trigger? Thanks.
March 22, 2007 at 10:07 am
Viewing 15 posts - 46 through 60 (of 88 total)