Did you try to insert the records retrieved from the view to a temp table to see if all of them are getting processed?

Another suggestion could be to eliminate as...

Maybe you can try to create a simpler vw_BudgetTotalPricesRevenuesTonnes view by removing all the fields you don't need for your update and see if this makes a difference. If the...

Well, I don't know if I am on the right track on this one but I had once a problem with a complicated view that under certain conditions did not...

Judging the smartness of the company by its financial performance is a weak indicator in my opinion. It might be smart to invest money in a company which is...

I modified the first view by removing the last INNER JOIN (which was not doing much anyway and the logic did not change) and now the WHERE clause on the view...

The view is working fine. Just the WHERE from the view is going nuts. It is some kind of the bug in the SQL.

But if you would like to have...

Colin,

Thanks a lot.

I just hoped I missed some built in feature that can get this info easily...

Ok, let me ask a set of questions that can lead to where my thinking is going...

 Lets assume I have a stored procedure that reads some data from a physical...

Thanks for reply but this is not what I need.

Maybe I did not write properly what I am looking for.

The sqlbytes in syscacheobjects shows how much memory SQL Server allocated...

Daniela, Thanks for your reply but I looked at SQL Profiler before and there is nothing about memory.

DECLARE @ID_list VARCHAR(100)

SET @ID_list = '100,106,103'

UPDATE tablename

SET

State = 10

WHERE CHARINDEX(CAST(ItemID AS CHAR(3)), @ID_list) > 0

The problem with this approach is that it is only going to work if the length...

Did you try this?:

INSERT INTO data51..inventory

(

field1,

field2

)

SELECT

field1,

field2

FROM data01..inventory

The URL for downloading BOL:

http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en

Hugo,

You are right that this is somewhat (incorrectly) documented in the RAISERROR. This still does not logically explain the 399/400 magic number. More logical would be 512 = 256 * 2...

PS.

I casted the Amount to INT, because your post kind of indicated this. If you want the cents included you have to specify how do you want them displayed. with...

SELECT

CAST(CustName AS CHAR(10)),

REPLICATE('0', 13 - LEN(CAST(CAST(Amount AS INT) AS VARCHAR))) + CAST(CAST(Amount AS INT) AS VARCHAR),

REPLACE(CONVERT(CHAR(10), ConfirmDate, 103), '/','')

FROM table1

You may have to be careful with the...