create TABLE #temp(LoadTemp1 int,LoadTemp2 int,LoadTemp3 int,LoadTemp4 int,[TimeStamp] datetime)

INSERT INTO #temp VALUES

(300, 200, 100, 320, '12-10-2013 13:30:29'),

(100, 250, 113, 340, '12-10-2013 14:20:12'),

(114, 339, 209, 345, '12-10-2013 14:45:01')

declare @Threshold int =...

try this...

Declare @mydt datetime

set @mydt='2012-02-01';

select @mydt,Condition from #TestTable

where Condition='Yes' and @mydt between StartDate and EndDate

u can refer mr.jeff post for creating #TestTable...

🙂

select

{[Measures].[Time Entry Hours]} ON COLUMNS ,

{[time].[fiscal trans date].[fiscal trans date].ALLMEMBERS} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME on rows

from [sa]

try this..