Click here to Skip to main content
15,900,480 members
Home / Discussions / Database
   

Database

 
AnswerRe: group by value in the prefix of the values of that group Pin
i.j.russell28-Jun-10 11:02
i.j.russell28-Jun-10 11:02 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14328-Jun-10 11:14
indian14328-Jun-10 11:14 
AnswerRe: group by value in the prefix of the values of that group Pin
i.j.russell28-Jun-10 20:37
i.j.russell28-Jun-10 20:37 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14329-Jun-10 6:44
indian14329-Jun-10 6:44 
GeneralRe: group by value in the prefix of the values of that group Pin
i.j.russell29-Jun-10 11:26
i.j.russell29-Jun-10 11:26 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14329-Jun-10 12:57
indian14329-Jun-10 12:57 
GeneralRe: group by value in the prefix of the values of that group Pin
i.j.russell29-Jun-10 21:38
i.j.russell29-Jun-10 21:38 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14328-Jun-10 11:51
indian14328-Jun-10 11:51 
Hi Russel,

I have give the example in the previous reply, can you please give me any solution to do it. Its urgent requirement.

For example
You have
Cat1 Item1
Cate2 Item 2
Cate3 Item3
Cate1 Item 2
Cate1 Item3
Cate2 Item1
Cate2 Item 3
Cate3 Item1
Cate3 Item2
Then my output should look as follows
cate1: Item1, Item2, ITem3/Cate2: Item1, Item2, Item3/Cate3:Item1, Item2, Item3.
Can you please help me in achieving it, in performance oriented way. They need that too.
Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

RantRe: group by value in the prefix of the values of that group Pin
i.j.russell28-Jun-10 20:44
i.j.russell28-Jun-10 20:44 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14328-Jun-10 20:49
indian14328-Jun-10 20:49 
QuestionUsing dynamic SQL Pin
mjackson1128-Jun-10 5:25
mjackson1128-Jun-10 5:25 
AnswerRe: Using dynamic SQL Pin
David Mujica28-Jun-10 6:05
David Mujica28-Jun-10 6:05 
AnswerRe: Using dynamic SQL Pin
PIEBALDconsult29-Jun-10 18:29
mvePIEBALDconsult29-Jun-10 18:29 
GeneralRe: Using dynamic SQL Pin
Tim Carmichael30-Jun-10 7:29
Tim Carmichael30-Jun-10 7:29 
GeneralRe: Using dynamic SQL Pin
PIEBALDconsult30-Jun-10 15:57
mvePIEBALDconsult30-Jun-10 15:57 
Questionxp_cmdshell Pin
It_tech28-Jun-10 2:11
It_tech28-Jun-10 2:11 
AnswerRe: xp_cmdshell Pin
J4amieC28-Jun-10 2:28
J4amieC28-Jun-10 2:28 
GeneralRe: xp_cmdshell Pin
It_tech28-Jun-10 3:17
It_tech28-Jun-10 3:17 
QuestionBinding source does not update when the linked table is updated in code. Pin
Christian Yeates28-Jun-10 0:17
Christian Yeates28-Jun-10 0:17 
Questionxp_cmdshell [modified] Pin
It_tech26-Jun-10 23:27
It_tech26-Jun-10 23:27 
AnswerRe: xp_cmdshell Pin
J4amieC27-Jun-10 21:53
J4amieC27-Jun-10 21:53 
GeneralRe: xp_cmdshell Pin
It_tech28-Jun-10 2:21
It_tech28-Jun-10 2:21 
GeneralRe: xp_cmdshell Pin
J4amieC28-Jun-10 3:32
J4amieC28-Jun-10 3:32 
GeneralRe: xp_cmdshell Pin
It_tech28-Jun-10 4:09
It_tech28-Jun-10 4:09 
GeneralRe: xp_cmdshell [modified] Pin
It_tech28-Jun-10 3:28
It_tech28-Jun-10 3: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.