Click here to Skip to main content
       

Database

 
AnswerRe: check before insert Pinmemberdjj551-Feb-13 8:50 
GeneralRe: check before insert Pinmembervanikanc1-Feb-13 8:55 
GeneralRe: check before insert Pinmemberdjj551-Feb-13 9:25 
QuestionIdentify DML changes between two databases PinmemberMember 313707830-Jan-13 21:56 
AnswerRe: Identify DML changes between two databases PinmemberMycroft Holmes30-Jan-13 22:11 
GeneralRe: Identify DML changes between two databases PinmemberMember 313707830-Jan-13 22:26 
QuestionUpdate a flag based on portion of data avialble in other column Pinmemberyuvachandra30-Jan-13 11:20 
AnswerRe: Update a flag based on portion of data avialble in other column PinmemberMycroft Holmes30-Jan-13 12: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 Pinmemberyuvachandra31-Jan-13 7:08 
GeneralRe: Update a flag based on portion of data avialble in other column PinmemberMycroft Holmes31-Jan-13 12:32 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra31-Jan-13 12:45 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra1-Feb-13 8:00 
Questionhow to comlex databinding with access database PinmemberAchilles8430-Jan-13 9:48 
AnswerRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 12:49 
GeneralRe: how to comlex databinding with access database PinmemberAchilles8430-Jan-13 21:49 
GeneralRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 22:06 
GeneralRe: how to comlex databinding with access database PinmemberAchilles841-Feb-13 1:25 
QuestionEnd Case in a Variable Pinmemberberba30-Jan-13 9:47 
AnswerRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 12:46 
GeneralRe: End Case in a Variable Pinmemberberba30-Jan-13 19:02 
GeneralRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 21:57 
QuestionWhat happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 0:27 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberJörgen Andersson30-Jan-13 2:04 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 4:02 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens30-Jan-13 6:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.1411028.1 | Last Updated 28 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid