Click here to Skip to main content
11,408,708 members (65,934 online)
   

Database

 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 20:08 
AnswerRe: sql server table records to sqlite Pinmember_Damian S_27-Feb-13 20:15 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 3:40 
AnswerRe: sql server table records to sqlite PinmvpEddy Vluggen28-Feb-13 10:25 
QuestionRe: sql server table records to sqlite Pinmemberjojoba20111-Mar-13 21:23 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 19:50 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 19:55 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 20:28 
GeneralRe: sql server table records to sqlite Pinmemberjojoba201127-Feb-13 20:43 
GeneralRe: sql server table records to sqlite PinmemberMycroft Holmes27-Feb-13 20:51 
QuestionRe: sql server table records to sqlite Pinmemberjojoba201128-Feb-13 3:41 
AnswerRe: sql server table records to sqlite PinmemberMycroft Holmes28-Feb-13 12:34 
Questionsql server 2008 query, Pinmembergavindon27-Feb-13 16:57 
AnswerRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 17: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, Pinmembergavindon27-Feb-13 18:14 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 18:34 
AnswerRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 19:45 
GeneralRe: sql server 2008 query, Pinmember_Damian S_27-Feb-13 19:53 
GeneralRe: sql server 2008 query, PinmemberMycroft Holmes27-Feb-13 20:26 
AnswerRe: sql server 2008 query, Pinmembergvprabu28-Feb-13 22:28 
QuestionSQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 16:21 
AnswerRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 20:27 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 20:57 
GeneralRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 21:06 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 21:47 
QuestionWhat order to be followed while generating schema upgrade script? PinmemberMember 313707826-Feb-13 19:10 
AnswerRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 21:01 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMember 313707827-Feb-13 22:40 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 23:15 
QuestionSQL weirdness when aliasing columns PinmemberGregory.Gadow22-Feb-13 12:19 
AnswerRe: SQL weirdness when aliasing columns Pinmembergvprabu22-Feb-13 19:18 
AnswerRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes24-Feb-13 14:08 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow28-Feb-13 10:09 
GeneralRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes28-Feb-13 13:04 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow1-Mar-13 6:10 
AnswerSolution PinmemberGregory.Gadow1-Mar-13 10:28 
GeneralRe: Solution PinmemberMycroft Holmes1-Mar-13 12:53 
QuestionDatabase PinmemberMember 961179522-Feb-13 9:52 
AnswerRe: Database Pinmemberjschell22-Feb-13 10:30 
AnswerRe: Database Pinmembermark merrens22-Feb-13 11:38 
GeneralRe: Database PinmemberMember 961179523-Feb-13 2:05 
GeneralRe: Database PinmemberS Douglas28-Feb-13 8:58 
AnswerRe: Database PinmemberJörgen Andersson22-Feb-13 12:11 
AnswerRe: Database PinmemberPIEBALDconsult22-Feb-13 14:38 
QuestionSQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 19:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmvpSandeep Mewara21-Feb-13 20:00 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmemberMycroft Holmes21-Feb-13 21:29 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 23:11 
QuestionDual Primary Key? PinmemberRichard.Berry10021-Feb-13 7:25 
AnswerRe: Dual Primary Key? PinmvpEddy Vluggen21-Feb-13 8:10 

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
Web01 | 2.8.150414.5 | Last Updated 24 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid