Green

SELECT TOP 12 ---Create a list of numbers from 0 - 12

N = IDENTITY(INT ,0,1)

INTO #tally

FROM

master.dbo.syscolumns sc1,

master.dbo.syscolumns sc2;

WITH curr_per AS --Find all the current period indicators

(

SELECT

periodnumber

,CalendarPeriodId

,CalendarYearId

FROM

test...

djj (2/25/2016)

---

jasona.work (2/25/2016)

---

Man, my music tastes go all over the place...

Listening to my playlist on my phone today, just went from Dragonforce, now I'm listening to an Alex Band tune...

Can you post some sample data please?

It will make it much easier to understand what you want and to come up with a solution.

Reported as spam

astrid 69000 (2/24/2016)

---

Hi,

I have a table that each row related to another row, and apart from that they have nothing in common.

create table #mynumbers (Appl int, Pre_App int);

insert into #mynumbers...

Bus

Steve Jones - SSC Editor (2/18/2016)

---

BWFC (2/18/2016)

---

To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version...

To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version but many people testing that, like...

As somebody mentioned the other day, this[/url] sums things up well.

Since I know you and I have the same smoker, have you done anything to protect it from the weather? I never found a decent cover for it and it...

ChrisM@Work (2/9/2016)

---

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time...

Jack Corbett (2/5/2016)

---

Okay so that makes the process...

Jack Corbett (2/5/2016)

---

How do you load the data warehouse?

Can a person have risk at one load and then not have a risk the next load?

How will...

That was just a back-of-a-fag-packet, as-I-type guess. I'm in the process of breaking things open to have a look now and already I've spotted one reason why I've lost...