What other limitations do you have?
CHAR or VARCHAR would work.
Why do you wish to use INTEGER?
Peter55
Last Activity: Nov 7 '07, 01:51 PM
Joined: Oct 16 '07
Location:
-
What is the name of the table into which you are inserting data?
According to your script it is TABLE, which I believe is a reserved word.
In any case, I urge you to choose another tablename.Leave a comment:
-
Please clarify the data types for the following 3 columns:
RPPOST, RPICU, and RPDOCLeave a comment:
-
What have you attempted that doesn't work?Leave a comment:
-
Your 2 tables appear to be completely different.
How do you plan to compare them?
A table with 1 column can never be like a table with 2 columns.
Or do you disagree?Leave a comment:
-
With which language are you programming?
What is your plan for solving the problem?
We can help with the query, but how do you see yourself solving it?
Write down some steps and perhaps we can help fill in the blanks for you.
Perhaps what you need is 2 or even 3 successive queries, all depending on how you decide to go forward with your solution. Do you see what I mean?Leave a comment:
-
Please clarify where you are using the statement. Which environment/language are you using?Leave a comment:
-
Jaclyn,You can use LOCK TABLE which eliminates locking overhead. However, this technique makes the table unavailable for concurrent tasks.Leave a comment:
No activity results to display
Leave a comment: