Search results for query: *

I am able to run the statement below SELECT * from openquery (Linkedname,'Select RPDOC AS InvoiceNumber, RPPST AS InvoiceStatus, SUM(RPAG) AS GrossAmount FROM F03B11 GROUP BY RPPST, RPDOC') But When I use the CASE ststement to filter the data further I get an eror message. SELECT *...

Thank you all for being so responsive to my queries. I have another one. I am trying to use a for loop to attain a single string into a local variable from a multiple rows with same Roll_NO. Is there an easier way to extract the rows to the string. I have a layout of the Table XYZ as below...

I am looking for a way to assign a Dynamic Output queried from a select statement with multiple rows into a Local table. SELECT rownum, Amount, Due_date FROM TABLE.DBlink where ROLL_NO = 'xyz' and (extract(year from due_Date)) = EXTRACT(YEAR FROM sysdate) and SUBSTR(ORIGIN,1,3) in...

I have come accross a roadblock. I need to parse a string that is passed to a variable. I need to parse two seperate strings from one string to be compared. The 1st string to be parsed can have either 6,7,or 8 characters in the initial part of the string. The second is always constant to '5-4'...

I have come accross a roadblock. I need to parse a string that is passed to a variable. I need to parse two seperate strings from one string to be compared. The 1st string to be parsed can have either 6,7,or 8 characters in the initial part of the string. The second is always constant to '5-4'...