BlaQice

I have a Case Statement in MS Query SQL, and if the Case Statement variables are false, I would like to return the regular field value.

Ex - Case when database.table = 'A' then 'X' else 'query value' end

(where, A and X are the variables, and Query Value is the normal result

of the query)

I'm working on a project for a client that uses antiquated methods of data analysis. Basically, everything is in excel spreadsheets, whereas ideally an Access or SQL database would be more appropriate, especially for the large amount of data sets they're working with. At a minimum, if the Excel data was in a table I could link to these tables but the principals don't want to change their current processes at this time.

Should I export all of this data to a SharePoint List where I can enforce referential integrity and have the tables update automatically, or should I try to link directly to the Excel Workbooks?

Is it prudent to use Crystal Reports as a query tool?

Correct me if I'm wrong, but isn't it relatively simple to link an ODBC Server via ADO to Microsoft Access?

Specifically, someone created a presentation and linked the narration files rather than embedding them. I need to embed them.

I know people are very fearful, as they should be, with the current economy. But you have companies like Chevron, Exxon Mobile, and Google trading at 50% of book value, insane profit margins, and in some cases like $50 CASH per share?

I know I've been short many over-valued stocks for the past two years. But now, I'm seeing UNBELIEVABLE deals on international companies. My only fear is our dollar tanks. But it's up 25% as of late, go figure.

This wont last. This is how the rich get richer. Even if some of these companies cut earnings going forward by 50% they're still cheap on a relative basis. Especially those that pay 5 & 6% coupons.

This is Truly Amazing...

What can I possibly be overlooking?

Several months back when oil was $140 a barrel I stated that people will ultimately go to jail when the American Public realizes prices were being manipulated. At that time, most people on this blog claimed the demand justified and was coming from China and other emerging markets. Like the housing bubble I didn't believe it was sustainable especially after the Olympics were over and if Obama won the presidency. I thought oil should be half of what it was. Now, I believe it may even go to $40 if OPEC doesn't cut production again trying to prop up prices - which in itself is manipulation. I believe the fact oil is under $60 when demand since July is only off 20% is by definition, manipulation. Many of my friends believe redemptions are forcing hedge funds to sell oil to these levels.

What do you think?

My in-law and I have are having a huge debate and we just wanted to get your opinion.

He thinks, not only should we bail out the auto industry, but we don't have a choice. And, he just bought 10,000 shares of GM.

Me, on the other hand, have been short the auto industry - and other sectors of the market for over a year profiting handsomely. And, I believe that not only should we let them go bankrupt so they can get from under union contracts, pensions and health care issues so new management can come in and compete, but we have no choice. US automakers were failing miserably in 2005 at the auto market's peak, so why should we believe they will outperform with our tax dollars in this market with tight credit (if any), 40% less dealers and suppliers on the verge of bankruptcy when they couldn't do it then?

I think in two months max I will be up another 40% while my in-law's 30grand will be worth less than 10 grand, if not worthless.

Your opinion?

http://news.yahoo.com/s/ap/20081116/ap_on_bi_ge/me...

Leave it to Rush Limbaugh to say the votes were rigged.

DENIAL

So, what's the next phase? Anger?

Depression?

Checkers?

Bingo?

Maaaavrick...

my friend.

Am I wrong for suggesting my wife read the books of the presidential candidates in order to better understand her choice of candidate -and alternative - as well as opponent, before making a decision?

My wife: Asian-Immigrant, Democrat - Hillary Clinton

Me: African-Native American, Independent- Ron Paul

Over the past four months, I've asked my wife to read the books

of all the presidential candidates to better understand their perspective without the influence of biased media.

Hillary Clinton's - Living History

John McCain's - Why Courage Matters

Barack Obama's - The Audacity of Hope

and

Ron Paul's - The Revolution: A Manifesto

Please give your answer, whether you've read the books and any other comments.

Thank you.

http://www.myfoxdetroit.com/myfox/pages/Home/Detai...

