Click here to Skip to main content
14,667,416 members
Home » Discussions » Database
   

Database

 
QuestionMaking the SSIS Data Reader Source Query Dynamic Pin
Member 808202128-Jul-11 14:44
MemberMember 808202128-Jul-11 14:44 
AnswerRe: Making the SSIS Data Reader Source Query Dynamic Pin
S Douglas11-Aug-11 9:29
professionalS Douglas11-Aug-11 9:29 
GeneralRe: Making the SSIS Data Reader Source Query Dynamic Pin
Member 808202115-Oct-11 4:37
MemberMember 808202115-Oct-11 4:37 
QuestionHow to get the 'GENERATED ALWAYS AS IDENTITY' attribute of the column from a DB2 table? Pin
coder21k27-Jul-11 20:17
Membercoder21k27-Jul-11 20:17 
QuestionLast record in MYSQL Pin
pix_programmer27-Jul-11 18:45
Memberpix_programmer27-Jul-11 18:45 
AnswerRe: Last record in MYSQL Pin
_Damian S_27-Jul-11 19:23
professional_Damian S_27-Jul-11 19:23 
AnswerRe: Last record in MYSQL Pin
thatraja28-Jul-11 15:26
professionalthatraja28-Jul-11 15:26 
QuestionFind Last Record In Sequence Pin
Adam Jasper26-Jul-11 0:45
MemberAdam Jasper26-Jul-11 0:45 
I have a table in Sql Server structured something like this:
RowId  OrderId  OldOrderId  Type  Example Data  
8787   1        NULL        I     The first order in sequence 1
9837   2        1           U     The second order in sequence 1
10838  3        2           U     The third order in sequence 1
11873  4        3           U     The fourth order in sequence 1
12554  5        NULL        I     The first order in sequence 2
14113  6        5           U     The second order in sequence 2
15003  7        6           U     The third order in sequence 2
18343  8        7           U     The fourth order in sequence 2

What I am trying to do is find the last record in each sequence using only the columns I have in the table. I cannot add anything to group by as I am not in control of the data. Has anyone got any ideas? I have done something like this before but I cannot seem to put my hands on it at the moment.

Thanks in advance
AnswerRe: Find Last Record In Sequence Pin
Simon_Whale26-Jul-11 2:22
professionalSimon_Whale26-Jul-11 2:22 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 2:32
MemberAdam Jasper26-Jul-11 2:32 
GeneralRe: Find Last Record In Sequence Pin
Blue_Boy26-Jul-11 2:35
MemberBlue_Boy26-Jul-11 2:35 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 2:39
MemberAdam Jasper26-Jul-11 2:39 
GeneralRe: Find Last Record In Sequence Pin
Blue_Boy26-Jul-11 2:41
MemberBlue_Boy26-Jul-11 2:41 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 3:16
MemberAdam Jasper26-Jul-11 3:16 
GeneralRe: Find Last Record In Sequence Pin
Blue_Boy26-Jul-11 3:29
MemberBlue_Boy26-Jul-11 3:29 
GeneralRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 3:33
MemberAdam Jasper26-Jul-11 3:33 
AnswerRe: Find Last Record In Sequence Pin
Adam Jasper26-Jul-11 3:48
MemberAdam Jasper26-Jul-11 3:48 
QuestionOracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() interrupts execution of the whole program [modified] Pin
NandoMan25-Jul-11 11:51
MemberNandoMan25-Jul-11 11:51 
GeneralRe: Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() interrupts execution of the whole program Pin
Shameel31-Jul-11 7:25
professionalShameel31-Jul-11 7:25 
AnswerRe: Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() interrupts execution of the whole program Pin
digimanus1-Aug-11 3:52
Memberdigimanus1-Aug-11 3:52 
QuestionSingle row for multiple results Pin
vanikanc22-Jul-11 7:54
Membervanikanc22-Jul-11 7:54 
AnswerRe: Single row for multiple results Pin
Blue_Boy22-Jul-11 8:20
MemberBlue_Boy22-Jul-11 8:20 
GeneralRe: Single row for multiple results Pin
vanikanc22-Jul-11 8:27
Membervanikanc22-Jul-11 8:27 
GeneralRe: Single row for multiple results Pin
Blue_Boy22-Jul-11 8:28
MemberBlue_Boy22-Jul-11 8:28 
AnswerRe: Single row for multiple results Pin
Tim Carmichael22-Jul-11 8:28
MemberTim Carmichael22-Jul-11 8:28 

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.