 |
 | How to get an answer to your question |  | Chris Maunder | 17:30 10 Nov '05 |
|
|
For those new to message boards please try to follow a few simple rules when posting your question.- Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
- Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
- Keep the subject line brief, but descriptive. eg "File Serialization problem"
- Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
- If you are posting source code with your question, place it inside <pre></pre> tags, or click the "Ignore HTML tags in this message" check box.
- Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
- Please do not post links to your question in one forum from another, unrelated forum (such as the lounge). It will be deleted.
- Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
- If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
- No advertising or soliciting.
- We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
|
|
hi
can anybody tell me about the normalization
thanks
Hemant
By:
Hemant Thaker
|
|
|
|
|
|
|
A normalized database (which is a good idea generally) typically means that the minimum amount of data is stored (no repetition) in a relational manner. Take a look here for more info...
http://en.wikipedia.org/wiki/Database_normalization[^]
Regards,
Rob Philpott.
|
|
|
|
|
 | problem of champ type |  | foryou | 1 hr 59mins ago |
|
|
Hi
I need to put 'abs' for students absent in a review
for exemple of the material which the code is 121 .
I have the following query:
SELECT id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE [121] END AS m1,
[122] AS '2', [123] AS '3'
FROM (SELECT id_field, id_student, NOTE, CODE FROM TEST)
p PIVOT (sum(NOTE) FOR id_field IN ([121], [122], [123])) AS pvt
ORDER BY id_student
I have the error here CASE WHEN (CODE) = 1 THEN 'Abs' because [121]is the type float and 'abs' is a text how to solve this?
Thanks!!
|
|
|
|
|
| Help is needed in Triggers and indexes in sql server 2000 | | rameez Raja | 5hrs 27mins ago |
|
|
Hi all,
I have to work on Indexes and triggers in sql server 2000 can any body suggest me any article or resourse where i can learn these things.
Thanks in advance
Best regards
Rameez
|
|
|
|
|
|
|
|
| How will we stop the duplicating entries while we entering in Excel database? | | hitesh.kalra | 6hrs 33mins ago |
|
|
I insert and update in an excel database but what is the coding to prevent the duplicating entries in the database. Plz tell in c# language. thanx in advance.
|
|
|
|
|
 | how to create a query by using store procedure in SQL Server 2000 ? | | Sovann | 10hrs 17mins ago |
