Click here to Skip to main content
15,867,330 members
Home / Discussions / Database
   

Database

 
GeneralRe: Inserting a new record into 2 tables at the same time Pin
Mycroft Holmes19-Mar-14 14:10
professionalMycroft Holmes19-Mar-14 14:10 
GeneralRe: Inserting a new record into 2 tables at the same time Pin
jkirkerx19-Mar-14 16:26
professionaljkirkerx19-Mar-14 16:26 
QuestionStructure Database Pin
sbangani15-Mar-14 5:29
sbangani15-Mar-14 5:29 
AnswerRe: Structure Database Pin
Richard Andrew x6415-Mar-14 10:55
professionalRichard Andrew x6415-Mar-14 10:55 
GeneralRe: Structure Database Pin
sbangani16-Mar-14 12:05
sbangani16-Mar-14 12:05 
AnswerRe: Structure Database Pin
Eddy Vluggen16-Mar-14 0:51
professionalEddy Vluggen16-Mar-14 0:51 
AnswerRe: Structure Database Pin
jschell17-Mar-14 8:37
jschell17-Mar-14 8:37 
QuestionGet Result according to comma seperated sequence Pin
Rupesh Kumar Swami15-Mar-14 4:04
Rupesh Kumar Swami15-Mar-14 4:04 
Hi All,
I want to get the result according to comma seperated value in field. First let me explain the table and their data

I have one table which contain following fields and data

file sequence || Cat_Id || Sequence

4,1,5,8,9,10,20 || 41 || 2
18,17,19,24,25 || 48 || 9
19,21,22,23,24,25,26 || 49 || 10


above is the sample data structure which contains the data in above format. Now I want to create a query which rerurn the value of file_sequence field in following format

4,1,5,8,9,10,20,18,17,19,24,25,21,22,26

Here one thing Which I want to notify
1. above table is result of a query which is sorted on the base of Sequence
2. Now we pick the result of field_sequence from the start in the same order.
3. now we pick the 4,1,5,8,9,10,20 then 18,17,19,24,25 and then 21,22,26
4. duplicate value removed (in above example 19,24,25 are duplicate)

so in this way I want to get the comma seperated value
4,1,5,8,9,10,20,18,17,19,24,25,21,22,26

Please suggest/guide how can i achieve this result
rup28aug@yahoo.co.in
Rupesh Kumar Swami
Software Developer,
Integrated Solution,
Bikaner (India)

Company - ISOL, India


Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

AnswerRe: Get Result according to comma seperated sequence Pin
Jörgen Andersson15-Mar-14 9:07
professionalJörgen Andersson15-Mar-14 9:07 
Questionget day wise records seperated by id Pin
Member 1026351913-Mar-14 20:23
Member 1026351913-Mar-14 20:23 
AnswerRe: get day wise records seperated by id Pin
Mycroft Holmes14-Mar-14 0:50
professionalMycroft Holmes14-Mar-14 0:50 
AnswerRe: get day wise records seperated by id Pin
Bernhard Hiller14-Mar-14 1:12
Bernhard Hiller14-Mar-14 1:12 
Questionquery for monthly report Pin
Member 1026351913-Mar-14 18:23
Member 1026351913-Mar-14 18:23 
AnswerRe: query for monthly report Pin
Mycroft Holmes13-Mar-14 19:58
professionalMycroft Holmes13-Mar-14 19:58 
GeneralRe: query for monthly report Pin
Member 1026351913-Mar-14 20:11
Member 1026351913-Mar-14 20:11 
Questionhow to insert data in foreign key using jsp Pin
Faisal_Abdullah13-Mar-14 10:43
Faisal_Abdullah13-Mar-14 10:43 
AnswerRe: how to insert data in foreign key using jsp Pin
_AK_13-Mar-14 10:52
_AK_13-Mar-14 10:52 
GeneralRe: how to insert data in foreign key using jsp Pin
Faisal_Abdullah14-Mar-14 11:29
Faisal_Abdullah14-Mar-14 11:29 
AnswerRe: how to insert data in foreign key using jsp Pin
_AK_19-Mar-14 6:00
_AK_19-Mar-14 6:00 
AnswerRe: how to insert data in foreign key using jsp Pin
Jörgen Andersson19-Mar-14 10:30
professionalJörgen Andersson19-Mar-14 10:30 
AnswerRe: how to insert data in foreign key using jsp Pin
Mycroft Holmes13-Mar-14 14:12
professionalMycroft Holmes13-Mar-14 14:12 
GeneralRe: how to insert data in foreign key using jsp Pin
Faisal_Abdullah14-Mar-14 11:31
Faisal_Abdullah14-Mar-14 11:31 
GeneralRe: how to insert data in foreign key using jsp Pin
Faisal_Abdullah19-Mar-14 10:14
Faisal_Abdullah19-Mar-14 10:14 
GeneralRe: how to insert data in foreign key using jsp Pin
Mycroft Holmes19-Mar-14 14:13
professionalMycroft Holmes19-Mar-14 14:13 
SuggestionRe: how to insert data in foreign key using jsp Pin
Richard Deeming14-Mar-14 2:20
mveRichard Deeming14-Mar-14 2:20 

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.