title: Picking out several lines from a table SQL server management
body: <p>Im very new to SQL Server. I'm trying to create a stored procedure that gets me some lines that im asking for. This is datatable i have:
  <a href="https://i.stack.imgur.com/XiOZX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XiOZX.png" alt="Datatable"></a></p>
  
  <p>So let's say i would like to show all the vehicles that has TMS1 and Identifier 88 and 89. What should i write? For the moment i have the code </p>
  
  <pre><code>ALTER Procedure [db_ddladmin].[spGetVehicles]@ECU nvarchar(20),
  
  
  @Identifier nvarchar(20)
    as
    Begin 
    Select * FROM db_ddladmin.View_VehicleReadouts where ECU = @ECU and Identifier = @Identifier
    End
  
    exec [db_ddladmin].[spGetVehicles] 'EBS7', '91'
  </code></pre>
  
  <p>This gives me all the vehicles with ECU EBS7 and identifier 91. Let's sat i would identifier 90 also with ECU EBS7. What should i write? I could use an OR statement but that would give me duplicate vehicles which i don't want. </p>