Click here to Skip to main content
14,879,719 members
Home / Discussions / Database
   

Database

 
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 
For anyone who is interested, here is my solution:
SELECT 
	Orders.ExampleData
FROM 
	OrderSeq AS Orders
LEFT JOIN
	OrderSeq AS Updates ON (Orders.OrderId = Updates.OldOrderId) AND (Updates.[Type] = 'U')
where 
	(Updates.RowId IS NULL)

I knew it was easy, just couldn't get my head around it this morning.

Thanks to everyone who replied.
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
Herman<T>.Instance1-Aug-11 3:52
MemberHerman<T>.Instance1-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 
GeneralRe: Single row for multiple results Pin
vanikanc22-Jul-11 8:42
Membervanikanc22-Jul-11 8:42 
AnswerRe: Single row for multiple results Pin
Shameel22-Jul-11 9:00
professionalShameel22-Jul-11 9:00 
AnswerRe: Single row for multiple results Pin
PIEBALDconsult23-Jul-11 14:07
professionalPIEBALDconsult23-Jul-11 14:07 
AnswerRe: Single row for multiple results Pin
Niladri_Biswas24-Jul-11 22:37
MemberNiladri_Biswas24-Jul-11 22:37 
SuggestionRe: Single row for multiple results Pin
_Zorro_25-Jul-11 4:22
professional_Zorro_25-Jul-11 4:22 
GeneralRe: Single row for multiple results Pin
vanikanc25-Jul-11 5:22
Membervanikanc25-Jul-11 5:22 
GeneralRe: Single row for multiple results Pin
_Zorro_25-Jul-11 6:20
professional_Zorro_25-Jul-11 6:20 
GeneralRe: Single row for multiple results Pin
smcnulty200025-Jul-11 13:04
Membersmcnulty200025-Jul-11 13:04 
AnswerRe: Single row for multiple results Pin
S Douglas11-Aug-11 9:33
professionalS Douglas11-Aug-11 9:33 

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.