http://www.youtube.com/watch?v=ssAmDNmNw68

http://www.youtube.com/watch?v=8fD0rmKOio4

Grosse Pointe Farms woman denies Halloween candy to children of Obama supporters.

http://www.freep.com/article/20081101/NEWS02/81101...

My thoughts: Dialogue and constructive criticism is always good. Always has been. In the past, if we disagreed, we let out vote speak volumes.

But, IMHO the divisiveness of this election is clearly prejudicial. NEVER has such ignorance been on public display.

Yes, I'm a registered Republican, soon to be Independent, who originally supported Ron Paul, but will be voting for "that one"

My asian wife, is Democrat, who originally supported Hillary but will also be supporting "Barack 'who's sane' Obama." Although we respect her decision, her sister who is for McCain/Palin, has now "disowned" us because we're exercising our right to choose.

::poping champagne::

My question is simple. After, Hoover, Carter, Nixon, Roosevelt... and a list of very poor presidents. WHY are people so vehemently, nasty and violently opposed to Obama?

Also a republican, soon to be Independent, I for one agree with Powell.

Americans in general seem to forget EVERYONE is entitled to their opinion, and that should be respected. However, many don't have the tolerance to be nonviolently disagreeable.

The attacks against Palin were irresponsible. The attacks against Obama are just down right racist ignorance. I still believe Ron Paul is the best candidate for the job, but now I will be giving my vote to "That One!"

http://www.youtube.com/watch?v=lNzA9LfMlmU

http://www.truthdig.com/avbooth/item/20081018_what...

He wants to introduce a new proposal today to lower capital gains tax. huh? The only people who have capital gains are people who have short sold the market or bought commodities like the hedge funds who help put tens of American businesses out of business.

When these states had huge property tax revenues from inflated home values their profits were privatized and people in placed like Texas and Ohio never benefited. Now they have a deficit they want their losses socialized forcing citizens of states like Ohio and Texas to pay.

My thoughts. Crisis is ALWAYS the father of efficiency.

I say suffer and reduce the size of your state government.

I personally don't want my tax dollars going

to support illegal immigrants education and medical

benefits that I have to pay for and they get free at my expense

in addition to massive corporate and government malfeasance.

Your thoughts?

http://www.youtube.com/watch?v=fGav4rrwlO8&feature...

LOL

just spreading some laughter in light of all the decisiveness these days.

So, Today Uncle Sam picks the pockets of all those who saved and acted responsibly and gives it to those who acted irresponsibly... (who said you can't have your cake and eat it too... oops, you ate your cake and Uncle Sam, took mine and gave it to you too)

So, the stock market should Soar?! NOT!

Dow 9000 here we come...

Hyperinflation, we'll be there in a minute...

So, if I can't pay my mortgage and bills, I should be able to do like the gov'ment and just print some money.

In the immortal words of Snoop Doggy Dogg

"Welcome to Death Row"

Apparently so. Many Americans ate their cake...

and now those of us who saved ours are being forced by

the government to share ours.

No bailouts! $#&*@#

-behind the scenes long treasuries are down to .5% yields

(how absurd)

-mutual fund redemption's for the month (not quarter) are $74 Billion

(and counting)

-hedge fund redemption's for the quarter will approach half a trillion.

(the number's so large they're still counting)

(half of which were redeemed in just the last three weeks)

... but, for the longs Warren Buffett's buying. Should you be?

I think Congress is NOT going to pass the modified bill. And, of course the market will crash and I'll make another 20grand or so. I think many people are coming to grips with what we are headed for...

(to use an analogy) and finally realize Tom Brady is out for the season

and to put him back in next week would be a mistake. (comprende'?)

The only people voting for the bill are the people with something to gain like Obama... or those who were telling you the economy's sound just two weeks ago, like Bush and McCain.

Anyone feel the "standing on principles" is a little counter-intuitive?

Why are you for or against the "bailouts" or what really should be called "investment in America?"