October 7, 2008 09:37am pdt

1. WilyGuy 71,605
2. Biffster007 67,520
3. jd_wight 50,875
4. opster 33,350
5. bmosoftw... 30,200
6. Agrippine 16,200
7. gregowens 10,000
8. rakeshAg... 8,090
9. Maxi84 7,500
10. AndersHe... 7,000
10. victoria_y 7,000
12. rfgkev 5,450
13. whoajack 5,000
14. Robbie_L... 4,500
15. preitmeyer 4,000
16. croberds 3,200
17. hulitk 3,100
18. jgv 3,000
19. dtodd 2,800
20. EngSiong 2,500
21. TheCleaner 2,000
21. pboulos 2,000
21. JimboEfx 2,000
21. PaulShear... 2,000
21. boag2000 2,000
21. Snarf0001 2,000
21. wjester 2,000
21. JMorsch 2,000
21. mattbcs 2,000
21. ChiefIT 2,000
21. cuziyq 2,000
21. cmorffew 2,000
21. AtiaSoluti... 2,000
21. 50centos 2,000
21. gpiero74 2,000
21. imateyele... 2,000
21. cj_1969 2,000
21. TechSoEasy 2,000
21. Merete 2,000
21. aneeshatti... 2,000

1. WilyGuy 71,605
2. Biffster007 69,020
3. jd_wight 50,875
4. opster 35,850
5. rfgkev 34,975
6. bmosoftw... 30,200
7. Agrippine 16,200
8. bloodymal... 13,650
9. whoajack 12,500
10. preitmeyer 12,250
11. gregowens 10,000
12. TechSoEasy 9,000
13. rakeshAg... 8,090
14. Robbie_L... 7,500
14. Maxi84 7,500
16. victoria_y 7,000
16. AndersHe... 7,000
18. Dodgster 5,400
19. Chinmay... 4,400
20. DennisL 4,000
20. pmittal 4,000
22. JMorsch 3,500
22. Pioneermfg 3,500
24. croberds 3,200
25. hulitk 3,100

04.28.2008 at 09:44AM PDT, ID: 23359298

	[x] Attachment Details

How to combine History and Current data with same schema into one data field without creating a new table?

Asked by ENIAC1 in Microsoft Dynamics, MS SQL Server, SQL Server 2005

Tags: Microsoft, Excel Charting, Office 2007, SQL Database Mining, SQL, MS Query, Query Analyzer

I wish to create Excel Charts with 2 tables from SQL Server 2005 - one table Current Year data and the 2nd table Historical Data and both tables are the same schema. I would like to avoid creating a new table by combining the two into it. Is there a way to vertically stack the history and current data fields through joins, merge or Union without fields repeating? Ultimately the current and history field will update my Excel Charts each month when we close the GL data accounts in Dynamics GP accounting application each month. Thank you for your helpStart Free Trial

Keywords: How to combine History and Current d…

	Title
1	Windows 2003 R2 Schema extention
2	XML Schema inheritance (import / in…
3	schema replication.
4	information schema view
5	SCHEMA SPACE
6	Export schema

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

How to combine History and Current data with same schema into one data field without creating a new table?

Asked by ENIAC1 in Microsoft Dynamics, MS SQL Server, SQL Server 2005

Tags: Microsoft, Excel Charting, Office 2007, SQL Database Mining, SQL, MS Query, Query Analyzer

About this solution