Thank you. That helps!! 🙂

Hi,

we have around 2000 products and there will be more coming.

--But I found a soln pls let me know if it is feasible.

I added new column called rowid of datatype...

Brain,

I apologize. Hope this reply will make ur monday gr8.

Structure of Table

ProductTable

(

ProductID int,

ProductName varchar(20),

ProductDesc varchar(50),

PartNo Varchar(5),

...

Brain..

Thanks for Response..

Here is the example..

Version Table where we store the Version.

Ours is a product respository project and every 15 days we refresh all the table data.

The new requirement is...

Hi,

As I mentioned, we import the resultset of these SPs into Excel. But the columns that we display in each and every worksheet are dynamic. So, we are trying to...

Jeff,

thanks for your alert. We are making sure that none of the functions will not fail after the conversion.

But will you suggest me anything to get out of this...

Hi

We have list of 50 sps that need to be executed and export the results into excel and each worksheet contains resultset of one sp.

we use these sps from asp.net...