Here is one way you could do this without using a loop. This uses the concepts of a tally table which you can read more about here. http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

WITH

E1(N) AS (select...

Brandie Tarvin (12/17/2014)

---

WayneS (12/17/2014)

---

Jeff Moden (12/17/2014)

---

Koen Verbeeck (12/17/2014)

---

Brandie Tarvin (12/17/2014)

---

Brandie Tarvin (12/16/2014)

---

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous...

You should read this article about dynamic sql. http://www.sommarskog.se/dynamic_sql.html

piercing

jshuter (12/16/2014)

---

Hi Rookie

If you want to take the direct approach, you'll need to loop through with DATEADD( ) function

then go forward with D, 1,

and backwards with...

What defines business days? Monday - Friday? There...

Sure but it is much more difficult and less...

You should use a calendar table for this type of thing. http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D

david.gugg (12/16/2014)

---

So as it is currently written, is the query actually doing this?:

SELECT s.*

FROM dbo.Stocks s

WHERE s.id IN ( SELECT s.id

...

For those interested in reading about INNER JOIN versus IN...http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/%5B/url%5D

McSQL (12/12/2014)

---

Just to add clarity if there is any confusion as to what i'm struggling to select;

There are several DOC_NO duplicates

There are many more REV_NO duplicates

I want to select all...

Stylez (12/12/2014)

---

Much Thanks!

would it be possible if I could also do this?

Case When Condition 1 = true then When Condition 2 = true then Execute Anything....

I would like to know...

ben.brugman (12/12/2014)

---

I am building a generic tool. *)

The tool can be used on tables which are not in existence yet.

Ben

*)

More...

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

... Mark one off, 78 days to go on the calendar. 78...

Your question does not really have enough clarity to offer much help. Why do you need to create temp tables from persistent tables like this? Perhaps if you can more...