ZurdoDev wrote:

Lasting joy and happiness comes through family. Without it, everything is about you and makes you very selfish which will not give you lasting joy.

It sooooooooooooo depends on said family. There are so many other ways to have inner peace, serenity and a sense of purpose.

ZurdoDev wrote:

No, it isn't at all. At moment of conception there is unique DNA. Period!

So DNA==Person? => false HumanDNA == Person? => false. By this logic my hair has lots of persons since it has DNA. Alos my skin, my fingernails... etc

for sure, you're not the only one. what bugs me is that some, maybe most(for sure not all) people when they say for instance #resist or whatever they think they are so wise and shit like that, and more often then not they are the same people that comment and share articles on various media based purely on the title. There were some tests done by various people one of them being Ryan Holiday that put many such fake articles on media and they got tons of shares and comments, but in the article there was nothing about the title of the article. Conclusion people just share and comment on stuff that they think will make them look better somehow, without even looking at the said article. I don;t know if I should laugh or cry. :)

Joe Woodbury wrote:

So, Excel does with one person what used to take several. Should every installation of Excel pay taxes? What about Outlook, which has reduced jobs for secretaries?

While true that those reduced the number of lets say accountants and secretaries on the upside they created an equally or bigger numbers of IT related jobs. As for the lawn, house, car... just think of all the people working to produce said cars, houses and so on. Bill was talking mainly about factories(I think) and the huge impact on labor. Just think of a plant that has say 2000 workers(around 650 per shift) that will get fully automated. Net result loss of 1800 jobs. Sure they will need some extra maintenance technicians and PLC engineers but the number of jobs created compared to the number lost is huge. Bottom line, I kinda agree with him. Not completely but more inclined in favor then against.

I didn't have enough but i created a dummy test table and the output is

"Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int."

So no it does not modify the underling field automatically.

Hy, Supose we have this:

SELECT SUM(ProdGood) as TotalProduced
From ProductionData

Now if ProdGood is defined as int(eger) will SUM(ProdGood) be also integer or will it go to BigInt if the SUM is lager than the largest int? Thanks in advance. Oh, I tried google but nothig relevant came out.

modified on Sunday, February 28, 2010 2:14 AM

It's all fixed now. I now know for a fact(tested) that even the

ORDER BY SUM(QualityData.NrOfDefects);

does not cause a recalculation.

thanks

Hy, I have something like this:

SELECT Code, SUM(QualityData.NrOfDefects) AS Defects
FROM QualityData
GROUP BY Code
ORDER BY SUM(QualityData.NrOfDefects);

The dilema is that

ORDER BY Defects

does not work and

ORDER BY SUM(QualityData.NrOfDefects);//causes a second SUM??

Is there a better way? Thanks