## Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

• ### RE: Small negative numbers

How about storing them as positives as tinyint but interpret as negatives with computed columns, view, user stored procedure etc.?

• ### RE: Using EXCEPT to Determine Row Differences

If you accept to have differences in one row you could do something like:
SELECT T.*, S.*
FROM #Targer AS T
INNER JOIN #Source AS S
WHERE EXISTS...

• ### RE: A new set-based T-SQL solution for Sudoku puzzle

What about solving a sudoku where there are no combos? Like this one?

• ### RE: More Unicode

Variable IS NOT converted to nchar. It is the other way arround. The literal is converted to char and thus the value set to variable is dependent on databse collation

Try...

• ### RE: A new set-based T-SQL solution for Sudoku puzzle

Hey Kevin! This is really great stuff pointed there! Nice idea to take care of Sudoku in SQL.

I tried your solution on the harder-hardest-sudoku-ever and it seems to not...

• ### RE: What is the Output?

@hugo

Thanks for the valuable comment. However, I didn't meant nor said that the behavior I observed is standard or repeatable. My goal was to just show how awkward...

• ### RE: What is the Output?

g.britton (6/24/2015)

Nakul Vachhrajani (6/24/2015)

I guess the explanation is quite simple:

Divide by 0 is not causing a problem in the SELECT clause because of the presence of EXISTS. You can have...

• ### RE: Temporary Stored Procedures

Jeff Moden (6/27/2013)

This does an "old fashioned unpivot" of the data (CBAC but still better than RBAR)

Could you please explain the CBAC acronym used in this context? Thanks in advance!

• ### RE: Convert integers/numbers into binary format - viceversa

Nice. But I would use `if @binary like '%[^0^1]%' or @binary = '' or @binary is null`

``` ```

`return -1`

It will prevent from inputing any non-binary string

• ### RE: SQLServerCentral apologizes and you can win a book

This book is great! I hope to win some.

--Example of some index statistics

select o.name, ColNo, InclColNo,

rank() over (order by ColNo desc) as RnkColNo,

rank() over (order by InclColNo desc) as...

Viewing 10 posts - 1 through 10 (of 10 total)