I'm not sure about the performance of this in a large scale, but I think I have the logic working.

;with RawData as

(

select 'DOC1' as DOC_NO, 'VER1' as REV_NO, 'PDF' as...

Do you need it as a function? Part of a stored procedure?

Luis is spot on with the advice of maintaining separate columns for the Leter and the Counter. ...

Is the numeric sequence for Accounts and Contacts shared, or are they separate counters?

For example, which set below is more appropriate:

Set 1 - Separate counters

A001234

C005555

C005556

A001235

Set 2 - Shared counter

A001234

C001235

C001236

A001237

If you provide your table structure, some sample data and your expected results, I could help you better.

See some guidance on providing this kind of thing here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Add JOIN_DATE to the Select list and a group by:

select JOIN_DATE , count (*) from MEMBERS,dbo.MEMBER_PROFILE

where MEMBER_PROFILE.member_no = members.member_no

AND JOIN_DATE between '07-01-2013 00:01' and '07-31-2013 11:59'

and email <>...

Hi Ken -

HOW variable is the data? I think this impacts the solution. Your example data currently results in 21 columns. What's the maximum # of rows...

My favorite SQL happening of the year is the job I've had since January, and how SQL Server and SSIS have enabled me to make an impact at my new...