Click here to Skip to main content
12,356,616 members (64,379 online)
   

Database

 
AnswerRe: check before insert Pin
djj551-Feb-13 7:50
memberdjj551-Feb-13 7:50 
GeneralRe: check before insert Pin
vanikanc1-Feb-13 7:55
membervanikanc1-Feb-13 7:55 
GeneralRe: check before insert Pin
djj551-Feb-13 8:25
memberdjj551-Feb-13 8:25 
QuestionIdentify DML changes between two databases Pin
Member 313707830-Jan-13 20:56
memberMember 313707830-Jan-13 20:56 
AnswerRe: Identify DML changes between two databases Pin
Mycroft Holmes30-Jan-13 21:11
memberMycroft Holmes30-Jan-13 21:11 
GeneralRe: Identify DML changes between two databases Pin
Member 313707830-Jan-13 21:26
memberMember 313707830-Jan-13 21:26 
QuestionUpdate a flag based on portion of data avialble in other column Pin
yuvachandra30-Jan-13 10:20
memberyuvachandra30-Jan-13 10:20 
AnswerRe: Update a flag based on portion of data avialble in other column Pin
Mycroft Holmes30-Jan-13 11:56
memberMycroft Holmes30-Jan-13 11:56 
Looking at your example it is not possible to identify the col1/2 content. Assuming the fist number is not in col1 I would break it into 2 queries

The first query should group by the col1 and count the instances of the different specifications.

The second query should build the string based on that information.
Never underestimate the power of human stupidity
RAH

GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra31-Jan-13 6:08
memberyuvachandra31-Jan-13 6:08 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
Mycroft Holmes31-Jan-13 11:32
memberMycroft Holmes31-Jan-13 11:32 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra31-Jan-13 11:45
memberyuvachandra31-Jan-13 11:45 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra1-Feb-13 7:00
memberyuvachandra1-Feb-13 7:00 
Questionhow to comlex databinding with access database Pin
Achilles8430-Jan-13 8:48
memberAchilles8430-Jan-13 8:48 
AnswerRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 11:49
memberMycroft Holmes30-Jan-13 11:49 
GeneralRe: how to comlex databinding with access database Pin
Achilles8430-Jan-13 20:49
memberAchilles8430-Jan-13 20:49 
GeneralRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 21:06
memberMycroft Holmes30-Jan-13 21:06 
GeneralRe: how to comlex databinding with access database Pin
Achilles841-Feb-13 0:25
memberAchilles841-Feb-13 0:25 
QuestionEnd Case in a Variable Pin
berba30-Jan-13 8:47
memberberba30-Jan-13 8:47 
AnswerRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 11:46
memberMycroft Holmes30-Jan-13 11:46 
GeneralRe: End Case in a Variable Pin
berba30-Jan-13 18:02
memberberba30-Jan-13 18:02 
GeneralRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 20:57
memberMycroft Holmes30-Jan-13 20:57 
QuestionWhat happens with auto-incremented value on rollback? Pin
piticcotoc29-Jan-13 23:27
memberpiticcotoc29-Jan-13 23:27 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Jörgen Andersson30-Jan-13 1:04
memberJörgen Andersson30-Jan-13 1:04 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 3:02
memberpiticcotoc30-Jan-13 3:02 
GeneralRe: What happens with auto-incremented value on rollback? Pin
mark merrens30-Jan-13 5:33
membermark merrens30-Jan-13 5: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.


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 29 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid