Submitted by: Submitted by MommaCisko
Views: 374
Words: 536
Pages: 3
Category: Science and Technology
Date Submitted: 07/14/2012 10:28 PM
LTC SQL Server Database: Kudler Fine Foods
POS410: SQL for Business
August 23, 2010
William Ragin
TABLE OF CONTENTS
Query Formatted in the $ format - $##,###.## (La Jolla).................................................... 3
Query Formatted in the $ format - $##,###.## (Del Mar).................................................... 4
Query Formatted in the $ format - $##,###.## (Encinitas)................................................... 5
Query for First Two Digits with Break and Grand Total..................................................... 6
Method and Query Illustrating Name Change of La Jolla Store to San Diego................... 8
Query Illustrating Number of Accounts by Location............................................................ 9
Query Using Multiple Statements (COMPUTE, OR, IN, CAST, SUBSTR, etc.)............... 10
Entity Relationship Diagram (ERD) of Kudler Fine Foods Database.................................. 12
Query Formatted in the $ format - $##,###.## (La Jolla):
[pic]
[pic]
[pic]
This query illustrates the results of the La Jolla store in the requested format of ‘$’ and ‘,’ for the balance section. The purpose of this query was to add the ‘$’ and ‘,’ into the balance section instead of leaving it in the format of ‘xxxxx.’
Query Formatted in the $ format - $##,###.## (Del Mar):
[pic]
[pic]
[pic]
This query illustrates the results of the Del Mar store in the requested format of ‘$’ and ‘,’ for the balance section. The purpose of this query was to add the ‘$’ and ‘,’ into the balance section instead of leaving it in the format of ‘xxxxx.’
Query Formatted in the $ format - $##,###.## (Encinitas):
[pic]
[pic]
[pic]
This query illustrates the results of the Encinitas store in the requested format of ‘$’ and ‘,’ for the balance section. The purpose of this query was to add the ‘$’ and ‘,’ into the balance section instead of leaving it in...