Damn! I'm an idiot (at least... I think I am!) .

This error could be caused by the fact that SSRS evaluates both sides of an IIF statement before choosing which...

Hi,

This is not exactly the same subject, but pretty close...

I have 6 reports, all of which are identical in meaning, but each in a different language. I need to display...

Ok, well I don't quite get why SQL Server only truncates some strings, but I have a way that fails to work and your example using CAST() which does work...

Ok... Magic? I guess that one needs a google; I cannot explain that by looking!

Thanks Chris and GSquared for replies and speed!

I see how those work; my concern is that using things like REPLACE(),LEN(),LEFT() on a text field of more than 8000 characters will...

so the available values for the second parameter need to be as a result of a stored procedure that uses the first as a parameter.

For instance, Add a dataset to...