Gail and Paul,

ThAnKs FoR cLaRiFyInG mY pOsT!

Yeah....

PlEaSe HaVe A lOoK tO bOl FoR iN sTaTeMeNt. YoU cAnNoT uSe ThIs FoR nUlL vAlUeS. sO tRy ThIs:

😀

CREATE TABLE TEST1

(

SNO INT,

NAME VARCHAR(20),

...

Cross post...

Answers here please

http://www.sqlservercentral.com/Forums/Topic741440-149-1.aspx

Could you provide some sample data and the expected result for those data please.

The link in my signature should be helpful for this.

Alexander Kuznetsov (6/24/2009)

---

I guess I know how and why configuration works, but IMO it is completely irrelevant so it shouldn't be there at all. Why do I need to waste...

A relative definition 😉

Let me tell you that those data are really a funny approach...

Since this is 2008 forum, maybe somebody has another solution, but try...

Glad I could help 🙂

If you need help with one of those approaches let me know

Truly not but I think I can help 😀

I need to parse an XML file to diplay the...

Good job to refer...

I knew that any other constant expression should work equal. Just been unsure about the NULL.

Thanks!

Flo

Hey Paul

A little side question:

You work with this row-number function:

ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

Is there any difference to this:

ROW_NUMBER() OVER (ORDER BY (SELECT 1))

Sure, the results are equal but...

Jacob Pressures (6/24/2009)

---

I think you guys answered my question. Thanks! I was wondering if this could be done while avoiding CTEs or Temp tables. I guess not. THere is no...

You really should add a primary key to those tables to avoid problems like this.

Nice article Grant.

I'm still not the best friend of SQL integration in Visual Studio but I think the new database projects become better and better and it seems to be...