	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

11/04/2009 at 02:06PM PST, ID: 24872706 | Points: 500

	[x] Attachment Details

pull data from intranet to display on live server.

Asked by russ587 in SQL Server 2005

Tags: ms sql

hi,

in our office, we use greatplains. i would like to display product price and available stock qty on our website for our sales reps to view. the company that manages the greatplanes software for us have created a sql view with the rqd info. now the upstream bandwidth in south africa is very very slow so calling data on each request will probably be very slow. what is the best way to do this.

russ

View the Solution FREE for 30 Days

20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625

1. aneeshatti...1,614,900
2. rrjegan171,519,886
3. angelIII1,463,953
4. chapmandew932,604
5. RiteshShah654,791
6. BrandonG...623,489
7. mark_wills573,509
8. reb73484,935
9. mwvisa1474,916
10. acperkins424,181
11. ralmada390,602
12. CGLuttrell390,185
13. matthews...310,006
14. Sharath_...300,365
15. JestersGrind233,831
16. tigin44223,338
17. pssandhu211,636
18. EugeneZ203,354
19. udayakum...200,308
20. pcelba197,296
21. momi_sa...194,257
22. DanielWilson190,783
23. prabhakar...187,610
24. St3veMax184,897
25. brejk181,029

1. angelIII5,051,718
2. chapmandew3,733,125
3. aneeshatti...2,761,606
4. rrjegan171,519,886
5. mark_wills1,403,775
6. BrandonG...1,324,338
7. mwvisa1922,372
8. acperkins820,148
9. momi_sa...681,226
10. RiteshShah654,791
11. matthews...610,554
12. appari586,119
13. dtodd555,876
14. dqmq547,704
15. ptjcb545,683
16. Yveau539,545
17. DanielWilson521,282
18. EugeneZ502,648
19. reb73484,935
20. brejk449,023
21. PFrog404,802
22. PedroCGD404,474
23. ralmada392,602
24. CGLuttrell390,185
25. imitchie352,938