|
-
generally that error occurs due to the select statement returns more than one value.
means if u issue SELECT INTO from ...............
so every variable can hold only one value at a time.
so that if that select statment returns more than one value, then system doesn't understood which value should be stored in that variable.
thats why the error occured.
so u can try that using
SELECT DISTINCT INTO from ...............
or using cursors.
Vth pleasure...
Bhaskar Akkala.............
sridhar garige
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Click Here to Expand Forum to Full Width
|
|
Reply With Quote