Billing Statement

I don't want to insert the statement in a script and run it. I want to type the sql statement in my admin box and run it, just as you would type a staement in the SQL box in phpMyAdmin. Thanks.

Hi Ques,

PHPMyAdmin is for MySQL, not Microsoft Access.

That being said, it's easy to show all your tables. When you log in to PHPMyAdmin, click on the database you're interested in, then the next table is a list of all tables in the database.

Best regards,

subexpression

Write a SQL statement to display the repeated rows of the table below:
Field Type Null Key Default Extra
doc_id varchar(1000) NO PARTIAL NO
topic_id varchar(45) NO PARTIAL NO
doc_headline text NO NO NO
doc_text text NO NO NO

Ok, I will assume that 'topic_id' is the criteria for determining if the row is repeated (i.e. topic_id is the same on two or more items).

I am giving you a generic way of dealing with the problem. You can adjust the query by changing the column name if the semantics of "repeated" are different:

SELECT topic_id, count(topic_id) FROM documents
GROUP BY topic_id
HAVING count(topic_id) > 1

I'm making a query that uses some columns for a WHERE condition but does not need to be displayed in the results, do these columns need to be in the SELECT statement? The table they are in is in the FROM statement.

>do these columns need to be in the SELECT statement?

No, this does not be required.

I'm meaning to delete the history of the purchases being made even though its still being deducted from your account before the credit card company sends it to you on a bank statement.

No, you cannot hide information from being printed on your statement that is mailed to you. It will always be there. If you need to hide where you've been spending your money from someone, then you should not be spending it there to begin with. Pay cash if you do not want to be held accountable to someone else for your purchases.

Will the excception work if defined in the exception section , once the update fails.
What about insert and delete operation? If insert, delete also fail and if the exception is there then will the exception will work??

vista?

I am trying to do a query on a DB that may not have been designed very well. Essentially the table has the following fields

PartType1
PartType1Price
PartType2
PartType2Price

What I want to do is essentially do a join of the four fields and then a group statement. I can do joins between two different tables, but is there something that can be done with items in the same table?

Lets say the table name is called parts
Select * from parts a
inner join parts b
on a.PartType1=b.PartType2

you only have to use alias

My internet research tells me to shred monthly and quarterly statements after I've reconciled them with my year-end statement but my financial institution doesn't send year-end statements. Should I keep the quarterlies? If so, for how many years back?

Keep the statements where you purchased stock until 7 years after you file your taxes for the year that you finally sell it. You will need to know how much you paid for the stock for your tax return for the year you sell it, and then keep it for 7 years after that.

I made a written statement to an investigator 4 months ago about a friend of mine who was doing some identity theft as she called it. I wasn't the main person and i havn't been called to any of the court date for him unlike the other person who is basically the main witness. I would like to retract the statement because i really remember what was going on truely and i could rather not have nothing to do with it. It's been 4 months and i've moved on with my life. So i'm trying to see how do i get the statement just removed?

So you made a statement to an investigator without an attorney I assume. This mistake is more common than oxygen it seems.

Without going through major legal contortions, you probably cannot withdraw the statement.

Many investigators are experts at cajoling, begging and threatening (and many unethical ones are also experts at lying). So don't feel too badly about it.

Actual small business owners (past or present) only…

Right now, I'm in the beginning phases of starting a small business. I want to know how many entreprenuers think a mission statement is very important to their success. I have a bachelors degree in Finance from a respected school so we did discuss them but I still remain unconvinced of the mission statements importance. I already made one for my business in like 10 minutes. Personally, I find people who really highly value mission statements as yesmen (or yeswomen) who are probably happier in the corporate world anyways. What's your take?
To No One Answerer…good point on the fact that Wal Mart and Ikea got one.

If curious, my business is to acquire and rehab abandoned commerical centers in urban areas and turn them into indoor flea markets (aka bazaars) and ballrooms and banquet halls. The actual business won't be up and running til Summer of '08. Here's my mission statement I came up with…"a company dedicated to the revitalization of urban properties to enhance neighborhoods and strengthen communities through the power of local commerce. "

Very. If you're not basing on a founding principle. You're not going to get very much done for your employees won't know what the company is about. Communication couldn't be more important than in business. It's almost like the military. You set an objective, and then you carry it out, or if it becomes compromised, you set another set of orders middrift and you continue until your objectives are complete. Without a mission statement that type of "company purpose" idea is only a gray area, and the job becomes less motivational, and somewhat less professional, to the employees, who will then only do their jobs as a 9-5 drudgery, instead of feeling true purpose as if they're making a difference by doing their jobs, helping people and bettering the world, which is a natural feeling that people like to have about their employment. Besides Ikea, Wal-mart, and Microsoft have mission statements, and that to me is more than enough reason to have one myself.

Also , what is the difference between statements that can and cannot be studied "experimentally"?

Statement 1:

When an apple falls out of a tree it falls to the ground

This can be studied scientifically

Statement 2:

There is a God

This cannot be studied scientifically

hope that helps