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

Database

 
AnswerRe: Store Procedure Pin
SomeGuyThatIsMe1-Jul-08 2:57
SomeGuyThatIsMe1-Jul-08 2:57 
QuestionHelp In Query Pin
Saiyed Alam1-Jul-08 1:06
Saiyed Alam1-Jul-08 1:06 
AnswerRe: Help In Query Pin
SomeGuyThatIsMe1-Jul-08 3:09
SomeGuyThatIsMe1-Jul-08 3:09 
GeneralRe: Help In Query Pin
Saiyed Alam1-Jul-08 5:27
Saiyed Alam1-Jul-08 5:27 
QuestionConnection: login failed - State 16 Pin
DharperII1-Jul-08 0:52
DharperII1-Jul-08 0:52 
QuestionSql server replication (from 2000 to 2005) Pin
acodman30-Jun-08 23:49
acodman30-Jun-08 23:49 
QuestionReporting Services - Controlling number of rows of a table control Pin
Rashmi Deshpande30-Jun-08 23:47
Rashmi Deshpande30-Jun-08 23:47 
Questionsql query Pin
Pankaj Garg30-Jun-08 21:25
Pankaj Garg30-Jun-08 21:25 
S.No Name city
1 N1 C1
2 N2 C2
3 N3 C3
4 N4 C2
5 N5 C1


from the above table , I want the data in the following format
List the total no of names as per the city
S.No City Total
1 C1 2
2 C2 2
3 C3 1

How should i start to get in mimimal queries ?
Should I get all these things in stored procedure or an inline multivalues function

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

AnswerRe: sql query Pin
Giorgi Dalakishvili30-Jun-08 21:27
mentorGiorgi Dalakishvili30-Jun-08 21:27 
GeneralRe: sql query Pin
Pankaj Garg30-Jun-08 21:31
Pankaj Garg30-Jun-08 21:31 
GeneralRe: sql query Pin
Giorgi Dalakishvili1-Jul-08 4:20
mentorGiorgi Dalakishvili1-Jul-08 4:20 
AnswerRe: sql query Pin
TheFM2342-Jul-08 3:43
TheFM2342-Jul-08 3:43 
QuestionHow to get the second occuring of a row Pin
Exelioindia30-Jun-08 4:09
Exelioindia30-Jun-08 4:09 
AnswerRe: How to get the second occuring of a row Pin
SomeGuyThatIsMe30-Jun-08 8:39
SomeGuyThatIsMe30-Jun-08 8:39 
Questionconnecting to remote sql server Pin
kadkir30-Jun-08 3:48
kadkir30-Jun-08 3:48 
AnswerRe: connecting to remote sql server Pin
rrrriiizz2-Jul-08 19:37
rrrriiizz2-Jul-08 19:37 
QuestionSQL Server 2008 Express Pin
Brendan Vogt30-Jun-08 3:26
Brendan Vogt30-Jun-08 3:26 
AnswerRe: SQL Server 2008 Express Pin
Mark Salsbery30-Jun-08 7:01
Mark Salsbery30-Jun-08 7:01 
AnswerRe: SQL Server 2008 Express Pin
Paul Conrad30-Jun-08 7:05
professionalPaul Conrad30-Jun-08 7:05 
QuestionStored procedure = Unit of work? Pin
AliasElias30-Jun-08 2:00
AliasElias30-Jun-08 2:00 
AnswerRe: Stored procedure = Unit of work? Pin
Mike Dimmick30-Jun-08 3:05
Mike Dimmick30-Jun-08 3:05 
GeneralRe: Stored procedure = Unit of work? Pin
AliasElias30-Jun-08 12:11
AliasElias30-Jun-08 12:11 
QuestionHow to monitor query in Pervasive.sql . Please help me it is very urgent for me Pin
Akash Agarwal29-Jun-08 23:59
Akash Agarwal29-Jun-08 23:59 
Questionselect count query(2 field) Pin
kabirkhan29-Jun-08 20:06
kabirkhan29-Jun-08 20:06 
AnswerRe: select count query(2 field) Pin
meeram39530-Jun-08 0:28
meeram39530-Jun-08 0: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.