If you are asking the latter, then give this a try. It isn't tested as I have nothing to test it against.

WITH CurrentPO AS (

SELECT

v.ACCTNO,

...

Not quite sure what you are asking for here. Are you asking for the most recent PO regardless of account number or are you looking for the most recent...

We are going to need more information to really help. Please post the DDL (CREATE TABLE statement) for the table(s) used in the query, sample data (as a series...

You do know that 1) SQLServerCentral.com is a site whose focus is Microsoft SQL Server and 2) you posted this is a SQL Server 2005 Integration Services forum.

You may not...

Made a slight change:

DECLARE @MyDate DECIMAL(6,0);

SET @MyDate = 201003;

SELECT DATEADD(mm, -12, DATEADD(mm, (CAST(@MyDate AS INT) % 100) - 1, DATEADD(yy, (CAST(@MyDate...

Here is an alternative method for converting a date stored as an integer in the format yyyymm:

DECLARE @MyDate INT;

SET @MyDate = 201003;

SELECT DATEADD(mm, -12, DATEADD(mm, (@MyDate % 100) - 1,...

That's why I submitted this question. I'm sure at some point that someone...

Okay, I should have used the DATE data type for the question, then I could have left the time portion off the answers.

Why do you care if there is a gap in the id's? Is there a business case for this?

Well, he didn't say if the web server was internal or external, so it depends. You could possibly have an external website requiring authentication allowing you to restrict access...

Here is my suggestion, read the first article I reference below...

I don't know, why don't you just try each and see...

Bad_Karma (6/5/2012)

---

I'm extremely new to licensing and am looking for some clarification/education. I spoke to my IT guy, who is not a SQL guy, about upgrading from SQL 2005 to...

latingntlman (6/5/2012)

---

Lowell, let me bounce this off you now:

I have tested my 3 steps of the solution and they all work great. However, after presenting it, I was asked that...

Go here: http://www.bing.com/search?q=sql+server+2008+licensing&qs=AS&form=QBLH&pq=sql+server+2008+licensing&sc=8-25&sp=1&sk=. Clink on the third link. Page 3 of the overview tells you what you need to know regarding licensing.

All you need to do is install...