Jack Corbett (11/8/2011)

---

I got it right, because I knew none of the other answers was correct, but I don't think the answer had the best wording.

I ran it on a...

Nice question - got it wrong today 'cos I thought the response "query out of order" referred to a syntax error and not otherwise. It parsed successfully but blew up...

Hugo Kornelis (10/24/2011)

---

codebyo (10/24/2011)

---

wware (10/24/2011)

---

OK, I just got it, thanks to mtassin's explanation and my reread of Hugo's original explanation ("there are no other columns in the table.") In...

Nice question ... and thanks for the alternatives posted by other users.

Thanks guys!

Due to the length of time that had gone by when I submitted the question, I almost forgot the answer 🙂

Kwex.

Nice question! Almost missed it though 🙂

Thanks Drew ... that was another "classy" solution 🙂

yubo1 (9/29/2011)

---

You can use 'union' to achieve ,like null union non-null

here are test sql_code below:

create table test

(

col1 int,

col2 int

)

insert into test

select 1,null

union

select 2,2

...

Thanks guys for taking time to respond.

I'm not sure what level of DDL you expect, but I hope this can suffice.

IF OBJECT_ID('tempdb..#test') IS NOT NULL

DROP TABLE #test

GO

CREATE TABLE #test (ID...

Yes I have. This just sets that row to NULL, and still uses up the numbering. Thus, the next NON-NULL row would not have [Prev...

Thanks guys.

The TSQL Phrase is

SELECT *, ROW_NUMBER() OVER (PARTITION BY colA ORDER BY colB) FROM tbl;

Adding more light to my initial post, I desire to return all rows in...

I got it wrong today ... as I completely forgot the role of "HASH" in the join statement. Grrrrr ....

Nice question ... interesting to learn something new too.

Nice question! A reminder on PARTITIONS 🙂

Nice question ... pls amend the second SELECT statement to have a return value of 1 and not 2.

Kwex.