Good question, as this behavior is expected, same for NCHAR/CHAR as well.

-- For NCHAR

SELECT TRY_CONVERT(NCHAR(1), 234523)

Result :

----

NULL

(1 row(s) affected)

-- For CHAR

SELECT TRY_CONVERT(CHAR(1), 234523)

Result :

----

*

(1 row(s) affected)

Thanks for sharing...

In Reporting Services, Expression can contain calls to nested aggregate functions with the following exceptions and conditions:

1. Scope for nested aggregates must be the same as, or contained by, the...

Good question Peter. Thanks for sharing

+1

thanks for the question Steve. that a very handy feature.

Nice question Steve, a very good reminder i almost got it wrong but the inner voice came at the right time 😉

Its not an issue really to inherit SP most of the guys have worked on inherited code. The thing what you are willing to make it better. So i would...

you should better read this[/url] before going forward.

Well this code is making a Dynamic Query based upon the parameter(s) value and if you want to check whats is making in the end. In the end of the...

Seems to me that you are using Dimension table from your DW and joining them with a table / view of a staging table. So means no direct relation with...

Nice question. Thanks for sharing Steve.

Nice and easy question. Good to see these kind of question.

basics man basic 😉

Thanks for sharing

Nice question. A very good reminder. Thanks for sharing.

Of course u can like this.

DECLARE @start_date DATETIME

DECLARE @end_date DATETIME

SET@start_date = '2005-01-01'

SET@end_date = DATEADD(yy, DATEDIFF(yy,0,getdate()) + 1, -1)

;

WITH

E(n) AS(

Select 0 AS n unionall

Select 0 AS...

Good question. Thanks for sharing Gary.

Because Count(-100) and Count(1) are the same thing doesn't it. 🙂