"Thierry Marneffe" <Thierry.Marneffe@skynet.be> wrote in message
news:4089753c$0$10896$a0ced6e1@news.skynet.be...
>
> Hello Eugênio
>
> Ok for your solution but ... I would like to use the value returned by the
> select ...
>
> In the tests I've done , if I do something like this:
>
> set @Sql = '@MyData = select ' + @NameField + ' from ' + @Table
>
> The variable @MyData is not available for the rest of the stored procedure
> ...
>
> Any idea how to retrieve it ?
>
> Thanks for your help
> Thierry
>
>
> "Eugênio Spolti" <eugenio@designsoftware.com.br> wrote in message
> news:ebJ6PsWKEHA.644@tk2msftngp13.phx.gbl...
> > Use dynamic Sql:
> >
> >
> > declare @NameField as char(20),
> > @Sql as char(200) ,
> > @Table as char(100)
> >
> > set @NameField = 'Test'
> >
> > set @Sql = ' select ' + @NameField + ' from ' + @Table
> >
> > exec (@Sql)
> >
> >
> > "Thierry Marneffe" <Thierry.Marneffe@skynet.be> escreveu na mensagem
> > news:40896979$0$11084$a0ced6e1@news.skynet.be...
> > > Hello
> > >
> > > Same type of question:
> > >
> > > How can I get the value of a field having the field Name in a variable
?
> > >
> > > Thanks for your help
> > >
> > > Thierry
> > >
> > >
> > >
> >
> >
>
>

> Hello
>
> Same type of question:
>
> How can I get the value of a field having the field Name in a variable ?
>
> Thanks for your help
>
> Thierry
>
>
>

"Eugênio Spolti" <eugenio@designsoftware.com.br> wrote in message
news:ebJ6PsWKEHA.644@tk2msftngp13.phx.gbl...
> Use dynamic Sql:
>
>
> declare @NameField as char(20),
> @Sql as char(200) ,
> @Table as char(100)
>
> set @NameField = 'Test'
>
> set @Sql = ' select ' + @NameField + ' from ' + @Table
>
> exec (@Sql)
>
>
> "Thierry Marneffe" <Thierry.Marneffe@skynet.be> escreveu na mensagem
> news:40896979$0$11084$a0ced6e1@news.skynet.be...
> > Hello
> >
> > Same type of question:
> >
> > How can I get the value of a field having the field Name in a variable ?
> >
> > Thanks for your help
> >
> > Thierry
> >
> >
> >
>
>