patrickmcginnis59 10839 (7/30/2014)

---

Grant Fritchey (7/30/2014)

---

patrickmcginnis59 10839 (7/30/2014)

---

Its sort of a free market thing, if people decide that SO/SE isn't useful, it could go away. I'm hoping it sticks around because...

Yep, we are out here directly supporting the mission of...

sarmistead (7/30/2014)

---

Nice work; you've defined a mechanism for storing and managing server and database privileges in an environment-adaptive fashion. I imagine many of us can utilize this framework.

Now if...

SQLRNNR (7/30/2014)

---

Lynn Pettis (7/30/2014)

---

SQL Guy 1 (7/30/2014)

---

Ah, if I understand right, you are in US army deployed in Afghanistan?

And the local agencies they are local to Afghanistan or...

SQL Guy 1 (7/30/2014)

---

Ah, if I understand right, you are in US army deployed in Afghanistan?

And the local agencies they are local to Afghanistan or to your home...

patrickmcginnis59 10839 (7/30/2014)

---

Lynn Pettis (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Koen Verbeeck (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

SQLRNNR (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Ed Wagner (7/28/2014)

---

SQLRNNR (7/27/2014)

---

Jeff Moden (7/26/2014)

---

That might be where the...

Interesting article even though I have only skimmed it so far. I did read the introduction.

Only thing I saw as quickly scanned the code that I would change are...

quackhandle1975 (7/30/2014)

---

Not had any experience of recruitment agencies in the US but the ones in the UK (especially for contract work) can be very much hit and miss, usually miss....

Using Craig's setup, is this what you are looking for?

declare @RunDate date;

set @RunDate = '2014-07-22'

select dateadd(week,datediff(week,0,dateadd(day,-1,@RunDate)),0)

IF OBJECT_ID ('tempdb..#SampleData') IS NOT NULL

DROP TABLE #SampleData

CREATE TABLE #SampleData (PERSON INT ,dt DATETIME,[PAYTYPE] VARCHAR(20)...

SQL Guy 1 (7/29/2014)

---

Lynn, what happens if your job has finished/end of contract and you are starting another search, but none of four agencies in your circle have any...

Jan Van der Eecken (7/29/2014)

---

Hi Everyone!

Wow, it has been 6 months or so since I last was on this thread. I haven't even been lurking, just too busy to keep...

DiabloZA (7/28/2014)

---

Hi Evil Kraig F,

The way this works at the client site is that employees daily worked hours are recorded as Pay Type (Regular) carrying lets say 8 hours each...

Nope. You start with sys.server_principals. You'll have to do some reading in BOL to identify any of the other tables you may need to look at. Unfortunately...

Not a problem. Glad to help out.

I would restore the master database as an ordinary...