Post reply

SELECT @Param as StaffName, Field1,Field2 FROM Table

  • July 23, 2007 at 8:14 am

    #177674

    SELECT @Param as StaffName, Field1,Field2 FROM Table
     
    I want to include as part of my output in a SP - the text contained in a nvarchar(50) parameter.
     
    So If @Param = 'this is what is says'
     
    The first field of my data results would contain this is what is says for evey record.
     
    Can anyone help me get the syntax for this??
     
    Thanks

  • July 23, 2007 at 8:38 am

    #721537

    You already have the right syntax for it.

  • July 23, 2007 at 8:55 am

    #721540

    Sorry yes - I had it OK to begin with, I was getting a syntax error - but it was to do with the way I was passing the parameter in rather than how I was SELECTING it out.
     
    Thanks!

  • July 23, 2007 at 9:32 am

    #721551

    .  Thos error message are misleading sometimes .

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

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