Search results for query: *

There is a significant difference in table schemas in GP10 vs GP8. It is designed to integrate with Sharepoint and Office 2007, so is very denormalized. When we upgraded from 9.0 to 10, it took 18 hours to convert the tables and do the upgrade. Our database was 32GB in size, so fair warning...

SELECT * from new_alloys_added_by_users left join ratings_for_fz_scores on new_alloys_added_by_users.Alloy_ID_No = ratings_for_fz_scores.Alloy_ID_No AS NewAlloysAndRatings SELECT * FROM user_prefs_for_alloys JOIN new_alloys_added_by_users ON user_prefs_for_alloys.Alloy_ID_No =...

We upgraded GP from 9.0 to 10.0 and at the time of the upgrade, left off Smart List Builder. We need to install it now, but when we try we get an error stating "unable to find GreatPlains.msi" -- well, we're using the CD and this file is clearly there. We've tried the fix at...

There will be no exact match from the text field of table a to the code description field in b, so I just have to find the best match. To do this, I will need to separate out the words of the text field in a then count the matches against each of the words in the description field of table b...

Table a has identity column and a text field table b has a description and a code I need to return the code from table b where the best match to that text field in table a exists. Any suggestions on the best way to accomplish this? Thanks in advance!

This is easily accomplished by using an SSIS package task, but there is a forum specifically for SSIS questions, so I would pose it there.