Database

SELECT  TheDate, TYPE, Value
FROM    (
        SELECT TheDate, Type, Value, Rank( ) OVER (PARTITION BY Type ORDER BY TheDate DESC NULLS LAST) RN
        FROM MyTable
        )
WHERE   RN = 1

select distinct
(select top 1 t2.thedate from MyTable as t2 where t2.[type]=t1.[type] order by t2.thedate desc) as thedate
, t1.[type]
,(select top 1 t2.value from MyTable as t2 where t2.[type]=t1.[type] order by t2.thedate desc) as [Value]
from MyTable as t1
order by t1.[type]

select Value
      ,Type
  from TABLE
 where TheDate in ( select MAX(TheDate)
                      from Table
                     group by Type
                  )
;

MikeDhaan wrote:

and not the max date per type

select date
      ,type
      ,value
  from table t
      , ( select max(date) max_date
                ,type type
            from Table 
           group by type
        ) tg
 where t.date = tg.max_date
   and t.type = tg.type
order by type
;

SELECT MAX(TheDate), Type, Value FROM MyTable GROUP BY Type, Value

datadir="F:/ProgramData/MySQL/MySQL Server 5.5/Data/"

datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data2/"

jrahma wrote:

what should I do now?

Bastard Programmer from Hell

declare @query as nvarchar(max)
set @query = 'select * from mytable '


if(@ParameterValueIS = 1)
begin
set @query  = @query  +' where id=1'
end


if(@ParameterValueIS = 2)
begin
set @query  = @query  +' where id=2'
end


exec (@query)

mehrdadov wrote:

I'm looking for a solution that let me depend on the situations make my select query with or without joins.

Bastard Programmer from Hell

mehrdadov wrote:

this is simple but when I have many situation and more tables to join it grows a
lot.

declare @NewLine char(2)
set @NewLine=char(13)+char(10)

select  rtrim(ltrim(Replace('This
is the 
 
reason that i did this>> ',@NewLine,'')))