You need the actual filename for xp_fileexist, so unless you can get the exact timestamp before checking, its not going to be possible.

I think the way to check for a...

valeryk2000 (12/15/2011)

---

Thank you DA, TB & GS!

The reason I asked is that in the past I had a problem with try/catch when parent proc did not catch the error in...

Grumpy, Sleepy,...

I don't know if its considered best practice, but I use a single try-catch block and return codes

DECLARE @RTN INT;

DECLARE @ErrMsg NVARCHAR(4000);

BEGIN TRY

BEGIN TRAN

EXEC @RTN = Proc1

IF (@RTN !=...

No, that would have been blame the Dev.

In your dynamic SQL I think you just need to test for numeric

Where you have

' FROM (SELECT TIMESTAMP, LotID, CONVERT(numeric(25,13),isnull(VariableValue,0.0)) as VariableValue, VariableName

...

8192 rings a bell as a default setting somewhere.

Are you first seeing this truncation when calling a web service, or WCF/SOAP/XML, or some other .NET application?

I'm sure there is something like maxMessageSize in the WCF config files - you can change it up to 2GB, otherwise it truncates around 8192.

Check system.ServiceModel in the config files....

Could the XML contain any unicode?

Try NVARCHAR(MAX) - either it works or, if you then get limited to around 20,000 at least we've learned something about the problem.

I think what you're looking for is either a dynamic pivot - this will produce a variable number of columns for each timestampt/toolID key. In a dynamic pivot you...

Koen Verbeeck (12/9/2011)

---

Dev (12/9/2011)

---

Koen Verbeeck (12/9/2011)

---

I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new"...

Firstly, by how much is the value wrong from what you expect. Could it be due to rounding?

You should then break down the problem into smaller steps to find...

I guess Access probably does not support CTEs.

You could try taking the CTE out and replacing it with a derived table like this

SELECT DR_DCATCD,

...

Sorry I've never used reporting services.

I'd recommend you repost the original question under "Reporting Services", "Reporting Services 2005 Development", http://www.sqlservercentral.com/Forums/Forum1063-1.aspx making it clear you're looking for help with a...

Yes I found the Wiki, and other articles, but the whole topic of normalisation seems couched in academic terms.

I was trying to google for simple definitions of things...