The requirements are not very clear (no DDL of the tables, no expected output). Anyway do you mean something like that:

SELECT...

I have written a loop to transfer data from one table to another. In the code below what can I do to have it increment to the next...

CREATE TABLE MyWeather

(T DATETIME...

Am I incorrect in this thinking? or Is it better to pass the enitre table. I figured that passing the field would be more efficient than passing the entire table....

Paul,

try this:

CREATE TABLE Pauls_Addresses

(company_code INT NOT NULL PRIMARY KEY,

company_name VARCHAR(30) NOT NULL,

company_address VARCHAR(255) NOT NULL,

company_address1 VARCHAR(30), -- new address line1

company_address2 VARCHAR(30), --...

I just saw this post in another group:

http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/4584f53be9b7b973#

I have not tested it yet, but it seems this guy has a similar problem and found his way through it. Might be...

Your address pieces should definetely be split into separate columns in your address table. The front end (your report definition) should handle to omit those columns, which are NULL then.

brgds

Philipp...

One way could be to edit the .csv file with a text editor and replace the slashes with at tab or vice versa in order to maintain one delimiter only.

brgds

Philipp...

I go in line with Hugo's oppinion.

I would assume if anyone choose to use IDENTITY he/she wishes to use this for new rows as well after copying the table,...

Suppose the data came from MySQL as this is proprietary to them and does not port.

brgds

Philipp Post

>Find out the models and prices for all the products (of any type) produced by maker B.<

SELECT P.model, PC.price

FROM Product AS P

INNER JOIN PC

ON P.model = PC.model

WHERE...