sharepoint help

http://go4answers.webhost4life.com/Example/auto-populating-sharepoint-list-columns-129616.aspx

query to get the count of Male, count of female in a given city

Que : A table has following layout ; CITY, NAME , SEXHow do you write a query to get the count of Male, count of female in a given city XXX.Query result should be in a single row with count of male , count of female as columns?

Ans :-

-------------------------------------------------

SELECT CITY, COUNT(MALE), COUNT(FEMALE)
FROM
( SELECT  CITY,
  case  WHEN SEX='M' THEN  'M' ELSE NULL  END  MALE,
   case WHEN SEX='F'  THEN  'F'  ELSE NULL   END  FEMALE
   FROM TAB_PT
)
GROUP BY CITY

------------------------------------or-------------------------------------------------

select city,(count(case when gender = 'Male' then 1 else 0 end)) 'male',
(count(case when gender = 'Female' then 1 else 0 end)) 'female'
from table
where city = 'give the city'

WPF Questions and Answers

Que 1: - What is WPF and how it is better than Winforms?

Que 2 :- How to implement threading in WPF?

Que 3: - Explain one way, two way, one time & one way to source bindings?

Que 4 :- Explain UpdateSourceTrigger in WPF ?

Que 5 :- Explain WPF Resources ?

Que 6 :- What are WPF Value Converters ?

Que 7 :- Explain WPF multibindings and multivalueconverters ?

Que 8:- Explain logical tree, visual tree,routed events?

Que 9 :- What are WPF commands and INotifyPropertyChange interface ?

Que 10 :- Explain MVVM with a demonstration ?

Que 11 :- What are WPF styles and triggers ?

Que 12 :- What are various ways of doing alignment in WPF ?

Que 13 :- Differentiate between data templates and Control templates ?

Que 14 :- How are WPF observable collection different from .NET collections ?

Que  15:- Explain WPF object hierarchy?