Because NULL is an undefined value (think infinity or dividing by 0).

IF you take an undefined value and perform an operation on it - how can it be anything but...

Well, depending on your SETtings concatenating a NULL with a string yields a NULL.

If you want to change NULLS to 'Something' then use N'Something '+COALESCE(Unternehmen.Loeschvormerkung,'')

This will ensure you always get...

Sorry , my mistake - I did indeed put the OUPUT clause in the wrong place - must be time to sleep!

So, you have triggers on there the - that...

DECLARE @sql1 VARCHAR(MAX)

SET @sql1 = 'INSERT openquery(Test342011D, ''SELECT * from sched'') SELECT * FROM sched_repair '

select @sql1

EXEC(@sql1)

"VALUES" is only used for one row of constants/variables.

I would also recommend that you...

Try this form:

The OUTPUT is just to show you what gets UPDATED and can be removed once you are happy.

The BEGIN TRAN and ROLLBACK are just in case it does...

Ok, you are trying to look for a date in a string.

Here is the problem:

AND CD.DateCollected IN(@DateList)

@Datelist is an NVARCHAR (by the way, why waste processing time handling...

Can you please explain what you are trying to achieve here?

I ask because currently you have an update on a table that is the LEFT OUTER part of a join,...

ALTER USER [scott] WITH DEFAULT_SCHEMA=[scott]

You haven't really given enough information there, but my guess is that you have a collation conflict between tempdb and your current database.

try specifying the collation that matches your current...

Agreed they must be views (called tbl_. .. ?!?!?)

I did notice that the Actual row count coming from [VotaAntonio].[dbo].[IDQ_000acd57f2394d8a8ed291773efdab25] is different between the two queries...

Yes, I would say it is definitely possible to get different results for an undefined set based on DOP.

If you can post the actual execution plans for both queries it...

Hi,

You don't mention how you are ORDERing the queries , how you are restricting the results (WHERE) nor whether you are using TOP.

Can you clarify those points as they could...

Let me help you out with...

Well, there is your problem - it's a 3GB table and you are trying to select * from it.

So, when you try it over the network you see NETWORK I/O...

Also, a few posts back you said SELECT * FROM ... returned 137 rows, now it is 19000 ? Please tell us exactly what you are doing otherwise we can't...