I agree with all your points. It's just that off-hand, even though it is in BOL, the net result SEEMS like a side effect. (By "implicit" I meant not overtly...

A new function is available: FORMAT

declare @d datetime = '2016-05-01';

SELECT FORMAT( @d, 'dd/MM/yyyy', 'en-US' ) AS 'DateTime Result'

SELECT FORMAT( @d, 'dd', 'en-US' ) AS 'DateTime Result'

- BUT:

Steer clear away...

Not certain I understand what you mean.

If you want to construct an extra column in a tablix, just add the column then right-click and select Expression. (as you would if...

Bringing this point up...

George Vobr (5/27/2016)

---

Thanks, Steve for this question, which highlights that the use of SELF is really dangerous. 🙁 If you create a procedure and add WITH EXECUTE AS SELF to...

Hilarous ! 😀

IF you have ascertained that you are indeed working off the exact same database in SSMS and in your SSRS report, move on to step 2:

Whittle down (simplify) your T-SQL...

Got the answer but misread the question - did not notice the [font="Courier New"]varchar(MAX)[/font] vs [font="Courier New"]varchar(5000)[/font] !

Lesson repeated: when looking at T-SQL do not overlook details.

🙂

A suggestion - probably nit-picking here ...

FROM OAPLUS7FLP.GLMST, OAPLUS7FLP.GLDET

WHERE OAPLUS7FLP.GLMST.GMIACN = OAPLUS7FLP.GLDET.GTIACN

is the "old" way of doing things.

The "modern" way is

FROM OAPLUS7FLP.GLMST

INNER JOIN OAPLUS7FLP.GLDET ON OAPLUS7FLP.GLDET.GTIACN = OAPLUS7FLP.GLMST.GMIACN

Better yet,...

Steve Jones - SSC Editor (5/13/2016)

---

j-1064772 (5/5/2016)

---

Exactly what does upper management seek when choosing a mid-level manager?

If they only seek a suit to act as yes-man pushing down the ladder...

😎

OK OK, I'll stow the torch and the pitchfork.

Sean Lange (5/10/2016)

---

j-1064772 (5/10/2016)

---

I too learned something about variable length decimal option.

But I still feel cheated on being denied a bragging point. There is nothing wrong with saying there is...

I too learned something about variable length decimal option.

But I still feel cheated on being denied a bragging point. There is nothing wrong with saying there is no such thing...