Am I missing something there Chris? That just looks like my original code re-formatted.

Punctuality is important to me, if you're supposed to be there at 1000 be there for 1000. That, to me, means allowing enough time for the trip plus a...

Fantastic

plant

georgheretis (3/18/2016)

---

hi

i am sing a stored procedure in order to backup my DBs. then i shedule it in a job .

in order to Verify a success of database backups i...

TomThomson (3/10/2016)

---

Eirikur Eiriksson (3/10/2016)

---

TomThomson (3/10/2016)

---

Quite interesting. Some of it extremely expressive. Certainly backs up what...

Hard

Glass

Luck

TSQL Tryer (2/26/2016)

---

The only thing I'm thinking is what if the Current Period is 1 but the year is say 2017 (next financial year....it would need to pull back the...

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