I'm having issues again posting SQL code here.

But thanks for the link. This tells me for most of what we do some logging is still going to occur, tables...

I got a little more detail on how this was tested today. The first thing that was done was to create a new database and a new empty table...

Don't feel bad about hating stored procedures, there are others that prefer not to use them. 🙂 That being said they do have a purpose and aren't that much...

I had to attach the SQL in the text file, some reason it wouldn't allow me to post it.

No I didn't try anything other than the database and what I wanted to search for. Just tried on a real small database, got it back in less than...

OK this isn't the same SQL, this is something I got back in March, probably from this site, didn't keep who wrote it, sorry about that, I'm trying to do...

Sean Smith-776614 (10/22/2014)

---

below86 (10/22/2014)

---

I like the idea of this but the only issue I have is this, If I want to run this against our production warehouse I'm not going...

I like the idea of this but the only issue I have is this, If I want to run this against our production warehouse I'm not going to have rights...

To me it looks like someone was looking to add the code persontype = 'sp', but just put it in the wrong place. I've seen code like that before,...

What I see as another trick question. In your example data you see before answering the question you have values that would give you the rankings of:

CustomerIDRank

4 ...

I got the same thing.

pietlinden (9/28/2014)

---

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum IN (4,...

How about one more version?

SELECT DATEPART(DD, DATEADD(DD, -1, DATEADD(MM, 1, DATEADD(DD, -(DATEPART(DD, GETDATE()) -1), GETDATE()))))

We have a small set of data on our DEV environment. But we only use this area to basically test that the code does not fail. Then to...

I would guess I've had more than 6 different job titles over the 20+ years. And it just changed again from Lead Programmer Analyst to Lead Application Developer. ...