how to handle [message #37712] |
Fri, 22 February 2002 11:09 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
Hi,
Iam having problem using a dynamic sql
iam select distinct ids into myids from table1
iam getting a error saying select into too many rows.
How to handle this problem situation.
i the reason iam not using a stored proc is, i just need a id.
Appreciate any help
sam
|
|
|
Re: how to handle [message #37720 is a reply to message #37712] |
Sun, 24 February 2002 23:46 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
The statement
"select id into temp_var ..." expects only one row to be retrieved , otherwise it will raise an error
workaround
-----------
1. put where clause, so that it returns only one row
2. OR, create cursor to handle this
|
|
|