Query!

Hi All,

Declare @.FirstNamenvarchar(60)

Declare @.LastNamenvarchar(60)

select @.FirstName=Usr_First_nm,@.LastName=Usr_Last_nmfrom cpmwhere login_id='dattEMEA_superuser'

Consider the above example. I want to print the varaiable values using select statement. What should I do?

I don't want to use PRINT statm.

Regards

Abdul

try with this procedure...

Declare @.FirstName nvarchar(60)

Declare @.LastName nvarchar(60)

@.FirstName= selectUsr_First_nm from cpm where login_id='dattEMEA_superuser'

@.LastName=selectUsr_Last_nmfrom cpmwhere login_id='dattEMEA_superuser'

select * fromcpmwhere Usr_First_nm =@.FirstName and Usr_Last_nm = @.LastName

|||

select @.FirstName , @.LastName