Click here to Skip to main content
15,908,675 members
Home / Discussions / Database
   

Database

 
GeneralRe: A Database Design Problem - Catalogue Pin
ChandraRam5-Jun-08 7:37
ChandraRam5-Jun-08 7:37 
GeneralRe: A Database Design Problem - Catalogue Pin
Cristoff6-Jun-08 4:49
Cristoff6-Jun-08 4:49 
QuestionHow to combine 3 tables with Joins? Pin
Michiel5-Jun-08 1:21
Michiel5-Jun-08 1:21 
AnswerRe: How to combine 3 tables with Joins? Pin
Parwej Ahamad5-Jun-08 6:02
professionalParwej Ahamad5-Jun-08 6:02 
GeneralRe: How to combine 3 tables with Joins? Pin
Michiel5-Jun-08 21:27
Michiel5-Jun-08 21:27 
QuestionTableAdapters with Relation Pin
RoyRose785-Jun-08 0:55
RoyRose785-Jun-08 0:55 
AnswerRe: TableAdapters with Relation Pin
John_Adams5-Jun-08 6:16
John_Adams5-Jun-08 6:16 
QuestionQuery Problem Pin
H.A.Faheem4-Jun-08 20:21
H.A.Faheem4-Jun-08 20:21 
Hello Every one i have a problem ,i want to selct the all record from one table and get the limited recode from the other table and combine then with a query like

SELECT * FROM Personal p INNER JOIN DailyRecord dr ON p.pCODE = dr.pcode INNER JOIN Department dept ON p.deptid = dept.deptid where cast(CONVERT(datetime,dr.TIMEIN,105) as datetime) between cast('2008-06-05' as datetime) and cast('2008-06-05' as datetime)+1

when i run this query it only returns limited rows if i remove the last where condition then it gives me the whole table with joins but i want to get all data from pernal and the time in out from daily record if avlaible if not then its null in given dates
AnswerRe: Query Problem Pin
Alsvha4-Jun-08 20:31
Alsvha4-Jun-08 20:31 
GeneralRe: Query Problem Pin
H.A.Faheem4-Jun-08 20:33
H.A.Faheem4-Jun-08 20:33 
GeneralRe: Query Problem Pin
Alsvha4-Jun-08 23:59
Alsvha4-Jun-08 23:59 
QuestionSpliting a table. Pin
devboycpp4-Jun-08 9:36
devboycpp4-Jun-08 9:36 
AnswerRe: Spliting a table. Pin
Member 33013254-Jun-08 9:56
Member 33013254-Jun-08 9:56 
GeneralRe: Spliting a table. Pin
devboycpp5-Jun-08 2:38
devboycpp5-Jun-08 2:38 
GeneralRe: Spliting a table. Pin
Member 33013255-Jun-08 3:08
Member 33013255-Jun-08 3:08 
GeneralRe: Spliting a table. Pin
devboycpp6-Jun-08 1:41
devboycpp6-Jun-08 1:41 
AnswerRe: Spliting a table. Pin
Parwej Ahamad4-Jun-08 17:27
professionalParwej Ahamad4-Jun-08 17:27 
GeneralRe: Spliting a table. Pin
Mycroft Holmes4-Jun-08 17:58
professionalMycroft Holmes4-Jun-08 17:58 
AnswerRe: Spliting a table. Pin
Alsvha4-Jun-08 17:53
Alsvha4-Jun-08 17:53 
AnswerRe: Spliting a table. Pin
Ashfield4-Jun-08 21:34
Ashfield4-Jun-08 21:34 
QuestionConnection String. Pin
hariram284-Jun-08 5:47
hariram284-Jun-08 5:47 
AnswerRe: Connection String. Pin
Parwej Ahamad4-Jun-08 7:02
professionalParwej Ahamad4-Jun-08 7:02 
AnswerRe: Connection String. Pin
Mycroft Holmes4-Jun-08 18:05
professionalMycroft Holmes4-Jun-08 18:05 
GeneralRe: Connection String. Pin
hariram285-Jun-08 2:47
hariram285-Jun-08 2:47 
AnswerRe: Connection String. Pin
Ashfield4-Jun-08 21:06
Ashfield4-Jun-08 21:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.