Well, first you must build a difference machine...
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
Hi friends, i need to know how much space occupied by database with my data in sqlserver 2005.
to know this i did by right clicking on database and has seen it properties it showing nearly 2.4GB. But my database doesn;t contain that much data?
how can i know the exact size of my database?
1) Open a form
2) Switch into design view
3) In the upper left corner of the form you will find a small black square. Place your mouse on the square, right click and choose "Properties"
4) On the pop-up window, click on the "Data" tab and look at the "Record Source", this is where the form is getting its data. The data can be from a table, query or a query defined only for the current form.
i just wanna ask for suggestions.......for my project!!!
i haven't start it yet! i don't have any idea,"what topic that i can choose" please....help me!!!!!!!!!
i have knowledge about C/C++,Vb.6 and mySQL
I have a programming problem to split the total time spent on jobs into business hour and after hours
business hour 8:30 - 17:00
after hour 17:01 - 8:29
database is on sql server 2005, there are job_start_datetime and job_end_datetime columns hold the jobs start and end time, also a total_time_spent column hold the total of time spent on the job.
I have an order to split the time spent into business hour and after hours. I am creating 2 filed in the table to sperate these hours. but I am having problem to using Datediff to calculate amount of hour into 2 time frames.
You may want to consider storing your data differently so that it is easier and more flexible to manipulate.
For example, consider the following:
Start_Time End_Time Type Pay_Code
06:00 8:00 WORK OT1
8:00 10:00 WORK REG
10:00 10:05 BREAK UNPAID
10:05 12:00 WORK REG
12:00 13:00 BREAK UNPAID
13:00 17:00 WORK REG
17:00 19:00 WORK OT1
Start_Time End_Time Type Pay_Code
08:00 16:00 HOLIDAY REG
This type of structure allows you to identify parts of a day and classify them appropriately. You can say that time worked before the scheduled work day is paid at overtime. You could identify a break in the middle of the day as unpaid. (Same is true for lunch) You could also then show the time after the normal work day to be at overtime. This example assumes that you are using a pay schedule where time over 8 hours in a day is paid at overtime. In the USA, most overtime is paid only after 40 hours of work.
The second example shows how you represent Holiday pay. This schema also allows for sick time (paid or unpaid).
I'll leave it up to the class to show how you can expand this data structure to include charge codes where you could identify which cost centers the labor should be applied to.
If anyone can help me with this it would be greatly appreciated.
K here is what's happening.I am supposed to check if a student exists in the STUDENT table and then check if a module exists in the MODULE table.if they exist in both tables I must add the student(StudentNumber) and the module(ModuleCode) to the STUDENTMODULE table(register the student).
How do i do this plz help
Last Visit: 31-Dec-99 18:00 Last Update: 19-Jun-21 20:50