Viewing 15 posts - 1,906 through 1,920 (of 2,452 total)
well....one limitation is going to be the max number of rows you can have in an excel worksheet.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 2:03 am
what is the task ?
without that information, the only answer I can think of is "it depends"
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 1:47 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 11, 2012 at 1:34 am
GilaMonster (3/10/2012)
In testing several people have. Yes, they can be.Look up Joseph Sack's blog post on them.
interesting article from the blog on performance
Thanks Gail
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 10, 2012 at 12:54 pm
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)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 9, 2012 at 6:18 am
where does "bala" in the datas column originate?
likewise all the other details
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 8, 2012 at 12:35 pm
MS SQL TableDiff utility might be worth considering
http://msdn.microsoft.com/en-us/library/ms162843.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 7, 2012 at 1:15 pm
siva 20997 (3/6/2012)
yes I have but I dont know how to get the stats etcI get your point.
I will try
cut and paste the code into a SSMS query window...suggest you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 3:41 pm
siva 20997 (3/6/2012)
I think then it will half in time
If it did that i...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 3:26 pm
Some food for thought.......
100M row table (100 MILLION)
SQL2008R2 12GB RAM
SELECT TOP 100000000 ---- 100 MILLION rows .....
ID = IDENTITY(INT, 1, 1),
igroup =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 2:57 pm
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,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 1:28 pm
take a look here....a relatively simple starter
http://msdn.microsoft.com/en-us/library/ms175669.aspx
hope it helps
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 12:14 pm
WendellB (3/6/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 11:53 am
siva 20997 (3/6/2012)
However there was a topic few days back and that was my first time on this...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 11:48 am
have you considered using Access "run time" for you app?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 6, 2012 at 11:35 am
Viewing 15 posts - 1,906 through 1,920 (of 2,452 total)