Passing Multiple Values to a parameter

• Mohsin Mohammed Abdul

  Grasshopper

  Points: 14

  More actions

  November 28, 2005 at 2:02 am

  #169625

  Hi,

  I have a situation where in I got to pass more than one value to a single parameter like I want to see all the employees of department 5,6 & 7 & so on, my query goes like this "Select firstname,lastname, title from employees where departmentid=@departmentid". In this variable @deparmentid I need to pass more than one value. is it possible? if it can, dude's pull it fast to me.

• SteveHall

  SSChasing Mays

  Points: 633

  More actions

  November 28, 2005 at 5:19 am

  #606044

  This problem appears regularly and so there are a number of postings about it here and elsewhere.

   

  If I recall correctly I used the solution from http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=225048.

  Another posting is http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=210413, there is one fairly simple solution in that as well as a couple that are more 'interesting'.

   

   

  Steve.