|
|
Jeez, I take it you never heard of Google?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
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?
G. Satish
|
|
|
|
|
sp_databases
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi
I have an access file which contains forms,tables,queries,..
How could I know what table or query the forms are taking data from?
I am too late but i will never give up
|
|
|
|
|
In MS-Access,
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.
Hope this helps.
David
|
|
|
|
|
hi there!!!!
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
|
|
|
|
|
What stops you to start your project?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Well, my latest project is to install a new bathroom if that helps.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
|
do a rent-a-movie software (did one before) or library software for exemple.
They are easy & good because you can built it has a stand-alone (no need to build network if you wish) 
Better you see samples from projects that came in ebooks.
Go to www.ebooks-space.com[^] download a ebook that cames with a project you like. 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi...can any1 assist me plz....im using sql 2005...i have multiple selects seperated by if statements like this:
IF @Monday = 0
SELECT [Day],[Date] FROM dbo.fnGetDatesforAday('2008/09/10', '2008/09/30','Monday')
IF @Tuesday = 1
SELECT [Day],[Date] FROM dbo.fnGetDatesforAday('2008/09/10', '2008/09/30','Tuesday')
is there a way to execute both selects as 1 query
living life on the flip side
|
|
|
|
|
SELECT
[Day],[Date]
FROM
dbo.fnGetDatesforAday('2008/09/10', '2008/09/30',(
SELECT
CASE @Monday
WHEN 0 THEN 'Monday'
WHEN 1 THEN 'Tuesday'
ELSE 'Other'
END
)
)It's a wild guess, I haven't executed it though.
|
|
|
|
|
Hi,
kinldy let me know that, how to remove spaces using query?
Example
--------
FullName
------------------
RIAZ - BASHIR ===>>> RIAZ-BASHIR
KASHIF - HAROON ===>>> KASHIF-HAROON
Thank you in advance
(Riaz)
|
|
|
|
|
Try this
Select replace(fullname,' ','')
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
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.
Can someone give me any advise how can I do that?
Thanks
Candy
|
|
|
|
|
Here is idea how to implement in your real data:
select convert(varchar(15), cast(getdate()+ ' 17:00' as datetime) - cast(getdate()+' 08:00' as datetime),108)<br />
select convert(varchar(15),cast(getdate()+' 17:01' as datetime) - cast(getdate()+1+'08:29' as datetime),108)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi,
Thank you for your response.
I think I didn't explan it very well.
shall i explan the problem more in detail? for example, the job_time table contains following data
Job_id, Start_Datetime, End_Datetime, [Time_spent__hrs_]
1, 2001-08-20 00:00:00.000, 2001-08-21 00:00:00.000, 24.000000
2, 2001-08-21 00:00:00.000, 2001-08-21 12:00:00.000, 12.000000
3, 2001-08-20 08:00:00.000, 2001-08-21 10:00:00.000, 26.000000
4, 2001-08-13 13:00:00.000, 2001-08-17 15:00:00.000, 98.000000
5, 2001-07-18 12:00:00.000, 2001-07-18 17:00:00.000, 5.000000
6, 2001-08-24 08:30:00.000, 2001-08-24 17:30:00.000, 9.000000
I want to split the time spent hours into 2 fames, how many hours spent with in 8:30 - 17:00 & 17:01 - 8:29
Thank you
modified on Monday, September 15, 2008 7:34 PM
|
|
|
|
|
select *,<br />
datediff(hh,cast(start_datetime as datetime),cast(end_datetime as datetime)) as [Time_spent__hrs_]<br />
from MyTable
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
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. 
|
|
|
|
|
I tried re-posting the example data with HTML table formatting.
(You may need to scroll down to see it ... I'm not sure why there is so much white space)
| Start_Time | End_Time | Type | Pay_Code | | 06:00 | 08:00 | WORK | OT1 | | 08:00 | 10:00 | WORK | REG | | 10:00 | 10:15 | BREAK | UNPAID | | 10:15 | 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 | 17:00 | HOLIDAY | REG |
|
|
|
|
|
Hi Guys
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
|
|
|
|
|
To find if a record exists, you would use a select statement ...
<br />
select count(*) from student where studentNumber = [myStud]<br />
<br />
if count = 0 then <br />
insert StudentNumber,ModuleCode into STUDENTModule values (myStud,myMoodule)<br />
This is not actual code, but pseudocode meant to point you in the right direction. I won't do your homework for you. 
|
|
|
|
|
if(select count(*) from students where studentnamecolumn = 'studentname') = 0<br />
begin<br />
insert into students values (value1,value1......)<br />
end
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
