Post reply

Add manual result to query

  • March 2, 2012 at 8:06 am

    #391709

    Hi all,

    Is there a way to manually script in a result to a query.

    Say i have a table

    create table cats (

    id int identity (1,1)

    ,name varchar (50)

    )

    insert into cats (name)

    values ('Manual'),

    ('Online')

    and i wanted to get the result 'Refund' to the list of results

    select name

    from cats

    and get

    Manual

    Online

    Refund

    Thanks for any help

    S

  • March 2, 2012 at 8:09 am

    #1454198

    select

    name

    from

    cats

    union

    select

    'refund'

    something like this?

    also isn't this the same as this post here, if so there is no need to cross post

  • March 2, 2012 at 8:32 am

    #1454225

    Hi Anthony,

    and thank you.. thought it would be simple.. (my skills are clearly shocking :/)

    and yes in way but not fully. Im trying to work out how to do something in SSRS and think this could resolve it.

    Ill try it now and if it works ill update the other post.

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

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