Click here to Skip to main content
15,868,040 members
Home / Discussions / Database
   

Database

 
GeneralRe: error when deleting with the WITH clause? Pin
harcaype17-Jul-08 5:56
harcaype17-Jul-08 5:56 
QuestionHow to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 1:51
fracalifa16-Jul-08 1:51 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 2:18
A Wong16-Jul-08 2:18 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 3:01
fracalifa16-Jul-08 3:01 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 3:15
A Wong16-Jul-08 3:15 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 3:32
fracalifa16-Jul-08 3:32 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 3:41
A Wong16-Jul-08 3:41 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 4:10
fracalifa16-Jul-08 4:10 
Your first understanding is right.
I need for all customers their last sold product. But the last product information consits of 4 items. So the solution grid should look like that

ID-----Name----Address------> LastSoldItem----ProductNr.----ProductPrice----LastSellingDate
1111--Miller--1.st Avn----------Ship-----------00112233--------1000,00-----------05/09/2008
1123--Riven---Hallstreet--------Car------------00055564--------2000,00-----------07/08/2008

etc.

Every customer has sold many products and I want to see only the last sold product consisting of 4 items.
The tables are related by the customer-ID.

With your suggested solution I only get one item of the last sold product. (and not all the 4 I need)

I hope this clears your confusion....

tnx
frank
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 4:38
A Wong16-Jul-08 4:38 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 4:50
A Wong16-Jul-08 4:50 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
leoinfo16-Jul-08 4:29
leoinfo16-Jul-08 4:29 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
leoinfo16-Jul-08 4:39
leoinfo16-Jul-08 4:39 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 4:56
fracalifa16-Jul-08 4:56 
QuestionHow to Make Application to Sync on Remote Site Pin
Nassoro Ally16-Jul-08 0:39
Nassoro Ally16-Jul-08 0:39 
QuestionReports are not visible on client machine Pin
meetaqadir15-Jul-08 20:54
meetaqadir15-Jul-08 20:54 
QuestionOLEDB with Excel problem Pin
acroitoriu15-Jul-08 20:52
acroitoriu15-Jul-08 20:52 
AnswerRe: OLEDB with Excel problem Pin
acroitoriu15-Jul-08 21:23
acroitoriu15-Jul-08 21:23 
Questionfacing probs in nested cursor Pin
Member 387988115-Jul-08 19:56
Member 387988115-Jul-08 19:56 
AnswerRe: facing probs in nested cursor Pin
Alsvha15-Jul-08 23:28
Alsvha15-Jul-08 23:28 
Questionbytes retrieval Pin
vicki52815-Jul-08 18:19
vicki52815-Jul-08 18:19 
AnswerRe: bytes retrieval Pin
Alsvha15-Jul-08 23:28
Alsvha15-Jul-08 23:28 
QuestionHow do i convert a varchar field into the datetime data type Pin
Rameez Raja15-Jul-08 18:12
Rameez Raja15-Jul-08 18:12 
AnswerRe: How do i convert a varchar field into the datetime data type Pin
Alsvha15-Jul-08 23:31
Alsvha15-Jul-08 23:31 
QuestionDATABASE CONNECTIVITY Pin
murphy7715-Jul-08 15:58
murphy7715-Jul-08 15:58 
AnswerRe: DATABASE CONNECTIVITY Pin
Ashfield15-Jul-08 21:45
Ashfield15-Jul-08 21:45 

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.