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 …

Hi all! I am making a TimeCard application and I got stucked.. Anyway, the program looks like this: the user inserts date,start hour and finnish hour into 3 textboxes. On the fourth textbox it will show how many hours he has spent. I am using StreamWriter to save the data …

[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> …

hi!!i need help.Write a program, building a function that finds the surface, diameter and perimeter of a circle.I need it for tomorrow

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 …

Hey guys, Im still new to programming and need help with something. I need to read a line of numbers from a text file into an array. I will be given this in a text file and need to store them in an array for later use. 0 1 2 …

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; …