amishraa

The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all …

Hello, What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only …

My apologies for posting Teradata question on MS SQL thread due to there not being one for TD. I am trying to get last 3 months of data but running across an error using month(current date - interval '3' month) because it uses current date to determine previous months and …

Is there a way to get a total counts from the resultset of two unions? This will be for DB2. select count(*) from ( select count(*) from xyz where abc='1' union all select count(*) from x1y1z1 where abc='1' )

How do I get average of the duration for multiple weeks. Currently I get something like Student Avg completion time Week Year STUDENT 1 0 1 2013 STUDENT 1 5 1 2013 What I want is Student Avg completion time Week Year STUDENT 1 2.5 1 2013 <code> select a.student,avg(a.duration) …

The idea is to check whether if phone number already exists(data table). If the number exists, then it will create a new row under another table(output table) with the customer ID for that customer. Table data is where pre-loaded phone numbers are stored. Table input is the table where feed …

Is there a workaround to this as decode does not seem to allow the use of greater than equal sign I am trying to show the comment for any days beyond 4 days, not just 4 days. [CODE] decode(shipdate-orderdate,'4','This is unsatisfactory!') comments from orders [/CODE] Thanks in advance! :)

Slight problem when embedding HTML inside PHP. Problem #1 logon php page contains the form for user to login. With successful login, it brings up the user to the resume page. In order to maintain the uniform design throughout all the pages on the site, the logon page contains the …

' Why don't you declare a new variable for the total of all the 4th textbox totals [CODE]Dim totalhoursInteger As Integer[/CODE] totalhoursInteger += the value on 4th textbox Is this something closer to what you may be trying to accomplish?

[B]Create a project that contains a Pet class. Each object will contain pet name, animal type, breed and color. The form should contain text boxes to enter the information for the pets. A button or menu item should display the pet information on a separate form. Hint: Use a ReadOnly …

So I have calculated the total of students on all of their 6 grades but now I want to be able to calculate the average of all the grades and list the averages next to the total column. Any help would be greatly appreciated! [CODE] //preprocessor directive #include<iostream> #include<iomanip> #include<fstream> …

[QUOTE=Clinton Portis;1072988]I wish you luck on your endeavors.[/QUOTE] lol good one. It's amazing how people come here expecting for others to do their homeworks for them. :)

Need help with calculating student grades using arrays. If I have the names and subsequent grades listed on notepad input file. eg. Name1 23 43 54 23 43 54 Name2 54 34 65 76 23 54 Name3 97 68 45 68 86 58 How do I setup two dimensional array …

No offense but have you read the book? and perhaps it could show you how to do exactly that. If you have specific part where you are stuck, that is not obvious, please feel free to come back. :)

Can someone please copy/paste the following source and look at the error message? I am receiving too few arguements to function error. Please help! //preprocessor directive #include<iostream> #include<fstream> #include<iomanip> using namespace std; //global variables/constants, function prototypes void headerfn(); // void fn without parameters void namefn(string fname, string lname); // void …

the char character for grade are coming up with weird ascii like characters instead of the letter grades. Please help! //declaration string first, last; int prog1, prog2,prog3,prog4, prog5, test1, test2; int totalpts, progavg, testavg, courseavg; char grade; //executables totalpts = (prog1+prog2+prog3+prog4+prog5+test1+test2); progavg = (prog1+prog2+prog3+prog4+prog5)/5; testavg = (test1+test2)/2; courseavg = (progavg+testavg)/2; …