Hi Everybody,
I have a probs with dynamic generation.
I am writing the probs
======================================
create proc test
as
declare @query varchar(500)
set @query = 'select * from table'
----------------------------------------------
declare mycur Cursor for Select * from table |
open mycur |
----------------------------------------------
but instate of above block how can I dynamically generate this query?
---------------------------------------
declare mycur Cursor for exec (@query) |
---------------------------------------
Or tell me the way.
Regards
Arijit Chatterjee

hi, the problem was not clear what u want to do dynamiclly.
if u want to ftech rows thru proc, u can code like

create proc test
as
use db
exec(select * from table)


this might work



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

On 4 Nov 2003 21:04:27 -0800, arijitchatterjee123 (AT) yahoo (DOT) co.in (Arijit
Chatterjee) wrote:
The way I've done stuff like this in the past is to stuff the results
into a temp table and run a cursor off that.

Example:
declare @SQLstring varchar(100)
create table #foo (foovar int)

select @SQLString = 'select distinct foovar from footable'

insert into #foo exec(@SQLString)

declare foo_cursor for select distinct foovar from #foo
etc.

Obviously you really want to do this type of stuff when there is no
other way around it.

i have Been Declare a dynamic cursor to a query ==> select location_en from ...
when i make update to the table, dynamic cursor take changes.
when i declare same cursor with the query select distinct location_en ... and update to the table, dynamic cursor does not take changes.
any idea to this probleme? thx for ur reply

From http://www.google.com/search?hl=en&q="Dynamic+Cursor"+++"For+Select+Dist inct"

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

walid kayrouz wrote:

The standard advice for cursors is "avoid using them if at all
possible". Explain what you're currently doing with them, and the
gurus may be able to offer more specific answers.