Use an independant and safe date format and make sure you read closely through this article:

http://www.karaszi.com/SQLServer/info_datetime.asp

Check out http://www.sommarskog.se

There you find two articles about error handling in SQL Server.

What about

DECLARE @a DATETIME, @b-2 DATETIME

SELECT @a = GETDATE()-2, @b-2 = GETDATE()-1

SELECT *

  FROM dbo.MAINB

 WHERE tarih >= CAST(SUBSTRING(CAST(@a AS BINARY(8)),1,4) + 0x107AC00...

U know this? http://www.replicationanswers.com/

Look up EXISTS() in BOL. U'll see where u r wrong.

U might use this as start for a dynamic sql

create table a (c1 int)

insert into a select 1

union all select 2

union all select 3

union all select 4

union all select...

http://www.dbforums.com/f81

Next SQL will contain OLAP function ROW_NUMBER()

Performancewise this sounds good noeld 

Thank u for explanation.

I see, but u need another column for AVG, don't u?

I if understand you right, would feel this is redundant data. Which is not to keep. Why you want to do so?

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx