well....one limitation is going to be the max number of rows you can have in an excel worksheet.

what is the task ?

without that information, the only answer I can think of is "it depends"

my first thoughts are to split the string, then use something like FOR XML path to rebuild.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

where are these strings coming from....are you generating them?...in which case it would be...

interesting article from the blog on performance

http://www.sqlskills.com/blogs/joe/post/Comparing-Query-Performance-when-using-an-e2809cideale2809d-Nonclustered-Index-versus-Columnstore-Index.aspx

Thanks Gail

if you are looking for a web browser interface

take a look at http://www.kyubit.com/

I dont use it, nor am I in any way associated with it, but I did evaluate(briefly)...

where does "bala" in the datas column originate?

likewise all the other details

MS SQL TableDiff utility might be worth considering

http://msdn.microsoft.com/en-us/library/ms162843.aspx

cut and paste the code into a SSMS query window...suggest you...

siva 20997 (3/6/2012)

---

What I would like to know Livingstone is if everything imroves if we take the UNION out

I think then it will half in time

If it did that i...

Some food for thought.......

100M row table (100 MILLION)

SQL2008R2 12GB RAM

SELECT TOP 100000000 ---- 100 MILLION rows .....

ID = IDENTITY(INT, 1, 1),

igroup =...

here is one article that may give you ideas

http://www.sqlservercentral.com/Forums/Topic153606-203-1.aspx

read the discussion that follows (link is at bottom of article)

here is one method for working days in the month

SELECT DATE,

...

take a look here....a relatively simple starter

http://msdn.microsoft.com/en-us/library/ms175669.aspx

hope it helps

kind regards

WendellB (3/6/2012)

---

You are sort between a rock and a hard place with 2003. The Lebans code is quite different from the export process that was introduced in 2007 and...

siva 20997 (3/6/2012)

---

yes I have read it quickly but will read it at leisure sometime

However there was a topic few days back and that was my first time on this...

have you considered using Access "run time" for you app?