|
|
I have a table of employee attendent like that:
EmpID-----Date----------------Time------------------Status (Field Name)
1-------01/01/2009------01/01/2009 8:00 am--------I
1-------01/01/2009------01/01/2009 12:00 am-------O
1-------01/01/2009------01/01/2009 1:00 pm--------I
1-------01/01/2009------01/01/2009 5:00 pm--------O
2-------01/01/2009------01/01/2009 7:50 am--------I
2-------01/01/2009------01/01/2009 12:00 am-------O
But i want to make a query that take data from table above to be like that:
EmpID-----Date------------In------------Out----------In-------------Out (Fiel Name)
1-------01/01/2009------8:00 am-----12:00 am----1:00 pm------5:00 pm
2-------01/01/2009------7:50 am-----12:00 am----Null----------Null
Can we do that ?
Thank for your kindly to help me...
Best regard,
Sovann
VB.Net
modified on Sunday, February 15, 2009 9:18 PM
|
|
|
|
|
|
|
Something like this should get you close
select c.empid, c.dt as in1,
(select c1.dt from clock as c1 where c1.empid = c.empid and status = 'O'
and not exists (select 1 from clock as c2 where c2.empid = c1.empid and c2.status = 'O' and c2.dt < c1.dt)) as out1,
(select c1.dt from clock as c1 where c1.empid = c.empid and status = 'I'
and c1.dt > c.dt) as in2,
(select c1.dt from clock as c1 where c1.empid = c.empid and status = 'O'
and c1.dt > (select c1.dt from clock as c1 where c1.empid = c.empid and status = 'I'
and c1.dt > c.dt)) as out2
from clock as c
where c.status = 'I'
and not exists (select 1 from clock as c1 where c1.empid = c.empid and c1.status = 'I' and c1.dt < c.dt)
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
|
|
Thanks for your kindly to help me.
but what you wrote is in query right ?
It did not process.
but if there are more employee, Does it work ?
My idea if we select and use for loop, what can we do ?
VB.Net
|
|
|
|
|
|
|
Sovann wrote: Thanks for your kindly to help me.
No worries
Sovann wrote: but what you wrote is in query right ?
Yes - just plain SQL - so you can put it in a stored proc or whatever
Sovann wrote: It did not process
? in what way. I created a dummy table and entered data similar to your example, ran the query against it and got your desired results.
The column and table names were different to yours, but the query certainly worked fine...
Sovann wrote: but if there are more employee, Does it work ?
I think it should work as long as there is always an In and Out (not sure what it would do if there was only an In time and no Out - or if there were more than two of each. It doesn't matter how many employees there are.
Sovann wrote: My idea if we select and use for loop, what can we do ?
If you WANT to write loops etc. then sure, you could do that. You could create a temporary table, populate it using a number of queries in a loop, or whatever you want to do. Depends whether your aim is to solve the problem or to write some sql using a for loop?
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
|
|
I want to write some sql using for loop. Because i do not know that about number of employee. It will increase when we add new employee info.
VB.Net
|
|
|
|
|
|
|
In your example result you have 2 In columns and 2 Out columns. But what happens if a person goes in and out 3 or 4 times a day?
|
|
|
|
|
|
|
if a person goes in and out 3 or 4 time a day, one field will get null...
VB.Net
|
|
|
|
|
|
|
Sovann wrote: if a person goes in and out 3 or 4 time a day, one field will get null...
Don't quite understand. What field?
What I mean is that can a person go in and out undefined number of times during the same day? If he can, do you plan to use dynamic amount of columns (person, in1, out1, in2, out2, in3, out3...). Since this is very hard to achieve using plain sql
|
|
|
|
|
|
|
Oh sorry.
No over that columns bro.
that columns is (EmpID,Date,In1,Out1,In2,Out2) so each employee will have 4 attendants but some day they will absent in afternoon so their attendants will be just only 2 so
in columns In2, Out2 data will null. More is number of employee.
at the first i posted, i want to change data in Employee table like table under it. (hm... maybe is called crosstab.)
VB.Net
|
|
|
|
|
|
|
Hi
i am stuck in some issues professionally regarding Ab Inito, is there any one who can guide me as to how to go about this Ab Initio things, mates it is really compliv\cated and there is very limited resource available on net regarding Ab Inito......
This is an urgent requirement.......... 
|
|
|
|
|
|
|
PoisonCreed wrote: This is an urgent requirement.
but not urgent enough to contact their support team, which is listed on their website.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
|
|
I have already contacted their support team 15 days back , even asking them as to how to go about if i have to purchase the licensed copy of the product. but their answer is inconclusive and way of the track ......
Well what i have gathered so far is that company is very discreet and miser in disclosing any of their trade secrets regarding the product and hardly there is any more information regrading it available on web itself, i hardly found anything substantial so far.....
|
|
|
|
|
|
|
PoisonCreed wrote: that company is very discreet and miser in disclosing any of their trade secrets
I wouldn't expect them to reveal trade secrets, but they should have a decent support dept.
PoisonCreed wrote: to purchase the licensed copy
That may be the problem, I wouldn't give much support for a free version.
But, I would say, if they don't offer decent support use another product, there are plenty of other tools out there.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
|
|
Dear Folk,
I am new in SQL Server.I just installed MS SQL Server 2005 in my system(Wista Ultimate) but cant see the query builder or enterprise prise Manager.is there new way installing it to get those two things?
hope your reply,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| can't find AdventureWorks.dbml | | TerRO_GirL | 2:25 14 Feb '09 |
|
|
|
News 
Joke 
Rant