[dba-SQLServer]Selecting data into variables

Ah - thanks.

David

At 8/10/2003, you wrote:
>Use output parameters
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
>Emerson
>Sent: Tuesday, October 07, 2003 10:56 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]Selecting data into variables
>
>
>I would like to run a select statement that returns 1 row, then put the
>column values into variables I have declared in my Sproc.  The closest I
>
>have come across in BOL is the SELECT INTO statement but this is for
>"Embedded SQL for C and SQL Server".
>
>I could use a cursor but it seems overkill for only one row.  Is there
>an
>easy way to do this?
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com