title: How to store Multiple value in a variable in Sql Server
body: <p>I have the following TSQL Statement:</p>
  
  <pre><code>declare @id1 int
  set  @id1 = (select o.OrderId from [Order] o where o.M_Order_Id=@id)      
  
  set @Message =  select om.Modifier_Id 
                  from [Order] o , Order_Modifiers om
                  where om.Order_Id=o.OrderId and om.Order_Id = @id1 
  </code></pre>
  
  <p>I have to fetch the data according to "OrderId". which is store in a varibale "@Id1", Here variable @id1 will Return more than 1 value. this code not able to read more than one value, How to read this value one by one via loop etc. i want to put this value in blow query for fetch the data.
  Thanks  </p>