I'd have to run some tests to say definitively whether indexes would help or not, but I can say I've seen similar systems and indexes weren't needed there.

So, probably you're...

Sometimes it takes seeing it all put together in order to understand the pieces.

Glad we could help.

By the way, if anyone is still interested: http://www.smh.com.au/world/myersbriggs-test-not-all-psychologists-type-20121217-2bigg.html

Per this article:

Even Katharine Downing Myers concedes that "psychologists had no use for the indicator; they felt that Jung was a crazy...

Evil Kraig F (12/18/2012)

---

2 hours?...

patrickmcginnis59 (12/18/2012)

---

GSquared (12/18/2012)

---

patrickmcginnis59 (12/18/2012)

---

I don't see why we can't talk about our social and behavioral responses to technological advances without having to redefine perfectly functional words like the word "technology"...

Your modification to end-of-month looks like it won't work correctly in all cases. Try a March date in there, see what you get.

You could try something other than SSMS.

ApexSQL Edit (http://www.apexsql.com/sql_tools_edit.aspx) might be an option. I don't know if it can run on XP and edit SQL 2012, but their salespeople...

Like this:

SELECT GETDATE(),

DATEADD(week, DATEDIFF(week, '19050101', GETDATE()), '19050101') AS StartOfWeek,

DATEADD(month, DATEDIFF(month, '19050101', GETDATE()), '19050101') AS StartOfMonth,

DATEADD(day, -1, DATEADD(month, DATEDIFF(month, '19050101', GETDATE())+1, '19050101')) AS EndOfMonth

I picked 1 Jan 1905 for this because...

I don't think that works.

But you should be able to connect earlier versions of SSMS to SQL 2012, if I'm not mistaken. At least enough to write and execute...

Revenant (12/18/2012)

---

Hmm... 2001: A Space...

Here's the output when I run that:

As you can...

zilla (12/18/2012)

---

I finally got around to trying some of this stuff this morning. I figured using the IF EXISTS should be pretty easy to put in place.

Here is the...

Sarah Conner thinks they're all inappropriate. (Yes, this week is that boring.)

patrickmcginnis59 (12/18/2012)

---

I don't see why we can't talk about our social and behavioral responses to technological advances without having to redefine perfectly functional words like the word "technology" itself. Is...

GilaMonster (12/18/2012)

---

Heard the same about The Old Republic, which I'm in the...