Search results for query: *

Hi, I'm trying to open a blank data-entry form, but for some reason, when I open my form, there is already old data populated in all the fields. Data entry is set to "yes" in the property sheet. Any ideas? Cheers Neil

Gurus, I've got a table called "Jobs" containing an autonumber PK, called JobID which increments for every new row. I would like to create a new unique field called JobNumber, which is derived from the JobID column as follows: JobID JobNumber 1 APA00001 2 APA00002 3...

Sorry if this is a dumb question, but I cant find the answer anywhere on the net! Just wanting to know what the letters "m" and "b" refer to when used in tape device names eg. /dev/rmt/0bn, 0mn etc? Thanks, Neil

Hi, I have a file with the following format: 00003#00003: 00030 00000000091 00020297330 00642393230 00004#00004: 00030 00000000092 00020297960 00642394310 00005#00005: 00030 00000000093 00020298600 00642395380...

Gurus, I am transferring a number of tables from my local SQL7.0 database to a remote SQL7.0 database using the DTS "Transfer SQL Server Objects" task. When I run the package, there is one specific table that gets created on the remote server but none of the data gets transferred...yet the...

Hi, I've got an instance of SQL Server 7 where I'm using a DTS package to import some excel data into a table in my database. The Excel sheet is a simple 3-column table with the data beginning in row1. However, instead of importing row1 as data, DTS is trying to force the values in row1 to be...

This is giving me a migraine! I want to update the TDChartFileName column in the following table... select * from tDPR_WellData WellID TDChartFileName ------ ----------------------- 1 Abaji Okolo 1 268A 2 Ebughu East - 4H 9736 3 Oron West - 1ST1 9795 4 Tiguentourine-325z...

Hi, I'm trying to copy data from one table to another. The source table has columns: Name varchar(30), Day decimal(8,2), Depth decimal(8,2), Name1 varchar(30), Day1 decimal(8,2), Depth1 decimal(8,2), Name2 varchar(30), Day2 decimal(8,2), Depth2 decimal(8,2) Destination table is similar...

I've got a quirky little problem where it would be very helpful to refer to columns based on their ordinal position. ie. to retrieve the 2nd column do something similar to: SELECT 2 from <tablename> ...??? I've seen there's an ORDINAL_POSITION column in the INFORMATION_SCHEMA.COLUMNS view. Is...

Gurus, I've got a rather garbled script that is giving me a major headache. Basically, I have an Excel sheet with multiple worksheets where the 1st worksheet - called "Contents" -contains a single column containing a list of all the remaining worksheet names that contain the data. I want to...

Gurus, Could be a rather dumb question, but here goes anyway.... I've set up a simple DTS package in SQL Server 7.0 that I will be using to transfer a large number of Excel spreadsheets with an identical structure into a table in my database. I would prefer not to have to go into the DTS GUI...

Hello Gurus, I'm in the middle of my 70-229 certification and have been messing around with defining identity and rowguidcol values in some tables. I'm struggling to understand what the rowguidcol property actually does. Allow me to illustrate my problem: create table t1 ( c1 uniqueidentifier...