Click here to Skip to main content
12,406,342 members (70,692 online)
   

Database

 
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 
GeneralRe: sql server 2008 query, Pin
gavindon27-Feb-13 17:14
membergavindon27-Feb-13 17:14 
That didn't quite work but it did set me on the right train of thought and for that I thank you much.
Solved with a couple of simple views combined in a query and let the SSRS report handle the count..
And I can easily reuse the views in a couple of other reports for different level of management..
Treat stressful situations like a dog, if you can't eat it, play with it or screw it, then just piss on it and walk away.

Be careful which toes you step on today, they might be connected to the foot that kicks your butt tomorrow.

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 
AnswerRe: SQL weirdness when aliasing columns Pin
Mycroft Holmes24-Feb-13 13:08
memberMycroft Holmes24-Feb-13 13:08 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160730.1 | Last Updated 28 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid