Search results for query: *

Hello I have fields (data type=decimal) to import into another field (data type=datetime) The format of the numeric field is YYYYMMDD (20060801) But, some of the numeric fields are equal to 0 or null. What is the proper syntax for an insert statement? Thanks in advance Dave

advanced and complex sql queries like this in goldmine?" Here is one I use to retrieve contacts and e-mails when the contact has an indicator on the refrence field select distinct key1 , c1.dear as 'Salutation', c1.contact as 'Contact', c2.contsupref as 'E-mail Address' from contsupp as c1...

Hi Ermer That sounds like it could get messy. You might be able to make a trigger that would update the fields tabl but it would sacrifice performance - if it would even work. You could look into Lookup.ini that would update another user defined field. Here is something similar that...

I created a stored procuedure that has worked well in query analyzer - sp_changename 'Mrs. Smith', 'Miss Smith' ....after she was married CREATE PROCEDURE sp_changename @newusername varchar(8), @oldusername varchar(8) AS update cal set userid = @newusername where userid=...

Hello I am using Excel 2002. I want to repeat the title, footer, and rows to repeat at the top for each sheet in a workbook. The sheets already have data in them. Any help on formatting all of the sheets in a workbook the same way would be appreciated. Thanks Dave

Thanks Rob - I tried that but it didn't work. I verified that it is the correct GM.INI by changing the default login through the intreface and then verifying th eGM.INI was written to. I made the GM.INI like this [GoldMine] GoldDir=MSSQL: distributorinfo: dbo: CommonDir=MSSQL...

Hello again - this is still an issue I cannot make Goldmine not remove the link from the original contact So if Andy has e-mail staff@yahoo.com and I want Bill to also have e-mail = staff@yahoo.com Goldmine won't allow it. I have tried changing the GM.INI and checked for the existance of...

Thanks Richard, that was driving me crazy. I must have put it in the INI file and didn't remember. I wish I hadn't because it caused a major headache. It works well, but it doesn't notify the user. If anyone is interested, below are 2 good INI references. Thanks again Dave...

Hello Using ver 5.7 Can anyone tell me how I change the following GM.INI setting in the interface? AllowDupEmails=0 Thanks Dave

Thanks Dennis - what is great about that example is that I can use it to explain to upper management. Priceless.

Hello From the thread I have learned There is a small chance the user will not be able to insert data, if they populate all of the fields, they could receive an error message and the INSERT or UPDATE will fail. I have the option of updating one table with a view. Normilization will improve...

Thanks George - I see the logic in what you are saying. Our customers are internal users who are pretty adamant about how and where they want the data displayed. In order to have it displayed on the screen the way they want - the field needs to be on the primary table. If I can come up with...

Hello I am with a company that is using a 3rd party software and adding many fields to the primary table. When adding more fields - message appears - Maximum row size (9457) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the row length...

Hello I am trying to get data in Example 1 to look like the data in Example 2 Example 1: field1 | field2 | field3 A B C to look like... Example 2: field1 | field2 A B A C Below is a sample of the code I used to get Example 1. How do I change this to give results...

Hello Does anyone have any methods they use for how to get to know a database quickly? I was asked to write views in a short amount of time and was not familiar with the data. I looked at other views to see how tables were linking, looked at indexes, record counts and basically fumbled around...

Hello I am making a mistake that I cannot see, hopefully someone can correct me. I want to have the same # of records returned when I join a table. What is the correct syntax? (should be below the comments I think) SELECT count(*) from MAIN_TABLE MT INNER JOIN FIRST_TABLE FT...

Hello I have a 3rd party application that uses an Infragistics grid. The application allows me to enter VB code on some events. I would like to have the grid sorted by the first column. Now, I can click a column on the grid and have the data sorted - I want to do the same thing but...

Right - "the sequence_no being the identity column." thats what I meant. LINE_NO is from the old data - I want to sort by LINE_NO - it already has data, I'm not repopulating it. Sorry about that, its hard to make clear

No, thats not it, the data would look like this Custno | LINE_NO | SEQUENCE_NO 123 | 1 | 456 123 | 2 | 457 123 | 3 | 458 456 | 1 | 459 456 | 2 | 460 456 | 3 | 461 but the way it comes out is like this Custno | LINE_NO | SEQUENCE_NO 123 | 2 | 456 123 | 1 | 457 123 | 3 | 458 456 | 2 | 459 456...

Hello jbenson001 - The line_no is varchar - it is changed for each customer. So it would be Custno | LINE_NO 123 | 1 123 | 2 123 | 4 456 | 1 456 | 2 456 | 3 druer - I'm populating the first table with before I call reseed, I put it in my first table with a statement similar to... SELECT...