Correct answer:

Yes, you can run this code, This returns 97

Explanation:

You can run this code. The CHAR variable is converted to NCHAR and the first character's value returned. An...

Here is a dynamic version of Alan's answer:

CREATE TABLE Licenses(

RegID INT,

License# ...

Here is a related blog by Aaron Bertrand: sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join

Nice article. Although I still prefer Jeff Moden's dynamic crosstab approach:

DECLARE @sql NVARCHAR(MAX) = ''

SELECT @sql =

'SELECT

TableName' + CHAR(10)

SELECT @sql = @sql +

', AVG(CASE WHEN YEAR(CreatedDate) = ' +...

So that's why I received an email saying:

A new reply has been added by CELKO to a topic...

Great explanation particularly on the RANGE and ROWS clause. Thanks very much for this.

Yeah! I've been lurking this forum for quite some time now and decided...

Quick suggestion: Use dynamic crosstab:

-- Prepare Sample Data

CREATE TABLE INCIDENT(

IDINT PRIMARY KEY,

[Date]DATE

);

CREATE TABLE PEOPLE(

INC_IDINT FOREIGN KEY REFERENCES INCIDENT(ID),

PersonIterationINT,

ComplaintVARCHAR(20)

);

INSERT INTO INCIDENT VALUES(1, GETDATE());

INSERT INTO PEOPLE VALUES (1, 1, 'Head'), (1, 2,...

Try to rewrite this join.

Using such constructions in joins, especially when OR is involved is asking for trouble.

Try something like this:

...

left join objectA

on objectA.ID = case

...

Great article! Thank you.

Genius!