Click here to Skip to main content
15,887,485 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: validation on dropdown list Pin
saanj4-May-09 1:47
saanj4-May-09 1:47 
AnswerRe: validation on dropdown list Pin
Uma J5-May-09 0:57
Uma J5-May-09 0:57 
AnswerRe: validation on dropdown list Pin
Uma J5-May-09 1:00
Uma J5-May-09 1:00 
Questiontyping special character in ie 7 and above Pin
jhyn3-May-09 21:29
jhyn3-May-09 21:29 
AnswerRe: typing special character in ie 7 and above Pin
N a v a n e e t h3-May-09 21:45
N a v a n e e t h3-May-09 21:45 
GeneralRe: typing special character in ie 7 and above Pin
jhyn3-May-09 21:49
jhyn3-May-09 21:49 
GeneralRe: typing special character in ie 7 and above Pin
N a v a n e e t h3-May-09 21:59
N a v a n e e t h3-May-09 21:59 
QuestionSQL Quastion Pin
Vimalsoft(Pty) Ltd3-May-09 21:20
professionalVimalsoft(Pty) Ltd3-May-09 21:20 
Good Morning All

i have a Table
===================
DESCR         CYCLE 
===================
Rendle C      |	5 |
Reid M Prof   |	9 |
Randall S Ms  |	3 |
Reid M Prof   |	3 |
Rendall G Mr  |	3 |
Rendle C      |	3 |
Rendall G Mr  | 2 |
===================



Now as you can see "Rendle C" and "Rendall G Mr" appears Twice, now i want append the cyle field if the descr appears twice, the above list should now look like this

===================
DESCR         CYCLE 
===================
Rendle C      |	5 3 |
Reid M Prof   |	9 3 |
Rendall G Mr  |	3 2 |
===================


How can i do this in SQl

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

AnswerRe: SQL Quastion Pin
Christian Graus3-May-09 22:12
protectorChristian Graus3-May-09 22:12 
GeneralRe: SQL Quastion Pin
Vimalsoft(Pty) Ltd3-May-09 22:30
professionalVimalsoft(Pty) Ltd3-May-09 22:30 
GeneralRe: SQL Quastion Pin
Christian Graus3-May-09 22:44
protectorChristian Graus3-May-09 22:44 
AnswerRe: SQL Quastion Pin
Ramesh Swaminathan3-May-09 22:56
Ramesh Swaminathan3-May-09 22:56 
QuestionShow Popup message dynamically Pin
scothykonma3-May-09 20:54
scothykonma3-May-09 20:54 
AnswerRe: Show Popup message dynamically Pin
Christian Graus3-May-09 22:14
protectorChristian Graus3-May-09 22:14 
GeneralRe: Show Popup message dynamically Pin
scothykonma4-May-09 0:17
scothykonma4-May-09 0:17 
AnswerRe: Show Popup message dynamically Pin
saanj3-May-09 22:55
saanj3-May-09 22:55 
Question404 redirect for dynamically generated page(Data not found in database) Pin
anuj_24mar@yahoo.com3-May-09 20:17
anuj_24mar@yahoo.com3-May-09 20:17 
AnswerRe: 404 redirect for dynamically generated page(Data not found in database) Pin
N a v a n e e t h3-May-09 21:49
N a v a n e e t h3-May-09 21:49 
Question[newbie] Linq cannot find the tablename.. Pin
jon-803-May-09 19:42
professionaljon-803-May-09 19:42 
AnswerRe: [newbie] Linq cannot find the tablename.. Pin
Abhijit Jana3-May-09 19:57
professionalAbhijit Jana3-May-09 19:57 
AnswerRe: [newbie] Linq cannot find the tablename.. Pin
Abhishek Sur3-May-09 22:35
professionalAbhishek Sur3-May-09 22:35 
Question[newbie] binding anomaly Pin
jon-803-May-09 8:21
professionaljon-803-May-09 8:21 
AnswerRe: [newbie] binding anomaly Pin
Christian Graus3-May-09 13:20
protectorChristian Graus3-May-09 13:20 
GeneralRe: [newbie] binding anomaly Pin
jon-803-May-09 19:47
professionaljon-803-May-09 19:47 
QuestionAre "Master pages" ASP.NET's answer to Template Engine for .NET 2.0? Pin
Member 3653373-May-09 7:15
Member 3653373-May-09 7:15 

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.