Please post the table structre with sample data. Anyway i have created it for you.

create table price

(

p_id varchar(10),

qty int,

nou int

)

go

insert into price

select 'a001',1,2

union all

select 'a001',2,3

union all

select 'a001',3,5

union all

select 'a001',2,4

union all

select...

I have tested the same query in sybase 12.5.3 and oracle 10g.

SYBASE is sorting the result based on the expression.

ORACLE is not sorting the result based on the expression.

is the...

A little modification in Jeff's code.

SELECT DateName(mm,DATEADD(mm,MonthNumber,-1))

thomyes,

if you need help from here, post the table structure with sample data. I am sure you will get some good replies from this forum.

are you going to store...

Hi All,

A small modification in the requirement. Earlier we showed if user has selected 'Monday' then we will populate previous week's

start date and end date . Now...

I am looking for some other workaround to do the same. So that i can get extend my knowledge.

I have tested the execution time of the query.

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server parse and compile time:...

Going little

I have written the below query to get the expected result.

Declare @MinDate datetime,@MaxDate datetime

select @MinDate = min(dt) from t_date

select @MaxDate = max(dt) from t_date

SELECT x.full_dt,t.dt,datename(dw,x.full_dt),case when Holiday_dt is null...

Meantime i have witten the below query to identify the missing date.

Declare @MinDate datetime,@MaxDate datetime

select @MinDate = min(dt) from t_date

select @MaxDate = max(dt) from t_date

SELECT x.full_dt,t.dt

FROM t_date t right...

ALL TYPES.

Any inputs?

Yes. It is interesting.

I have also tested the query plan.

#1 query ordering is done based on the expression.

#2 query ordering is done based on the column.

Yes. I got it.Thanks a lot.

So shall we order the string function based on their performance as below?

The order is like fastest,faster,fast,good,normal.

1) LEN()

2)...

Jeff,

Yes.

Result on my box is here.

SQL Server Execution Times:

CPU time = 16967 ms, elapsed time = 0 ms.

==================== No Mod's (Baseline) ====================

SQL Server Execution Times:

...

I have also tested the below query.

SELECT CONVERT(DATETIME,CONVERT(CHAR(8),DATE_TIME))

FROM TBL

Test1:

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 0 ms.

(110000 row(s) affected)

Table 'TBL'....