May 8th, 2012 By admin Categories: CRM
April 23rd, 2012 By admin Categories: CRM
April 7th, 2012 By admin Categories: CRM
March 22nd, 2012 By admin Categories: CRM

http://msdn.microsoft.com/en-us/library/gg309600.aspx

Contains nice code to retrieve multiple.

March 22nd, 2012 By admin Categories: CRM, Database

http://www.bennadel.com/blog/32-Getting-Group-By-Count-In-Left-Outer-Join.htm
http://forums.devshed.com/mysql-help-4/left-join-count-not-returning-rows-with-0-results-519406.html

SELECT

t.id,
t.name,
( ISNULL( COUNT(r.id), 0 ) ) AS reward_count,
( ISNULL( SUM(r.price), 0 ) ) AS price_sum,
( 0 ) AS reward_count_percent,
( 0 ) AS price_sum_percent

FROM

vendor_type t

LEFT OUTER JOIN

vendor_vendor_type_jn vtjn

ON

t.id = vtjn.vendor_type_id

LEFT OUTER JOIN

@reward r

ON

vtjn.vendor_id = r.vendor_id

GROUP BY

t.id,
t.name

 

  FROM Counties
LEFT OUTER
  JOIN Advertisers
    ON Advertisers.County_Code = Counties.County_Code
   AND Advertisers.Sub_Category_Code = '1110' 
March 21st, 2012 By admin Categories: CRM
March 12th, 2012 By admin Categories: CRM
March 9th, 2012 By admin Categories: CRM
March 1st, 2012 By admin Categories: CRM
February 14th, 2012 By admin Categories: CRM