I am thinking, if the application could replace all the single quotes in the sql string into a rarely used character before passing in the string. In this case,...

Sorry, I don't get it. Can you give me more explicit explanation for how should I solve this problem?

Thanks,

AC

Thank you for all of you who response to me or trying to help me for a solution. I applied the suggestion by Tom Brattin and reconstruct my sql...

Sorry Mathuar, your suggestion returned more than 49 thousands rows of records. Thanks for your response anyhow. I am still trying to be creative for finding a solution.

...

Many thanks for you guys response. I tried your suggestions but they are not returning what I am looking for either; they all returning 4 rows but I am...

Yes, you are right. However, I cannot binding the return value using TOP 2. This statement expected to return 2 rows because of the current data set and keys...

For this particular keys, the expected result should be 2 rows (NOT 4 rows). The Oracle sql statement will further filter out by picking the max time_stamp. Therefore,...

Thanks jpipes but it is not returning the correct result. May be I should include the exact Oracle statement for a reference.

-- Oracle:

SELECT T1.*,T11.PROPERTY_ID,T11.FACILITY_ID,T11.GROUP_ID,T11.WELL_UWI,T11.RESERVECAT_ID

FROM PSSL_T_REVISION_HISTORY T1,

PSSL_RESERVE_ENTITY T11,

PSSL_REVISION_CATEGORY T2

WHERE T1.PROJECT_ID =...

May be my messages are not clear enough. What I am trying to do is a stored procedure (sp) returns a cursor, and the calling sp gets the returned...

For this example, I only have 2 columns in my returned cursor. The fetch statement is matching to the select list but I only wanted to take the value...

I got it, thanks.

Thanks Allen for your quick response.

1). I am using SQL Server 2000. So I should able to drop the columns in this case, isn't it?

2). I use Query Analyzer's...

Thanks for you guys. The suggestion from BrendonSmith works for me. Again, I am very appreciated for you guys response.

AC

Thanks Gregj,

I tried to run your recommended sp; however, it seems to me that this sp doesn't meet my requirement for returning all table names that reference to constraint for...

I got it. It's cool! Even though it is not as convenience as in Oracle, it is definitely better than search for all of my sps and update...