Pos 410 Status File

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...