well!

Thanks, that was informative.

Now any idea on how to move it from one physical drive to another?

Any link for that 😀

Thanks in advance.

hey what do you mean by standard export feature. its normal export format when excel export is excel 2003!!!

what else do you want to know???

woww!

great!

that's a good and easy to implement work around!

Well, i have used both Sql Server 2005 and 2008 and by default, they export to excel 2003. If report has data more than 65535 rows, it gives error and...

Hello All,

any idea on this???

may be i am not competent enough (oh! i am sure i am not)

can you please tell me how can we use this stored procedure in some view? I don't...

hmmmm, ok ok guys!

please tell me how to get value of a "DYNAMIC" column from a table.

I am inputting column name whose value is to be selected into CLR. i...

ok, i have a table like this

create table (

id int,

colname varchar(255),

date smalldatetime);

i need to have some view where i could select id,colname,date and

Now tell me how can that...

it was just that i was not handling exceptions properly in CLR, like i was doing like

command.ExecuteScalar().toString()

but i was not handling what to do if "command.ExecuteScalar()" doesnt return any value.

Sorry guys!

that was my fault.

i didnt troubleshoot it well and finally figured out that it was not the UDF causing problem, it was something else.

Thanks again!

that was very helpful 🙂

Thanks all

Space is no issue.

i have windows on separate physical disk

i have log on RAID1 separate disk ( as far as i know, RAID1 is better for larger reads)

i have data...

Yes they are cool!

and actually, i am using similar ones, not exactly same but close to them, to do calculate changes once daily at night, when all new data is...

Guys!

Any idea?

Have i made the problem worse ?

i am sorry for missing that point out that there are hundreds of columns. i just posted two Data Columns just for simplicity, but forgot to mention the number of...