how to get output of sql query in form of string

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to get output of sql query in form of string

Author

Topic

bluestar
Posting Yak Master

133 Posts

Posted - 2008-09-12 : 13:29:00

hello,

I have a stored procedure,that returns me two columns.

here is my SP

ALTER PROCEDURE [dbo].[sp_GetNewSchema]
(

@TOCHSLevel int,
@SiblingNumber int,
@TOCHeaderSchemaID int
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

Select TOCHSPrefixText,TOCHSCounterLabelText
From TOCHSCounterStyle tc,TOCHeaderSchema th ,TOCHSElement t
Where tc.TOCHSCounterStyleID=t.TOCHSCounterStyleID AND tc.TOCHSCounterStyleID=th.TOCHeaderSchemaID AND TOCHSLevel=@TOCHSLevel AND TOCHSCounterNumber=@SiblingNumber AND th.TOCHeaderSchemaID=@TOCHeaderSchemaID;

END

AND it gives result as
TOCHSPrefixText TOCHSCounterLabelText
aba A

but I want output as aba.A

please help me how shall I do this.

Thank You

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-12 : 13:33:50

Select TOCHSPrefixText + '.' + TOCHSCounterLabelText

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

bluestar
Posting Yak Master

133 Posts

Posted - 2008-09-12 : 14:11:16

thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources