sql server - What's the best practise to write SQL to get data as follow? -

-

I have SQL Server 2005. The following two tables in DB 2 "User Infomeshn" ---> (ID ( Auto), name, gender (bit)) 1 "competitor" ---> (ID (auto), Ugraidi (user Instameshn. ID FK), status (Tinint)
I wanted to store my process That data comes back - Status - Male calculation - Female calculation - & nbsp; & nbsp; & nbsp; & nbsp; 1 & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; Nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; 45 & nbsp; nbsp; & nbsp; & nbsp; & nbsp; & Nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; 15 < Br> & nbsp; & nbsp; nbsp; & nbsp; nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; 10 & nbsp; & nbsp; & nbsp; 10 & nbsp; 10 & nbsp; nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & Nbsp; & nbsp; & nbsp; & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; 50
& nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; 3 & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; 20 & nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp; & Nbsp;

p>, COUNT (Competitors.ID) as MaleCount, (select count (C.ID) C, where the competitors as UserInfomration as UI UI.UserID = C.UserID and 0 UI.UserGender = and C .Status = Competitors.Status) as FemaleCount, (MaleCount + FemaleCount) Total UserInfomration be Competitors.Status competitors, UserInfomration.UserGender Left UserInfomration.UserID = ISEFCompetitors.UserID Group as external (UserInfomration.UserGender = 1 ) By joining Competitors.Status

Thank you in advance for your expected cooperation

You can try something like this 

  SELECT c .Status, sUM (case when Ukjender = 0 then 1 ELSE 0 eND) guy, --assuming 0 M is the sum (case when UkGender = 1 then 1 and 0 at the end) I --assuming 1 competitors within c The woman is joined by UserInfomration u on c.UserID = u.ID c.Status

Comments

Post a Comment

Popular posts from this blog

MVP, design question -

-
I am working on an MVP designated application and there are some design questions: I presenter how to communicate while writing code in the layer Should go between different presenters / ideas? Let's say I have a window window with a window viewer and I want to set the window title on the window from the second window. I have a title-setter on the window view, which wraps the actual Gui title. Should I call the title-setter directly on the scene (window viewer.tit = "title") or should I wrap the view title as the presentation title setter (window-creator.tit = "title")? Ask yourself how you will test it? If you do a window presentation. View. Tight = "Title", how can you test that the presenter is setting the title?
Read more

excel - Populate list via a bi-Condition -

-
I'm interested in implementing something but I'm not sure it would be possible and would like to take it on. This is my scenario: I will have two verification cells, which will be shown as a list, from which I will select. This is my condition that I want to remember and remember my list from a database. I have a list of agents, which has been thrown at B13: B23 and the next two, I have columns of data that assume that my data base looks like this bcdx | Y Z Agent 1 1 | 1 | 0 Agent 2 0 | 1 | 0 Agent 3 0 | 1 | 1 agent 4 1 | 0 | 0 ... I want to populate a list named agent from column B, when I verify cell 1: x and verification cell 2: 1 I choose from. It should only show an agent in column X with column: agent1 agent4 or 0 ... I read somewhere Array formula but I do not know if this is convenient and I have unfortunately not any background in the macro :( But I know C ++ is quite easy with some conditional statement like this. Advance Thanks, This
Read more

iphone - How do I make a UIPickerView in a UIActionSheet -

-
Just want to know how I will create UIPickerView in a UIActionSheet with a simple array. Well, I really know how to put it in an action sheet but I like my way because it is more for my app, thanks, but I I also want to know how to put options in UIPKviewView, I just have an array with colors already on top of that part: red, green, blue, yellow, black, etc. in this, but I want to know how it In the preview d L'be if I am using the already Instifrem:? Please help anyone. I know that this is a stupid question, but I'm cheating my head on my $$$$$$ MacBook. Instead you want to do this, create your UIPickerView interface builder and have it in your view controller Connect to the outlet. Add it as a subview of your main view and set its frame coordinates so that it is offset right below the edge, x = 0, y = 480 Then, when you want to display a picker, animate it like something with the screen: [UIView startup permissions: zero reference: zero]; [Color picture setfr
Read more