maybe try posting some information about your problem?

I for one am not willing to click your links to an external site, and I suspect many others feel the same.

There is a subtle difference between the way a query embedded in the report is run compared to calling a stored procedure, and the result is that your parameter is...

Why aren't you just doing this:

INSERT INTO [Table] (UserID, RefID, NewValue)

SELECT UID, RefID, 'Fixed message'

From UserTable

Where <Some condition>.

Jeff Moden (3/16/2016)

---

So, what would you prefer to see with the following (using a cte as if a Table Source)...

WITH cteTestData (RowNum,CSV) AS

(

SELECT 1, '1,2,3' UNION ALL

SELECT 2,...

If this new 2016 splitter does get changed to return an ordinal position, (which I hope it does), then I would have to say that returning an empty set for...

Scott1336 (3/10/2016)

---

Hello everyone,

My client is upgrading every users desktop or laptop from windows 7 to windows 10. Since microsoft edge browser is default browser in particular tests from one of...

Create the folder "Records Management" on the new server?

No tool, just SSMS showing errors for column names not being recognised. Working...

I haven't run the change scripts, but did find these issues in Version 1.0:

Lines 330, 332, 336 : inconsistent case on column names breaks script under CS collations.

Line 573 :...

patricklambin (3/6/2016)

---

1)...The main drawback was the execution time : 90 seconds for a T-SQL script in SSMS or in an application using VC# with the System.Data.SqlClient class ) and up...

As has already been stated by Ben, when you create temporary tables, they take on the collation of tempdb by default, which could cause you some issues.

There are ways to...

Thanks, for a well written, informational article.

I'm not sure you have the research to provide weight to the theory that this is because .NET is case sensitive by default though....

The most reliable way I have found is to use the free tool Redgate SQL Search[/url]

Well, your reset function doesn't return anything, so the expression is maybe corrupt or at best being implicitly convert to a string?

You could try adding return 0 to your reset...

It's still a bit hard to tell what exactly you are doing.

Do you mean you are setting the Value expression for the textbox to this?

=SWITCH(

ISNOTHING(SUM(Fields!OPEX_VAL.Value)), 0, TRUE,

cint(code.GetQuarterTotal())

) & code.resetQuarterValue()

If not,...