Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
HockeyFan
Starting Member
26 Posts |
Posted - 2007-12-05 : 11:47:37
|
I'm wanting to do a single select (or set) and pull 3 fields from a table, into 3 local variables: something like:Select LNAME as @LastName, FNAME as @FirstName, MNAME as @MiddleName from USERS WHERE ID = @ID |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-05 : 12:03:40
|
you can take like this:-Select @LastName=LNAME ,@FirstName =FNAME ,@MiddleName= MNAME from USERS WHERE ID = @ID |
|
|
HockeyFan
Starting Member
26 Posts |
Posted - 2007-12-05 : 12:07:48
|
I tried that. Got the following:Incorrect syntax near ',' |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-05 : 12:21:16
|
Is this being used as part of some other query? |
|
|
cr8nk
Yak Posting Veteran
77 Posts |
Posted - 2007-12-05 : 12:21:27
|
Post your code. |
|
|
HockeyFan
Starting Member
26 Posts |
Posted - 2007-12-05 : 12:27:34
|
SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER OFFGOALTER FUNCTION [dbo].[UFN_NAME_FROM_USERNAME] (@LOGGEDDOMAINUSER varchar(50)) RETURNS bigint AS BEGIN DECLARE @ID bigint Declare @Username varchar(20) Declare @FullName varchar(80) Declare @LastName varchar(25) Declare @FirstName varchar(25) Declare @MiddleName varchar(25) Declare @i int Select @i = charindex('\', @LOGGEDDOMAINUSER, 1) if (@i > 1) Begin Set @Username = substring(@LOGGEDDOMAINUSER, @i+1,20) Set @ID = dbo.FN_GET_USER_ID(@Username) Select @LastName=LNAME ,@FirstName =FNAME ,@MiddleName= MNAME from USERS WHERE ID = @IDprint @LastName, @FirstName, @MiddleName End Return 0 -- to be removed after Donnie updates the case manager ids --Return @IDEND |
|
|
X002548
Not Just a Number
15586 Posts |
|
HockeyFan
Starting Member
26 Posts |
Posted - 2007-12-05 : 12:46:19
|
I guess that's it. thanx |
|
|
|
|
|
|
|