Click here to Skip to main content
15,850,606 members
Home / Discussions / Database
   

Database

 
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 
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 
Hi all,
I want to fill a grid (no hirarchical) where to combine customer data and the last selling item of each customer in a row (getting only the last sellings depending on sells_date).
My idea was

SELECT C.id,C.customerdata,S.id,S.sellsdata FROM dbo.customer AS C LEFT OUTER JOIN (SELECT TOP 1 id,sellsdata FROM dbo.sells ORDER BY sells_date DESC) AS S ON C.id=S.id

Whith this string I get only one selling item and not one item for each.
How does the correct SQL-String look likes ?

tnx in advance
Frank
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 
Questionfacing probs in nested cursor Pin
Member 387988115-Jul-08 20:56
Member 387988115-Jul-08 20:56 
AnswerRe: facing probs in nested cursor Pin
Alsvha16-Jul-08 0:28
Alsvha16-Jul-08 0: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.