Search results for query: *

Hello, Is anyone using GP 10 SP5 on SQL 2008 R2 SP3 or has anyone had any issues? Thanks Smatthews

This is the 1st time I have applied a patch to GP so please forgive me. I have applied SP5 to the server from my workstation and everything is fine. But when I try to apply the service pack to another workstation I am not getting a drop down for the update name. Also, the instructions say the...

Hello all I am looking for a little guidance as to the best way to handle this job. I have an Access 2010 db. I run a macro that creates a table in Access. I need to import the table into a SQL 2005 db. So my steps are: Run Access Macro Import the table that is created into a SQL database...

Hello, I am trying to create a query with a case statement with a where clause to take into account a fiscal year from 10/1/yyyy to 09/30/yyyy. For example, If the getdate month is between 1 and 6 then I need to pull people with the paid thru of 9/30/ + the current year. If the getdate month is...

Hello, We recently upgraded from SQL2k to SQL2005 and our DTS packages, we have two, run fine when I run them right from the Legacy folder created when we converted them after the upgrade but fail when they run as a job. This is the error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does...

We have triggers on 3 of our tables and when you change a column it gets dumped into 2 log tables by the triggers. When we upgraded from SQL2K to SQL2005 somehow the timestamp (which is actually the getdate()) is no longer being populated, it is now null. Not sure how that was working because...

Hello, We are using Dynamics 10 and had a very strange thing happen. We had a vendor with a primary address and we added an addressID called 'winter'. When we printed the check for this vendor it had the 'winter' street address and the city, state and zip from the 'primary' address. Any one...

Using SQL2k. Can someone please help. An individual can have more than one record in the Name_Address table. If there is a record with purpose ='publish' I need to return that record, otherwise the record that has preferred_mail =1 Only want one record per ID. n.id, n.full_name FROM name n...

Good Morning, We will be saving emails to be used as templates in a sql 2k database table. I could use a recommendation; should I use text or varchar and what size? The approximate size of the emails are about 2,000 characters including white space. Thanks!

Hello, I have a table called sections that has an id and nine checkboxes (bit fields.) Either 1 or 9 could be = true. I need to return a record with an id and if the checkbox is true then the name of that field. Example: from this: id1, section1, section2 (both checkboxes turned on) id2...

Has anyone had experience in moving data from a SQL2k server (internal) to a another SQL server that is hosted? A web server would run against this hosted SQL instance to provide authentication into a web site. We would love to have fully sync'd initially and then do instant updates to it if...

Hello, Our membership expires on 9/30, but there is a grace period until January. I am trying not to hardcode the date and just say: paid_through date >=getdate() so on October 1st these members will expire but they are actually still in the grace period. I can't seem to get the syntax...

Hello, Using v9.0 Under Transaction > Purchasing > Batches A user canceled a batch while it was building. It had some transactions (Invoices to be paid.) After, they canceled, they then deleted the batch. It now shows a status of "Work". We tried: Batch Recover - the batch does not appear. Run...

We have a dues notice that has been created as a pdf. Is there any way to use the pdf as a report/form? We will be pulling data for the form from Access. Thanks in advance for your help. Smatthews

I have a formula with an if statement that prints out a text line in a report. I would like to bold one word in the line. I have search through the forum and couldn't find anything that worked for me. I know that newer versions support html but I can't upgrade yet. Any suggestions? Thanks in...

Hello, I am able to concatenate multiple fields but I would like to put a comma between the fields. However if the field is blank I just get the comma. Also, I am converting a code to a word. Eg. A B C = Red,White,Blue A C = Red,Blue Any suggestions? Thanks in advance.

I have one group in my report printing a new page before. When I have odd page numbers for a group it prints a new page but on the previous group's report because I am duplexing. I used the remander function <> 0 but then my group header info prints on a page of it's own. Can someone help...

I am trying to move some fields from one table to another using INSERT INTO. The problem is that if three particular fields (multi field key) in a record are duplicated I only want one of the records in the 'to' table. Any suggestions as to the easiest way to accomplish this? Thanks in advance...

Can someone please help me with the syntax to create a multi column key that will eliminate duplicate records during an import if there is a combined duplicate latitude, longitude, and zip_code? CREATE TABLE mytable ( ZIP_CODE varchar(10) default NULL, CITY varchar(50) default NULL, STATE...

I am trying to get a total of member codes in columns instead of rows. Is there an easy way to do this? I have a region code and a member code and instead of this: Region MbrCode Total SW NATL 100 SW INTL 50 NE NATL 150 NE INTL 25...