smer (9/28/2015)

---

Hi Team,

Help to get the Sql Query e.g when execute on 8/15/2015 get the records from 8/1/2015 to 8/15/2015, if run on 9/20/2015 get the results...

Thanks for the congratulations everybody. I think the scariest thing about how far I've come in the last two and half years is realising how far I've got to...

Bandit

SQLRNNR (9/23/2015)

---

If no raise, then let them keep the promotion.

Love the promotions where it is only a...

Promotion today :w00t: Yay me!!!!

I remember reading an interesting alternative take on that axiom...

Phil Parkin (9/17/2015)

---

BWFC (9/17/2015)

---

Phil Parkin (9/17/2015)

---

I'm with you, Jeff. Using the threat of leaving, directly or indirectly, as a means to increase your salary feels ethically wrong and akin to...

There is an huge number of people on here that will be able to give you a better answer, in more detail, than I ever could. The long and...

Phil Parkin (9/17/2015)

---

I'm with you, Jeff. Using the threat of leaving, directly or indirectly, as a means to increase your salary feels ethically wrong and akin to bribery. If you're...

This subject is an odd one for me. I'm happy in my job, the pay is good, the conditions are good but there's not a lot of 'work' to...

Hot

CREATE TABLE #weekdays

(

datevalue datetime NOT NULL

, numericvalue INT NOT NULL

);

INSERT INTO #weekdays (datevalue, numericvalue) VALUES

('2015-09-01', 1000),

('2015-09-02', 1001),

('2015-09-07', 1003),

('2015-09-08', 1004),

('2015-09-12', 1005),

('2015-09-13', 1006),

('2015-09-14', 1007),

('2015-09-19', 1008)

select

case DATEPART(dw,datevalue)

when 7 then DATEPART(wk,datevalue) +1...

kbab95 (9/17/2015)

---

Hi,

I am trying to get the maximum for stores where there exists more than one in the same region (e.g. top sales).

I want to leave the ones where there...

Roll

Please tell me it's not just me who saw the title of today's editorial and immediately replied mentally with 'yes, you're a good developer.'

Must.Grow.Up