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

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

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

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...

Hello I am doing a data migration project from SQL to SQL The new table has an identity column that must be started with a specific value. Using identity(int,1,1) and DBCC CHECKIDENT(TableName, RESEED, @mynewid), I can populate the table - BUT Is there a way that I can control the order...

Hello - I can only seem to get identity() to work if I type the # directly into it. identity(int,1,1) as sequence_no, instead of... identity(int,@mynewid,1) as sequence_no, from the example below ----------------------------------------------------------- declare @mynewid int execute...

Hello I am trying run a sql statement and place the result into a table. Below is my attempt to put the result in a variable I know I'm murdering the syntax - Am I close? Do I have the wrong concept? declare @SEQ_return as varchar(100) set @SEQ_return = select field from table -- returns 1...

Hello I can't figure out the following Write a SQL query for contact1, conatct2, & contsupp to pull company info, user defined field, and e-mail address. I want to include all records from contact1 & contact2 EVEN IF the record doesn't have an e-mail. So far, all I have is what is below...

Hello I want to insert a field from one table into another table. Something like... declare @s_number int set @s_number= select max(FIELD1)from TABLE1 select "truck", @s_number INTO TABLE2 I know the syntax is incorrect, the idea is to take a value from TABLE1 and insert it into TABLE2...

Hello I am running SQL 2K on Windows NT. I am having a problem restoring my database. When I right click on the database and select "Restore Database", Enterprise Manager freezes (Cntrl Alt Delete to "fix") I looked and the DB is 3,777 MB with a transaction log of 141 MB. This problem does...

Hello I am trying to insert a record that contains an incrementing #. The # to start with comes from another table (APP_NEXT_NUMBER in the example below). Current way that works but is ugly... select DCT.CUSTOMER_ID as 'master_customer_id', identity(int,2464262,1) as sequence_no into...

Hello I am trying to use the IDENTITY function like.... insert into USR_COMPANY_HISTORY select DCT.CUSTOMER_ID as 'master_customer_id', '0' as 'sub_customer_id', identity(int,2464262,1) as sequence_no, DCT.USR_DATASOURCE, DCT.USR_USERID, 0 as concurrency_id, null as prospect_id from...

hello - I am trying to troubleshoot a data migration project and want to verify a SQL statement. select pt.field1, ct.address2, ct.contsupref from child_table ct join parent_table pt on ct.accountno=pt.accountno right join verify_table vt on pt.field1=vt.field1 where ct.contact='E-mail...

Hello I am in the process of a SQL data migration project. I am transfering the conthist records to another table that will include the contact. The contact may either be the primary (contact1) or a secondary (contsupp) from Goldmine. Conthist contains the contact in the reference after "oc:"...

thread183-974713 Error converting data type varchar to numeric. Hello If someone could help I would be grateful - this error is driving me nuts. I am trying to insert data from 1 table into another. I can't fiind the conversion problem and have replaced the fields in the receiving table to...

Hello GM 5.5 - A user is getting [PROJECT]_OpenDoc : Init ERROR:28:Out of stack space Does anyone know where I can get an upgraded word link for Word 2003 I don't have access to a reseller, any help would be appreciated. Thanks Dave