Database

Select max(X) from
(Select top 5 id as X from idTable order by id asc)t

Select min(X) from
(Select top 5 id as X from idTable order by id desc) t

declare @id_user1 as int
declare @id_user2 as int
declare @id_user3 as int

declare @sql nvarchar(2000)
declare @a int
set @a =1
while @a < 11
begin
 select @sql = 'set @id_user' + convert(varchar,@a) + ' = 1'
 exec (@sql)
 select @a = @a +1
end

DECLARE @table TABLE
( id INT, id_user varchar(200))

declare @i INT
Set @i = 1
While @i <= 10
BEGIN
	insert into @table(id, id_user)
	values(@i,'whatever' + cast(@i as varchar))
	Set @i = @i + 1
END
-- Test it:
Select * from @table

SELECT UserItemID, CostAverage,OnDate
FROM CostAverage ca1
where OnDate = (SELECT MAX(OnDate)
FROM CostAverage ca2 where ca2.UserItemID = ca1.UserItemID)

Where PATINDEX('%ramu was a good boy%', 'ramu was a good boy .he is studying in ngbs school .cultatta and he studies very well') !=0

declare @val as varchar (255)<br />
set @val='ramu was a good boy .he is studying in ngbs school .cultatta and he studies very well.'<br />
<br />
select charindex('ramu was a good boy',@val)

WHERE 0 < INSTR('ramu was a good boy .he is studying in ngbs school .cultatta and he studies very well', 
             'ramu was a good boy')