please help me to write a scipt in sqlserver 2005

Question

question

faranakm asked Dec 30, '13

please help me to write a scipt in sqlserver 2005

I have a table as below: I want to write a script that return all of _level = 2 and (all _level = 1 which have not _parent_id.it means the _parent_id of _level = 1 not used in _parent_id) I hope that I explain this clearly. Thanks,

sql-server-2005 sql-server script

1.jpg (39.8 KiB)

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ commented · Dec 30, 2013 at 02:40 PM

Homework? I would recommend reading up on the WHERE clause - http://technet.microsoft.com/en-us/library/ms188047.aspx

4 ·

Answer 1 · 2014-01-02T10:49:43Z

Grant Fritchey answered Jan 2, '14

From the looks of things, you'll probably need to look to a [UNION query][1] to combine the two result sets that you've defined. This is because, logically, you can't just return _level = 2 and combine it with any of the values where _level = 1 inside of a single statement. So, instead, make two statements and combine them. Probably you'll want to use UNION ALL for performance reasons. Read up in the link I sent. [1]: http://technet.microsoft.com/en-us/library/ms180026.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question