Click here to Skip to main content
15,904,877 members
Home / Discussions / Database
   

Database

 
GeneralRe: MySQL Silent Installation Pin
Jassim Rahma6-Mar-14 9:57
Jassim Rahma6-Mar-14 9:57 
AnswerRe: MySQL Silent Installation Pin
jschell7-Mar-14 9:28
jschell7-Mar-14 9:28 
QuestionSSRS reports shrinks on chrome browser Pin
Kenn20026-Mar-14 2:32
professionalKenn20026-Mar-14 2:32 
AnswerRe: SSRS reports shrinks on chrome browser Pin
Snehasish_Nandy7-Mar-14 19:14
professionalSnehasish_Nandy7-Mar-14 19:14 
Questionarabic text is saved as unreadable characters Pin
Jassim Rahma5-Mar-14 23:49
Jassim Rahma5-Mar-14 23:49 
AnswerRe: arabic text is saved as unreadable characters Pin
Bernhard Hiller7-Mar-14 2:48
Bernhard Hiller7-Mar-14 2:48 
QuestionSelecting a row with least creation time without using top Pin
Prasad A5-Mar-14 19:53
Prasad A5-Mar-14 19:53 
AnswerRe: Selecting a row with least creation time without using top Pin
Jörgen Andersson5-Mar-14 21:23
professionalJörgen Andersson5-Mar-14 21:23 
SQL
WITH FirstObservation AS (
    SELECT  PatientID,Observation,Min(Time) Time
    FROM    MyTable
    WHERE   PatientID = @PatientID
    AND     Observation = @Observation
    GROUP BY PatientID,Observation
    )
SELECT  PatientId,Observation,TIME,Value
FROM    MyTable m
JOIN    FirstObservation f
ON      m.PatientID = f.PatientID
AND     m.Observation = f.Observation
AND     m.Time = f.Time

Wrong is evil and must be defeated.
- Jeff Ello[^]

AnswerRe: Selecting a row with least creation time without using top Pin
Kornfeld Eliyahu Peter5-Mar-14 22:00
professionalKornfeld Eliyahu Peter5-Mar-14 22:00 
GeneralRe: Selecting a row with least creation time without using top Pin
Eddy Vluggen6-Mar-14 3:00
professionalEddy Vluggen6-Mar-14 3:00 
GeneralRe: Selecting a row with least creation time without using top Pin
Kornfeld Eliyahu Peter6-Mar-14 3:10
professionalKornfeld Eliyahu Peter6-Mar-14 3:10 
GeneralRe: Selecting a row with least creation time without using top Pin
Eddy Vluggen6-Mar-14 5:12
professionalEddy Vluggen6-Mar-14 5:12 
GeneralRe: Selecting a row with least creation time without using top Pin
Kornfeld Eliyahu Peter6-Mar-14 5:30
professionalKornfeld Eliyahu Peter6-Mar-14 5:30 
GeneralRe: Selecting a row with least creation time without using top Pin
Simon_Whale6-Mar-14 5:07
Simon_Whale6-Mar-14 5:07 
GeneralRe: Selecting a row with least creation time without using top Pin
Jörgen Andersson6-Mar-14 11:01
professionalJörgen Andersson6-Mar-14 11:01 
SuggestionRe: Selecting a row with least creation time without using top Pin
Eddy Vluggen6-Mar-14 7:31
professionalEddy Vluggen6-Mar-14 7:31 
AnswerRe: Selecting a row with least creation time without using top Pin
Yes Yes Yes7-Mar-14 1:30
Yes Yes Yes7-Mar-14 1:30 
QuestionInsufficient privileges : Dynamic View Creation ORACLE Pin
prathameshpitale5-Mar-14 0:06
prathameshpitale5-Mar-14 0:06 
AnswerRe: Insufficient privileges : Dynamic View Creation ORACLE Pin
Jörgen Andersson5-Mar-14 1:58
professionalJörgen Andersson5-Mar-14 1:58 
GeneralRe: Insufficient privileges : Dynamic View Creation ORACLE Pin
prathameshpitale5-Mar-14 22:23
prathameshpitale5-Mar-14 22:23 
GeneralRe: Insufficient privileges : Dynamic View Creation ORACLE Pin
Jörgen Andersson5-Mar-14 22:58
professionalJörgen Andersson5-Mar-14 22:58 
QuestionMS ACCESS ODBC Problem Pin
Aravinth Spirited1-Mar-14 6:28
Aravinth Spirited1-Mar-14 6:28 
GeneralRe: MS ACCESS ODBC Problem Pin
Eddy Vluggen1-Mar-14 8:02
professionalEddy Vluggen1-Mar-14 8:02 
AnswerRe: MS ACCESS ODBC Problem Pin
CHill601-Mar-14 9:59
mveCHill601-Mar-14 9:59 
AnswerRe: MS ACCESS ODBC Problem Pin
kmoorevs1-Mar-14 10:44
kmoorevs1-Mar-14 10:44 

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.