Results 1 to 6 of 6

Thread: need help at sort become a parameter

Threaded View

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    need help at sort become a parameter

    Hi all,
    I have store procedure
    create proc select_test
    (@SubType varchar(50),
    @sort varchar(4)
    )
    AS
    ..................
    order by SampleYear @sort and I got error at @sort
    any hit??
    Thank you!
    ________
    Starcraft Replays
    Last edited by sql; 03-06-2011 at 01:51 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •