Database

pashitech wrote:

use the out put of the first SP

pashitech wrote:

make it to a order

Select * from tblMovies where MovieName = 'Black'

Select * from tblMovies where MovieName Like 'Black%'

Select * from tblMovies where MovieName like '%Black%'

create table #temp1 (
  --list of columns returned by Movie_SP goes here
  )
insert into #temp1
  exec Movie_SP @Param1, Param2, ...
select * from #temp1
  order by case
    when Title = 'Black' then 'A'
    when Title LIKE 'Black %' then 'B'
    else 'C'
    end,
    Title

select @room_code = @room_code + '%'

select count(room_code) from rooms where room_code like @room_code

DECLARE @building_name NVARCHAR(100)
SELECT @building_name = 'Test'
-- The lines above are just a sample to get you started. Move this into a stored procedure and use
-- the code below to do the actual work. Note that you would want to determine whether or not
-- @building_name ended in a % before using this code.
SELECT @building_name = @building_name + '%'

SELECT collapsed_building.b_name,collapsed_building.b_desc FROM collapsed_building WHERE collapsed_building.b_name LIKE @building_name

string q = string.Format("SELECT collapsed_building.b_name,
collapsed_building.b_desc FROM collapsed_building 
WHERE collapsed_building.b_name LIKE '%{0}%'", crimewithdate.text2);