Click here to Skip to main content
15,843,727 members
Home / Discussions / Database
   

Database

 
AnswerRe: Multiple queries within an ADO connection Pin
tsaunders16-Jul-08 16:09
tsaunders16-Jul-08 16:09 
AnswerRe: Multiple queries within an ADO connection Pin
andyharman17-Jul-08 8:15
professionalandyharman17-Jul-08 8:15 
AnswerRe: Multiple queries within an ADO connection Pin
Airickjay17-Jul-08 9:30
Airickjay17-Jul-08 9:30 
AnswerRe: Multiple queries within an ADO connection Pin
MBCDC21-Jul-08 1:59
MBCDC21-Jul-08 1:59 
Questionerror when deleting with the WITH clause? Pin
harcaype16-Jul-08 8:01
harcaype16-Jul-08 8:01 
AnswerRe: error when deleting with the WITH clause? Pin
tsaunders16-Jul-08 16:02
tsaunders16-Jul-08 16:02 
GeneralRe: error when deleting with the WITH clause? Pin
harcaype16-Jul-08 20:13
harcaype16-Jul-08 20:13 
AnswerRe: error when deleting with the WITH clause? Pin
leoinfo17-Jul-08 5:19
leoinfo17-Jul-08 5:19 
Is it this what you are looking for?

WITH ORDERED_RECORDS AS(
		SELECT	
			 row_number() OVER (ORDER BY Records.[Plate Number] ASC) AS rowID
			,Records.[Officer ID]
			,DriverInfo.[Plate Number]
			,DriverInfo.[License Number]
			,DriverInfo.[Conduction Number]
			,DriverInfo.[Vehicle Category]
			,DriverInfo.[Vehicle Type]
			,DriverInfo.[Vehicle Brand]
			,DriverInfo.[Last Name]
			,DriverInfo.[First Name]
			,DriverInfo.[Middle Name]
			,DriverInfo.[Birth Date]
			,DriverInfo.[Registered Address]
			,DriverInfo.[Address' City Code]
			,Records.[Violation Commited]
			,Violations.[Violation Code]
			,Records.[Street Name]
			,Records.[City of Apprehension]
			,Cities.[City Code]
			,Violations.[Fine Amount]
			,Records.[Date/Time Apprehended]
		FROM Violations
			,DriverInfo
			,Records
			,Cities
		WHERE		Records.[Plate Number]			like DriverInfo.[Plate Number]
				and Records.[Violation Commited]	like Violations.Violations
				and Records.[City of Apprehension]	like Cities.City
)
DELETE FROM Records
WHERE Records.[Plate Number] 
	IN (
		SELECT	[Plate Number] 
		FROM	ORDERED_RECORDS 
		WHERE	rowID=1
	)

GeneralRe: error when deleting with the WITH clause? Pin
harcaype17-Jul-08 6:56
harcaype17-Jul-08 6:56 
QuestionHow to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 2:51
fracalifa16-Jul-08 2:51 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 3:18
A Wong16-Jul-08 3:18 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 4:01
fracalifa16-Jul-08 4:01 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 4:15
A Wong16-Jul-08 4:15 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 4:32
fracalifa16-Jul-08 4:32 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 4:41
A Wong16-Jul-08 4:41 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 5:10
fracalifa16-Jul-08 5:10 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 5:38
A Wong16-Jul-08 5:38 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 5:50
A Wong16-Jul-08 5:50 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
leoinfo16-Jul-08 5:29
leoinfo16-Jul-08 5:29 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
leoinfo16-Jul-08 5:39
leoinfo16-Jul-08 5:39 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 5:56
fracalifa16-Jul-08 5:56 
QuestionHow to Make Application to Sync on Remote Site Pin
Nassoro Ally16-Jul-08 1:39
Nassoro Ally16-Jul-08 1:39 
QuestionReports are not visible on client machine Pin
meetaqadir15-Jul-08 21:54
meetaqadir15-Jul-08 21:54 
QuestionOLEDB with Excel problem Pin
acroitoriu15-Jul-08 21:52
acroitoriu15-Jul-08 21:52 
AnswerRe: OLEDB with Excel problem Pin
acroitoriu15-Jul-08 22:23
acroitoriu15-Jul-08 22:23 

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.