USE [gatradeforms_dev]
GO
/****** Object:  StoredProcedure [dbo].[usp_userQuestions_R]    Script Date: 02/15/2012 19:00:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_userQuestions_R]
AS
SET NOCOUNT ON
SELECT UserId, UserName,
[12E574D0-A991-4C9C-83BC-944D1FEF8041] as [First Name],
[B56192FB-9337-47B9-8FD6-8016F9E6AF7D] as [Last Name],
[1634D0FB-CB3F-441E-A5CE-6F71D80B5DCD] as [Username],
[CC23F214-2863-43BE-B72F-E746D914D454] as [Display Name],
[4AF367F4-F846-404A-A203-B6564D50B1F7] as [Email Address],
[FCA3EB39-4920-42CA-B6F9-56427AE21BD0] as [Company Name],
[926156B4-B950-466F-A865-D3B1F63069F6] as [Business Address],
[B410C684-7819-4E45-B6CE-B76B20A61FEF] as [City],
[F721444F-0160-4E48-9585-6DE0FCBA6400] as [State],
[7623DEBB-0788-4989-A3EB-0F203052DD81] as [Zip Code],
[C0A98210-D757-4696-B7CB-31E9A3B556AE] as [Georgia County],
[CA61B664-3507-4C03-B08A-49B91AEF3470] as [Website address:],
[7396CE9B-B06C-4E5E-B7F0-A69D32511A69] as [Name of Company International Trade Contact in charge of international sales & marketing],
[7436255B-EE92-4007-9E7F-40F78E72DA45] as [Title],
[AB436ED0-63E6-4905-A14C-9E8309B279B4] as [Work Phone],
[A9956F51-ADA3-4C8F-B9EE-DF358A1D0E11] as [Cell Phone],
[53519089-0DE4-402D-B85E-05DA7C732CC1] as [Indicate which type(s) of operations you have in Georgia],
[F045A7CD-03D1-41E9-9345-A0C870AC5C9F] as [Other (specify)],
[81E94993-6780-4504-90D8-60616C6D66DF] as [Year Established],
[1AE05E65-DD74-4AC5-B94A-14BF7133CA42] as [If you can provide this information, 2010 Total Revenues],
[AD02A029-4A93-4D6C-9A06-6F201E5211BA] as [If you can provide this information, Year-to-Date Total Revenues],
[3B0088B2-5075-42D2-A499-7EB20C36FFE0] as [What percentage of your annual sales stems from exports?],
[84499356-963F-4540-81BE-B08C357E9A56] as [Based on U.S. operations, did your company operate profitably in its most recently-completed fiscal year?],
[0774AD48-CDC0-428C-B468-CBF3AD8AC3F3] as [What percentage of your annual budget is allocated to exporting?],
[D0CC131B-613F-457D-B420-A76AED59156D] as [Total number of employees in Georgia],
[5FFB72B6-0135-4DC6-8A0D-D5339C77DBFA] as [Number of employees (or full-time equivalents) dedicated to exporting],
[03FA241B-48F7-48BA-8D90-D0FA0412501D] as [If you do not have full-time, dedicated export staff, what percentage of your and/or your employees’ time is dedicated to export],
[18F47D36-998E-4DC1-8C10-3F62CB55B885] as [What specific export training or skills do you or your staff have?],
[7C181503-707F-40CB-9ED2-414F0F83A9E1] as [Does your staff have foreign language capabilities?],
[4395C611-C979-4F9D-97DA-24B4875B4268] as [If so, in which languages?],
[FDA38B11-53C5-45E4-975B-EE07611360C7] as [Are your website and/or marketing materials available in foreign languages?],
[0A3E04D1-C5FF-44E5-A28B-92B87CE2794B] as [If so, in which languages?],
[3F003C94-3A0B-4254-AF0D-4234AD2563F6] as [Do you qualify as a small business under SBA guidelines?],
[5B926A76-1600-4FB9-BADF-02F316A3F7C5] as [Is your company in good standing in the State of Georgia?],
[2F5D19AB-AB95-4BAD-A305-D2B8FA4A5698] as [Do you have an active business license?],
[0D1C41B1-CED2-46F4-8C53-A506435FDAE7] as [Does your company owe any local, state or federal back taxes?],
[34E015BF-13E7-43BB-B547-196045E1AF5A] as [If YES, please explain],
[99EC561A-E9B1-48F6-9E15-A349E657E097] as [Are your U.S. operations currently operating profitably?],
[3A0E0CE7-8F1B-4340-9C3E-CA8A30FC3472] as [If NO, please explain],
[4BEF1241-19C9-4FC2-95DD-F4657942620D] as [Have you previously exported?],
[24575112-C4E6-403A-A841-EF552E394E6C] as [If "yes", how long have you been exporting?],
[335F012C-12CA-4469-863E-59EB412ACA67] as [If "yes", what percentage of your sales is exported?],
[90B4B3D3-02C4-483A-9C3B-FF35B8443CE8] as [If "yes", to which countries do you currently export?],
[95739B69-A6DB-47A0-A5EC-350766B4DC6E] as [If “no”: Documentation must be attached to this Application to demonstrate and support Applicant’s understanding of the costs as],
[AA8DA6E6-7889-4FC3-9525-2BED4B51F5C3] as [Do you have in effect a strategic plan for exporting?],
[F2D8EDF1-47E7-456F-93E6-DE067939219B] as [If no, please explain why you decided to export and how you have chosen: which products/services to be exported, your export pri],
[1BD5212E-9E61-49E4-A373-3A88B64404C1] as [What are your target export markets for the next 6-18 months?],
[4BE1C64B-3026-4413-86B1-299CB6E82C30] as [Please indicate if you are currently working, or have worked in the past, with any of the following agencies or organizations wi],
[1652BEBD-A5FE-47F3-816A-ABD4DD2D858C] as [New Registration Field],
[866FC525-7A7A-4D08-8348-EFA381CB3BFC] as [Company and product overview (50 word max)],
[97D0E38B-9AD4-44B8-BF30-AC9856534DB8] as [Which products or product lines have you been most successful, or are the most interested, in exporting and why?],
[CD91B517-868C-459C-9603-23E0F93D13E5] as [What are the main competitive advantages of these products or product lines?],
[AF8322F8-F269-4DD3-9521-0D18EA7F0C14] as [Who are your three top U.S. and international competitors?],
[EDFA8022-2258-4CB3-B959-05B89157C56D] as [What are the major industries that use your products/services?],
[2BB52A96-9E5B-4135-955E-0B991A44D3B8] as [If known, what are the Schedule B (Harmonized Schedule) Number(s) for your product(s) to be exported?],
[AD871E7D-93A3-4FD8-A219-3CAE030908C1] as [If known, what are the NAICS Codes for your products or services to be exported?],
[0D48F917-CEAD-48A8-BC59-886B0B5B6EC0] as [If applicable, list the certification(s) that your company currently has including, but not limited to ISO Certification, CE Mar],
[32F2A7FF-8A9E-40D4-9467-D77D708B193E] as [Please attach copies of any DBE or WBE certifications],
[7CD79DDF-3F61-430C-8F5E-ADA1E40C994A] as [In which Program activities would you like to participate? (check all that apply)],
[2308B735-AA11-4490-B370-D3DB02B43E40] as [Name of trade show/trade mission],
[EEA71CE7-AC8E-452E-BDAA-324F6A8C9EDF] as [Date and Place of trade show/trade mission],
[A251E4B7-92B5-4454-BBF9-0AD3C77A73F1] as [Meet with incoming foreign buyers’ delegation(s)],
[CA31AF19-0F7D-456B-9191-B0D38D5F063C] as [Date and Place (foreign buyers’ delegation)],
[22EE1290-806E-47BC-840C-AABC8339A1A8] as [Participate in meeting(s) with international experts],
[020110E7-0C2E-4560-9094-88892B54995F] as [Date and Place (international experts)],
[841B58F7-2AED-4C68-83B1-CD3BF5895CE6] as [Gold Key Service (U.S. Commercial Service) or similar service],
[3BE50041-AD5A-4CF7-95DC-8E5A3B10700B] as [Name of country (Gold Key Service)],
[C070CDFC-C00A-416C-AA4F-ECAB76139E90] as [International Partner Search service (U.S. Commercial Service) or similar service],
[7DFFC1EC-C4FD-4B1C-A361-E3EE0E41B14C] as [Name of country (International Partner Search)],
[61A9AB05-7999-4424-B70B-793B42F9CE1D] as [China Initiative],
[2DFE98C6-1037-477C-A6A7-B9CB18DD3C9A] as [Export Research],
[D2D4295D-918B-4240-A2BD-620F745F3B23] as [Other],
[BC5D2218-4870-43E9-9CB0-791DB9539A1C] as [Other (describe)],
[BCEED6AC-F9EB-425C-B19D-08CC1883DF96] as [<p style="line-height: 14pt;">&nbsp;</p>  <p style="line-height: 14pt;">For the above ],
[2C6F7411-39BF-465E-8873-185377F91583] as [Signature Applicant Representative (digital)],
[2FC4063C-E5BE-4AAB-96E5-1CE8217DE5B6] as [Printed Name],
[D9C05632-6128-40AD-9255-4E0ABEB0FE69] as [Title],
[23168323-56E6-423C-B9DD-5F4004F5E8ED] as [Date]
FROM
(select uu.UserName, drqr.UserID, DynamicQuestionID, COALESCE(Response,'---') as [Response] FROM DynamicRegistration_QuestionResponse drqr join Users uu on drqr.userID = uu.UserID) as SourceTable
PIVOT
(
    MIN(Response) FOR DynamicQuestionID IN (
[12E574D0-A991-4C9C-83BC-944D1FEF8041],
[B56192FB-9337-47B9-8FD6-8016F9E6AF7D],
[1634D0FB-CB3F-441E-A5CE-6F71D80B5DCD],
[CC23F214-2863-43BE-B72F-E746D914D454],
[4AF367F4-F846-404A-A203-B6564D50B1F7],
[FCA3EB39-4920-42CA-B6F9-56427AE21BD0],
[926156B4-B950-466F-A865-D3B1F63069F6],
[B410C684-7819-4E45-B6CE-B76B20A61FEF],
[F721444F-0160-4E48-9585-6DE0FCBA6400],
[7623DEBB-0788-4989-A3EB-0F203052DD81],
[C0A98210-D757-4696-B7CB-31E9A3B556AE],
[CA61B664-3507-4C03-B08A-49B91AEF3470],
[7396CE9B-B06C-4E5E-B7F0-A69D32511A69],
[7436255B-EE92-4007-9E7F-40F78E72DA45],
[AB436ED0-63E6-4905-A14C-9E8309B279B4],
[A9956F51-ADA3-4C8F-B9EE-DF358A1D0E11],
[53519089-0DE4-402D-B85E-05DA7C732CC1],
[F045A7CD-03D1-41E9-9345-A0C870AC5C9F],
[81E94993-6780-4504-90D8-60616C6D66DF],
[1AE05E65-DD74-4AC5-B94A-14BF7133CA42],
[AD02A029-4A93-4D6C-9A06-6F201E5211BA],
[3B0088B2-5075-42D2-A499-7EB20C36FFE0],
[84499356-963F-4540-81BE-B08C357E9A56],
[0774AD48-CDC0-428C-B468-CBF3AD8AC3F3],
[D0CC131B-613F-457D-B420-A76AED59156D],
[5FFB72B6-0135-4DC6-8A0D-D5339C77DBFA],
[03FA241B-48F7-48BA-8D90-D0FA0412501D],
[18F47D36-998E-4DC1-8C10-3F62CB55B885],
[7C181503-707F-40CB-9ED2-414F0F83A9E1],
[4395C611-C979-4F9D-97DA-24B4875B4268],
[FDA38B11-53C5-45E4-975B-EE07611360C7],
[0A3E04D1-C5FF-44E5-A28B-92B87CE2794B],
[3F003C94-3A0B-4254-AF0D-4234AD2563F6],
[5B926A76-1600-4FB9-BADF-02F316A3F7C5],
[2F5D19AB-AB95-4BAD-A305-D2B8FA4A5698],
[0D1C41B1-CED2-46F4-8C53-A506435FDAE7],
[34E015BF-13E7-43BB-B547-196045E1AF5A],
[99EC561A-E9B1-48F6-9E15-A349E657E097],
[3A0E0CE7-8F1B-4340-9C3E-CA8A30FC3472],
[4BEF1241-19C9-4FC2-95DD-F4657942620D],
[24575112-C4E6-403A-A841-EF552E394E6C],
[335F012C-12CA-4469-863E-59EB412ACA67],
[90B4B3D3-02C4-483A-9C3B-FF35B8443CE8],
[95739B69-A6DB-47A0-A5EC-350766B4DC6E],
[AA8DA6E6-7889-4FC3-9525-2BED4B51F5C3],
[F2D8EDF1-47E7-456F-93E6-DE067939219B],
[1BD5212E-9E61-49E4-A373-3A88B64404C1],
[4BE1C64B-3026-4413-86B1-299CB6E82C30],
[1652BEBD-A5FE-47F3-816A-ABD4DD2D858C],
[866FC525-7A7A-4D08-8348-EFA381CB3BFC],
[97D0E38B-9AD4-44B8-BF30-AC9856534DB8],
[CD91B517-868C-459C-9603-23E0F93D13E5],
[AF8322F8-F269-4DD3-9521-0D18EA7F0C14],
[EDFA8022-2258-4CB3-B959-05B89157C56D],
[2BB52A96-9E5B-4135-955E-0B991A44D3B8],
[AD871E7D-93A3-4FD8-A219-3CAE030908C1],
[0D48F917-CEAD-48A8-BC59-886B0B5B6EC0],
[32F2A7FF-8A9E-40D4-9467-D77D708B193E],
[7CD79DDF-3F61-430C-8F5E-ADA1E40C994A],
[2308B735-AA11-4490-B370-D3DB02B43E40],
[EEA71CE7-AC8E-452E-BDAA-324F6A8C9EDF],
[A251E4B7-92B5-4454-BBF9-0AD3C77A73F1],
[CA31AF19-0F7D-456B-9191-B0D38D5F063C],
[22EE1290-806E-47BC-840C-AABC8339A1A8],
[020110E7-0C2E-4560-9094-88892B54995F],
[841B58F7-2AED-4C68-83B1-CD3BF5895CE6],
[3BE50041-AD5A-4CF7-95DC-8E5A3B10700B],
[C070CDFC-C00A-416C-AA4F-ECAB76139E90],
[7DFFC1EC-C4FD-4B1C-A361-E3EE0E41B14C],
[61A9AB05-7999-4424-B70B-793B42F9CE1D],
[2DFE98C6-1037-477C-A6A7-B9CB18DD3C9A],
[D2D4295D-918B-4240-A2BD-620F745F3B23],
[BC5D2218-4870-43E9-9CB0-791DB9539A1C],
[BCEED6AC-F9EB-425C-B19D-08CC1883DF96],
[2C6F7411-39BF-465E-8873-185377F91583],
[2FC4063C-E5BE-4AAB-96E5-1CE8217DE5B6],
[D9C05632-6128-40AD-9255-4E0ABEB0FE69],
[23168323-56E6-423C-B9DD-5F4004F5E8ED]
)

) AS PivotTable
SET NOCOUNT OFF