Recent content by cory1

You're right, I left out the dbo_employee, it is in the code, just omitted from here. That is where I am having trouble is coding the join. I had the tables joined like this and kept getting an error. INNER JOIN dbo_time ON dbo_time.project_id = dbo_project_hours.Hours I am a bit of a noob...

SELECT dbo_client.client_name, dbo_project.project_name, dbo_time.description, Sum(CLng((CDbl([service_end])-CDbl([service_start]))*96)/4) AS Hours FROM dbo_client, dbo_project, dbo_time, dbo_project_hours WHERE dbo_employee.employee_id = '9'; That is what I have so far. the junk in the middle...

I should add that dbo_client and dbo project both contain client_id. dbo_time and dbo_project both contain project_id, dbo_project_hours contains project_id.

I have a report to show dbo_client.client_name, dbo.project.project_name, dbo_time.description, and dbo_project_hours.Hours. To the right of the periods are the tables and to the left is the column that I need displayed. I am having a tough time with this join. Can anyone help me out? Thanks...

Yes in a managed C++ application.

I am using .NET and am having trouble formatting a double variable to the console window with two decimal places. I don't need to round the numbers because all of the values are no more than two decimal places long (ie 1.5, 1.55, 1) I tried using the old way with "cout" with no luck...

I am having trouble compiling a program from the command line. I usually don't use the command line, but I would like to familiarize myself with it a little. I am trying to compile the file named "CppTextReader.cpp" and I am trying to pass the file "volcanoes.xml" to the...