Post reply

not able to view result of select statement

  • December 27, 2011 at 7:23 am

    #391207

    hi,

    I have one sp from that I took some select statements but when I try to execute those I'm not able to view result

    it just say's like sp executed and gives 'Command(s) completed successfully.'

    please help...

    trial code is :

    declare @Table VARCHAR(500)

    declare @CompositeId_New VARCHAR(500)

    declare @SourceId VARCHAR(500)

    --Modify the MultiSourceEntityMap to move from the current composite to the new composite

    SELECT DISTINCT

    @SourceId =

    Class.EntityType,

    @Table =

    Class.ClassId

    FROM

    Fireball_MetaData.dbo.Class Class

  • December 27, 2011 at 7:27 am

    #1425692

    With this select statement, you just set the values to your local variable. If you want it to output to screen then you will have to do

    SELECT @SourceId , @Table

    at the end of your stored proc

    -Roy

  • December 27, 2011 at 7:28 am

    #1425693

    Add another line in your stored procedure.

    SELECT @SourceId, @Table -- Assuming Main Query returns One Row

  • December 27, 2011 at 7:35 am

    #1425697

    I got it ... thank you 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply