Click here to Skip to main content
11,641,081 members (59,656 online)
   

Database

 
QuestionRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 18:55
memberjojoba201127-Feb-13 18:55 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:28
memberMycroft Holmes27-Feb-13 19:28 
GeneralRe: sql server table records to sqlite Pin
jojoba201127-Feb-13 19:43
memberjojoba201127-Feb-13 19:43 
GeneralRe: sql server table records to sqlite Pin
Mycroft Holmes27-Feb-13 19:51
memberMycroft Holmes27-Feb-13 19:51 
QuestionRe: sql server table records to sqlite Pin
jojoba201128-Feb-13 2:41
memberjojoba201128-Feb-13 2:41 
AnswerRe: sql server table records to sqlite Pin
Mycroft Holmes28-Feb-13 11:34
memberMycroft Holmes28-Feb-13 11:34 
Questionsql server 2008 query, Pin
gavindon27-Feb-13 15:57
membergavindon27-Feb-13 15:57 
AnswerRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 16:11
member_Damian S_27-Feb-13 16:11 
select sum(iif(FIELDNAME = 'Bundle', 1, 0)) as NumBundles,  
sum(iif(FIELDNAME = 'Bowed Board', 1, 0)) as NumBowedBoards,  
sum(iif(FIELDNAME = 'Jam', 1, 0)) as NumJams  
from TABLENAME

One option that doesn't rely on any rollup or compute magic...

GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 17:14
membergavindon27-Feb-13 17:14 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 17:34
member_Damian S_27-Feb-13 17:34 
AnswerRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 18:45
memberMycroft Holmes27-Feb-13 18:45 
GeneralRe: sql server 2008 query, Pin
_Damian S_27-Feb-13 18:53
member_Damian S_27-Feb-13 18:53 
GeneralRe: sql server 2008 query, Pin
Mycroft Holmes27-Feb-13 19:26
memberMycroft Holmes27-Feb-13 19:26 
AnswerRe: sql server 2008 query, Pin
gvprabu28-Feb-13 21:28
membergvprabu28-Feb-13 21:28 
QuestionSQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 15:21
member_Damian S_27-Feb-13 15:21 
AnswerRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 19:27
member_Damian S_27-Feb-13 19:27 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 19:57
memberMycroft Holmes27-Feb-13 19:57 
GeneralRe: SQL Server 2012 annoyance... Pin
_Damian S_27-Feb-13 20:06
member_Damian S_27-Feb-13 20:06 
GeneralRe: SQL Server 2012 annoyance... Pin
Mycroft Holmes27-Feb-13 20:47
memberMycroft Holmes27-Feb-13 20:47 
QuestionWhat order to be followed while generating schema upgrade script? Pin
Member 313707826-Feb-13 18:10
memberMember 313707826-Feb-13 18:10 
AnswerRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 20:01
memberMycroft Holmes27-Feb-13 20:01 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Member 313707827-Feb-13 21:40
memberMember 313707827-Feb-13 21:40 
GeneralRe: What order to be followed while generating schema upgrade script? Pin
Mycroft Holmes27-Feb-13 22:15
memberMycroft Holmes27-Feb-13 22:15 
QuestionSQL weirdness when aliasing columns Pin
Gregory.Gadow22-Feb-13 11:19
memberGregory.Gadow22-Feb-13 11:19 
AnswerRe: SQL weirdness when aliasing columns Pin
gvprabu22-Feb-13 18:18
membergvprabu22-Feb-13 18:18 

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
Web02 | 2.8.150731.1 | Last Updated 31 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid