ooops,

The join should be on Organization and not on Organization_name

....

thanks

Chris

HI there,

Have you tried using a join instead:

update [2009]

set [2009].organization_name = e.organization_name

FROM test_2009 [2009]

INNER JOIN org_2008 [2008]

ON [2008].organization_name = [2009].organization_name

WHERE...

Hi,

Please could you give us an example of the proc?

thanks

Chris

HI,

Make sure you are connected to the correct database and that the table name is correct.

That is basically saying that it can't find your OrderDetails table!

Thanks

Chris

Hi,

Do you need to update an existing field starting 5000 and counting up.

Or do youwant a new field to default 5000 and then the new row 5001?

Thanks

Chris

hi ,

Thanks guys,

I was under the impression that in 2000 the views schema would over ride the table for not null in the view and null in the table...

thanks again

Chris

Sorry that wasn't real code

CREATE VIEW MyView

as

SELECT

ISNULL(Col1,'') as Col1

FROM MyTable

GO

Now if you run sp_help MyView

you will see the column is not nullable.

How come then it doesn't raise an...

Hi Grant,

Thanks for the reply.

I'll keep that in mind and I'll keep testing my results for each situation that comes up in the future

Thanks again

Chris

Hi,

With regards to Left joins I would expect the data to be different.

Thanks

Ok further research has showing

1)

JOIN:

SQL Server Execution Times:

CPU time = 93 ms, elapsed time = 1306 ms.

WHERE:

SQL Server Execution Times:

...

I don't think it's a glitch either.

Like most people are saying the VARCHAR(10) can only hold 10 so SQL is correct in truncating it!!!:D

HI,

Are you sure you are set to compatibility 90 and not 80?

thanks

Chris

HI there,

Here is what I think is a set-based working copy.

(if it isn't please could someone tell me why it isn't set-based)

That aside this will work in 2000 without a...

HI There,

Sorry about that.

Well you could use a temp table or table variable it's just another way of looping.

Why don't you want to use a cursor?

I don't like cursors which...

he he he he

Sorry I should have read the forum heading 🙁

Have you tried using a table variable or derived table?

Thanks

Chris