Archive for March, 2010

Employment Tribunal - shall i provide my colleague evidence of my own statement?

March 15, 2010 - 9:31 am 3 Comments

My colleague and I are taking a big Organization to an Employment Tribunal - I was the second in charge and have lots of emails and documents etc…
My court case is soon and hers another few weeks later - she has gone with a Tribunal Online and they are wanting my statement and in contact with the organization - would I be a fool to send it - after all this is my statement - not sure if this is Right - or is this under handed

Ask your solicitor / lawyer. Going to court against a big company you should have a lawyer. The request is not underhanded. Her representation online is about her best interest. Not that it is meant to under mind your case.

Will the Army PCS me if I have 1yr 2months left am married and sign a DEC statement?

March 13, 2010 - 9:34 am 1 Comment

I am currently deployed I will be getting back in november and have orders to pcs in feb 2011. By that time I will have 1 year and 2 months left on my contract I want to ETS. I am thinking about signing a DEC statement to get out of it. I am married, What is the possibility that the army will pcs me even though I sign the DEC statement?

your marital status means nothing. if they want you to PCS for 14 months.. you WILL with or without a DEC statement.

C++ HELP!! DO WHILE LOOPS with IF statements?

March 11, 2010 - 6:12 am 3 Comments

I’ve been trying to do this homework but i still dont get it. Can anyone help me i really appreciate it!

Write a simple calculator program. Ask the user if s/he wants to add (’+') subtract (’-'), multiply (’*') or divide (’/') and then ask for the number. Perform the operation with the given number. Start the "display" at zero. Stop when the user enters ‘X’ (for exit). must use a Do..While loop and "if" statements.

Best one is the While loop

AS400 CREATE VIEW - how can I retrieve the SQL statement used to create a VIEW?

March 9, 2010 - 5:22 am 2 Comments

I have created many SQL VIEWs but the only way I have of maintaining a record of the SQL behind each logical view is to save the original create view SQL command in a txt document on my server. Can I query the AS400 somwehere to find the SQL behind a VIEW?

Thanks

http://search400.techtarget.com/tip/0,289483,sid3_gci1162160,00.html

What kind of person would make a statement like this: killed until dead?

March 9, 2010 - 5:21 am 16 Comments

If a person makes a statement that they want somebody: ‘killed until dead’ as if they don’t understand what other result would occur if a person is killed, does that mean they’re very young without the full understanding of consequences of actions? It scares me there might be children allowed online unsupervised to make violent statements and their mind might become as warped as those 10 year olds who killed James Bulger. Or could it be an adult who isn’t all there or just trying to get a reaction?

lol, sometimes its too easy on here…… I actually feel guilty sometimes for taking advantage of peoples gullability.

How do I write an SQL statement that outputs text along with a date?

March 7, 2010 - 8:09 am 3 Comments

I’m trying to write an SQL statement with the output as:
Day XXX of 2010

I can get the day number and the year with the following:
SELECT TO_CHAR(SYSDATE, ‘DDD YYYY’) as CurrDate
2 FROM DUAL;

But, how do I add the text, ‘Day’ and ‘of” to the output?

You should be able to splice the pieces together with string concatenation. Assuming this is Oracle, you use the really odd choice of || as the string concat operator.
Since you want text between the day and year part, you’ll need to break up the call to sysdate.

This should be close (don’t have Oracle handy to test it):
SELECT ‘DAY’ || TO_CHAR(SYSDATE, ‘DDD’) || ‘ of ‘ || TO_CHAR(SYSDATE, ‘YYYY’)
as CurrDate
FROM DUAL;

How to write a priority encoder code for VHDL using a loop statement?

March 7, 2010 - 8:08 am 1 Comment

I wrote a code using an IF statement, now i have to write it using a loop statement
——————————————–
library ieee;
use ieee.std_logic_1164.all;
———————————————
entity priorityencoder is
port ( d: IN BIT_VECTOR(7 downto 0);
q: OUT INTEGER RANGE 0 to 7);
end priorityencoder;
———————————————-
ARCHITECTURE a OF priorityencoder IS
BEGIN
PROCESS (d)
BEGIN
IF (d(7)=’1′)THEN
q<=7;
ElSIF (d(6)=’1′)THEN
q<=6;
ElSIF (d(5)=’1′)THEN
q<=5;
ElSIF (d(4)=’1′)THEN
q<=4;
ElSIF (d(3)=’1′)THEN
q<=3;
ElSIF (d(2)=’1′)THEN
q<=2;
ElSIF (d(1)=’1′)THEN
q<=1;
ELSE
q<=0;
END IF;
END PROCESS;
END a;

You may contact a VHDL expert live at website like ijug.net ,etc .

Write a SQL statement to display all products having a quantity on hand greater than 0?

March 5, 2010 - 6:20 am 1 Comment


SELECT * FROM products WHERE quantity_on_hand > 0

0 is not in quotes because numeric values should not be. Textual values should be surrounded with quotes e.g.

SELECT * FROM users WHERE username = ‘Alice’

Read the following statement about the 1040 Form and determine if it is True or False?

March 5, 2010 - 6:19 am 4 Comments

T or F Standard deductions are listed just above the total taxable income on the 1040 tax form.

false, exemption amount deduction is listed just above total taxable income

How to make an SQL statement about those who have not paid?

March 3, 2010 - 5:31 am 1 Comment

i need to find all those in the database who havn’t paid yet and they actual "paid" field is in the "itinerary" table. Would it be something along the lines of:

SELECT Paid
FROM Itinerary
WHERE people <> paid

Thanks

What is the data type of the ‘paid’ field?
If it is Boolean (true or false), the query will be:

SELECT people FROM itinerary WHERE paid=false;

If ‘paid’ field is a numeric field,
SELECT people FROM itinerary WHERE paid=0 or paid IS NULL;