Hi kshitij kumar,

It is a server and it doesn't have extra space to load in any other drived.

and Ajay, it iz a server in australia so we cannot reinstall sql...

Hi Ajay,

That is a server and we can not do quick format over there. We don't have the permission to do so.

Thanks

REgards

Viji

Hi Sakthi,

Thanks for your early reply.

I've checked those places. But there is no symtom of occupying that much space anywhere.

no other big files are there in the server. ...

HI,

Thanks for your reply.

It doesn't take much time when it runs from SQL Server.

My doubt is when we are in a testing environment how to avoid this kind of errors...

Hi,

In the front end they are getting IndexOutOfRangeException

TimeOutExpired. The time out period elapsed to completion of the operation or the server is not responding

and Sometimes they are not able to...

Hi Steve,

You have done a great help to me.

Thanks a lot.

Regards

Viji

gr8 it works

thanks a lot Mr. Mark

Viji

Hi,

check the following link for changing rows into cols

http://www.tsqltutorials.com/pivot.php

regards

viji

Thanks Mr. Jack Corbett and Mr.Jacob Sebastian,

I understood the error and used Mr. Jacob's code.

and its working fine.

Thanks,

Regards,

Viji

Hi Mr.Will,

thanks.

but i tried with quotes also. Its giving the same error. 🙁

regards

viji

Thanks Mr. Jim,

right now i've planned a product table with fields like

hierarchyid(FK), level1,level2,level3.....

then a hierarchy mapping table where it stores the meaning like --

hierarchyid(PK), level1-brand,level2-size, level3-category etc.

next record could...

Hi,

nice idea!!

i'll try it out.

regards

viji

Thanks,

I'll try it.

Regards

Viji

Thanks for your reply & links. they are highly useful.

i'm expecting kind of 'plan' documents how to approach SSAS project. what are the things you should make ready like...

Hi Vyas & Vijay,

Thank you so much for your help

Regards

Viji