|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2011-03-08 : 10:16:50
|
| I have this select statment and I need to create a view from it. Where should I start?USE SCPGOSELECT district.districtid AS [District ID], district.name AS [Long Name], dbo.district.ShortName AS [Short Name], dbo.district.SupervisoryDistrict AS [Sup Dist], dbo.district.SupervisoryDistrictId AS [Sup Dist ID], address_1.addressid AS [P Address ID], ADDRESS.address1 AS [P Address 1], ADDRESS.address2 AS [P Address 2], ADDRESS.city AS [P City], ADDRESS.state AS [P State], ADDRESS.zip10 AS [P Zip], ADDRESS.addressid AS [M Address ID], ADDRESS.county AS [M County], address_1.address1 AS [M Address 1], address_1.address2 AS [M Address 2], address_1.city AS [M City], address_1.state AS [M State], address_1.zip10 AS [M Zip], ADDRESS.phone AS Phone, ADDRESS.fax AS Fax, district.website AS Website, district.music_supervisor AS [Music Supervisor], district.office_contact AS [Office Contact], dbo.RelationshipManager.Location AS [Rel Mgr ID], dbo.location.location_name AS [Rel Mgr Name], dbo.location.store_outlet_whs AS [Rel Mgr Type], RIGHT(dbo.location.location_type, 1) AS [Rel Mgr Sub Type], dbo.RelationshipManager.RelationshipTypeId AS [Rel Type Id], dbo.RelationshipType.RelationshipType AS [Rel Type], dbo.RelationshipManager.Commissions AS [Rel Comm], district.districtstart_from AS [Start Date From], district.districtstart_to AS [Start Date To], district.districtend_from AS [End Date From], district.districtend_to AS [End Date To], dbo.district.BudgetEnd AS [Budget End Date], district.tax_rate AS [Tax Rate], dbo.location.Regional_Manager_Number AS [RM ID], dbo.location.Regional_Manager_Name AS [RM Name], dbo.location.district_manager_number AS [DM ID], dbo.location.District_Manager_Name AS [DM Name], district.active AS Active, district.duplicate_districtid AS [Primary ID], district.create_admin_userid AS [User Created], district.last_admin_userid AS [User Modified], district.createDate AS [Date Created], district.lastModDate AS [Date Modified], district.externalSystemId AS [MTD District ID], _MAA_Dist.PARENT_PIN AS [MTD Master District ID], _MAA_Dist.COMPANY AS [MTD Name], _MAA_Dist.P_ADDRESS AS [MTD P Address], _MAA_Dist.P_CITY AS [MTD P City], _MAA_Dist.P_STATE AS [MTD P State], _MAA_Dist.P_ZIP AS [MTD P Zip], _MAA_Dist.P_CO_CODE AS [MTD P Co Code], _MAA_Dist.ADDRESS AS [MTD M Address], _MAA_Dist.CITY AS [MTD M City], _MAA_Dist.STATE AS [MTD M State], _MAA_Dist.ZIP AS [MTD M Zip], _MAA_Dist.CO_CODE AS [MTD M Co Code], _MAA_Dist.PHONE AS [MTD Phone], _MAA_Dist.FAX AS [MTD M Fax], _MAA_Dist.WEBSITE AS [MTD Website], _MAA_Dist.OPENDATE AS [MTD Start Date Range], _MAA_Dist.CLOSEDATE AS [MTD Close Date Range], _MAA_Dist.NUMSCHCODE AS [MTD Num Schools Code], _MAA_Dist.NUMSCHOOLS AS [MTD Num Schools], _MAA_Dist.ENR_LEVEL AS [MTD Enrollment Level], _MAA_Dist.ENROLLMENT AS [MTD Enrollment], _MAA_Dist.CITYPOP AS [MTD City Population], _MAA_Dist.WEALTH_IDX AS [MTD Wealth Index], _MAA_Dist.NEWDIST AS [MTD New District], _MAA_Dist.CLOSED AS [MTD Closed], _MAA_Dist.lastModDate AS [MTD Date Updated], district.PreferenceId AS [District Pref ID]FROM dbo.location FULL OUTER JOIN dbo._MAA_Dist RIGHT OUTER JOIN dbo.district LEFT OUTER JOIN dbo.address ON dbo.district.districtid = dbo.address.scp_id LEFT OUTER JOIN dbo.address AS address_1 ON dbo.district.districtid = address_1.scp_id ON dbo._MAA_Dist.DIST_PIN = dbo.district.externalSystemId LEFT OUTER JOIN dbo.RelationshipManager ON dbo.district.RelationshipManagerId = dbo.RelationshipManager.RelationshipManagerId LEFT OUTER JOIN dbo.RelationshipType ON dbo.RelationshipManager.RelationshipTypeId = dbo.RelationshipType.RelationshipTypeId ON dbo.location.location = dbo.RelationshipManager.LocationWHERE (ADDRESS.scp_typeid = 1 OR ADDRESS.scp_typeid IS NULL) AND (ADDRESS.scp_address_typeid = 1 OR ADDRESS.scp_address_typeid IS NULL) AND (address_1.scp_typeid = 1 OR address_1.scp_typeid IS NULL) AND (address_1.scp_address_typeid = 2 OR address_1.scp_address_typeid IS NULL) AND (dbo.RelationshipManager.IsHidden = 0) GO |
|
Select Statement to Create a View