+1000

michaeleaton 36224 (1/20/2016)

---

Hi Lowel,

Thanks for that, but I get the exact same result set as my original query.

Here are my create scripts.

https://www.dropbox.com/s/bh2ynmlsyt9o8z5/sqlScripts.zip?dl=0

I'll try explaining what I'm after again.

I want...

I am confused now. Do you still need help or did you figure it out? If you need help I am not understanding what the problem is.

You really need to get in the habit of using aliases and prefixing every column in your queries with that alias. It makes it a LOT easier to figure out...

Ahh. Didn't realize which thread this was in. 🙂

Can you post the actual execution plan instead of the excel version? It shows a lot more detail which helps with the insight as to what can be done for...

tusharchpatil (1/18/2016)

---

Hi All,

If i used select * from emp where rownum < 5;

I am getting the correct output of table ie. 4 rows.

but it is not working on rownum >...

First and foremost I want to thank you for posting your question with all the details required to provide an answer. Posting all the temp tables ddl, sample data and...

mike.jacobs12 (1/15/2016)

---

I have a table of tasks. Each task has a due date and is configured based on a user defined schedule. (ie. first monday of each month, tuesdays every...

ilikawa (1/15/2016)

---

b

It's just that to...

On what topic? Seems that Bill provided a solid way to go about analyzing potential storage needs.

ilikawa (1/13/2016)

---

I've came up with the idea about how is database sizing done.

I've read the information provided by Microsoft on its website (https://msdn.microsoft.com/es-es/library/ms189124(v=sql.120).aspx) about how to make estimations about sizing,...

This is a big topic. https://en.wikipedia.org/wiki/Recursion_%28computer_science%29

SQLisAwE5OmE (1/11/2016)

---

Sean Lange (1/11/2016)

---

You desperately need to do some reading about database design and normalization. This table is a mess and appear to be lacking any attempt at normalization.

As...

Koen Verbeeck (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Grumpy DBA (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did...