Sean: if you are talking about function then its not possible in my case.

i want through query only

Thank you all of you

sean: can you please elaborate what is dbo.DelimitedSplit8K?

here w will come after m,

i want w before m

so we need to put expression anyways its affect performance.

anyways thanx for your reply guys it will help me

thanks for your reply

i know its affect performance,

this is real world task, and i am not able to split it.

client want as it is so i need to provide...

thanks for your reply

but here i have lit bit tricky one

i have values

1d

1y

2d

3d

2w

3y

2m

3m

i need result

1d

2d

3d

2w

2m

3m

2y

Thanx a lot , it will help me.

my requirement is bit different but your query gave me idea how to reach that

once again thank you so much for your time...

Thanks for your reply,

rows > 10000

my requirement is very simple i need difference between each log time in minute.

when id is same and name is different then i need...

Thanks for reply guys

my select statement like

select order-id,order date,product name from orders

Basically i need like date hierarchy, when i pass startdate and enddate

day1=start date then from startdate to seven day...

Hi,

Pls find attached file and let me know changes.

Thanks.

for me some report come with proper formate and some time its add blank pages

i have same problem when i export report into pdf file its print blank page after one line. guys pls give me a solution. i am using sql 2008.

Thanks steve,

If possible then pls provide me code with small example.