Need SQL Query -Urgent

• Question

• 

  

  0

  Sign in to vote

  DB Structure:
  Date	Name	Particulars ID	Status
  5/5/2009	Sridhar	2233445566	Completed
  5/5/2009	Raj	5151515151	Pend
  5/5/2009	Venkat	8484848484	Route
  5/5/2009	Ashok	2424242424	Under Processing
  5/5/2009	Sridhar	84848898787	Completed
  5/5/2009	Raj	8788445498	Pend
  5/5/2009	Venkat	868454	Route
  5/5/2009	Ashok	78787978	Under Processing

  
  I need Query for the below Report
  
  

  Report :
  Date	Name	Completed	Pend	Route	Under Processing
  5/5/2009	Sridhar	2	0	0	0
  5/5/2009	Raj	0	2	0	0
  5/5/2009	Venkat	0	0	2	0
  5/5/2009	Ashok	0	0	0	2

  
  
  Thanks in Advance..........

  Wednesday, May 6, 2009 10:52 PM