Database

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,'')))

namespace PIEBALD.Lib.LibExt.Compress
{
  public static partial class LibExt
  { 
    public static string
    Compress
    (
      this string Victim
    )
    {
      System.Text.StringBuilder result = new System.Text.StringBuilder ( Victim.Length ) ;

      bool first = true ;

      for ( int i = 0 ; i < Victim.Length ; i++ )
      {
        if ( !System.Char.IsWhiteSpace ( Victim [ i ] ) )
        {
          result.Append ( Victim [ i ] ) ;

          first = true ;
        }
        else if ( first )
        {
          result.Append ( ' ' ) ;

          first = false ;
        }
      }

      return ( result.ToString() ) ;
    }
  }
}

CREATE ASSEMBLY Library FROM 'C:\bin\Library.Sql.dll'
GO
CREATE FUNCTION dbo.Compress(@Source NVARCHAR(MAX)) RETURNS NVARCHAR(MAX)
AS EXTERNAL NAME Library.[PIEBALD.Lib.LibExt.Compress.LibExt].Compress; 
GO

create table t (s sysname)
insert into t select 'this     is the reason                         that I did this.               '

	-- convert tabs to spaces
	update	t set s = replace(s, '	',' ')
	where	charindex('	', s) > 0

	-- now do the work.
	while 1=1
	begin
		update t
		set		s = substring(s, 1, charindex('  ', s, 1)-1) + ' ' + ltrim(substring(s,charindex('  ', s, 1), 8000))
		where	charindex('  ', s, 1) > 0

		if @@rowcount = 0
			break
	end

	select	s
	from	t

Roger Wright wrote:

Do they take up space, or are records compressed when fields are left empty