No idea on TLS 1.2, but I have to at least ask what's driving the desire to use SQL 2012?   It's at least 6 years out of date, and I...

cagray,

FYI, SSRS doesn't like queries that don't return a recordset.   If you need to execute multiple stored procedures to get all the data you need into a temp...

I can think of a half dozen reasons it may not work, but the bigger problem is that the poster's source table has no inherent order.   There's nothing about a...

One, it would NOT be easy to do.   You'd have to know exactly where in the xml of each report the necessary additional XML would need to go, and unless...

I tend to solve these problems in my dataset by letting the query or stored procedure provide a sort value as a column in the dataset.  If you can post...

How about something like putting all those search strings in a table?
Here's a sample idea:
DECLARE @ls AS TABLE (
    STRING varchar(10) NOT NULL PRIMARY KEY CLUSTERED
);
INSERT...

Try this:
CREATE TABLE #ClosingEntries (
    Unique_ID char(14) NOT NULL,
    TRAN_DATE date NOT NULL,
    CLOSING_CREDITS decimal(20,10) NOT NULL,
    CLOSING_DEBITS decimal(20,10) NOT NULL
);
INSERT INTO #ClosingEntries (Unique_ID, TRAN_DATE, CLOSING_CREDITS, CLOSING_DEBITS)

Oops... missed a column, and while I'm at it, improved the performance characteristics by analyzing the execution plan:
CREATE TABLE #ScoreRange (
    IdScore int,
    ScoreLow int,
    ScoreHigh int,
    RangeName varchar(100),

Here you go:
CREATE TABLE #ScoreRange (
    IdScore int,
    ScoreLow int,
    ScoreHigh int,
    RangeName varchar(100)
);
INSERT INTO #ScoreRange (IdScore, ScoreLow, ScoreHigh, RangeName)
    VALUES    (1,  0, 1499, 'Poor'),
            (2, 1500, 3499,...