you need to have a master table for locations like
Location LocCode
TEXAS Tx
NewJersey NJ
North Carolina NC
....
and then use like
SELECT lm.Location,
COALESCE(i.Items ,0) AS Items
FROM LocationMaster lm
LEFT JOIN ItemsByLocation i
ON i.Location = lm.LocCode
AND i.date= @date
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
To retrive a row even it has no data
Posted - 06/04/2012 : 10:09:22
