I would add to this that we'll probably need to know what values are stored in the Leveln columns of the employee table.

DDL and consumable sample data (INSERTs) would probably...

Allow me to ask a dumb question or three.

Why would you create a constraint like that in the first place?

What is the NULLable property of the column?

Why not just store...

I believe that there is another way.

PRINT 'Create the sample data';

--===== Declare some obviously named variables

DECLARE @NumberOfRows INT,

@StartDate DATETIME,

...

david.dunst (2/23/2015)

---

Assuming you have a Rep table that lists all active reps.

SELECT r.RepCode,

IsNull((Select SUM(s.SO_Amount)

FROM SO_Table so

WHERE so.RepCode = r.RepCode

...

Perhaps this?

WITH SO (RepCode, SOAmount, SODate) AS

(

SELECT 1, 100, '1/2/2015'

UNION ALL SELECT 2, 50, '2/15/2015'

UNION ALL SELECT 3,...

VegasL (2/22/2015)

---

Hello Dwain.C,

Yes, thank you for your last update, it was spot on.

I modified you're original query and added a column to No_Of_Words, for the column result set of mw,...

Hehe....

Using Laurie's set up data, this is probably also an option:

SELECT Number

,NewDate = MAX(CASE Stat...

The thing I see missing from this is that currency exchange rates change daily. Where's the effective date for lookup of the exchange rate?

Note that this doesn't need to...

CELKO (2/18/2015)

---

I need to create random alphanumeric characters as primary key values when inserting a record [sic]. .. I don't want to use GUID or auto increment integer...

matzj (2/19/2015)

---

Hey everyone thanks again for all the responses! I was able to get this working late yesterday and wanted to share my code. here is what I...

Forgot to mention. You might want to take a look at this article.

Creating a Date Range from Multiple Rows Based on a Single Date[/url]

It covers what I'd prefer as...

Deleting a rather dumb idea, hopefully before anyone saw it.:-D

CELKO (2/17/2015)

---

As the OP said Joe, he's building a report, so I would hope that this is merely an intermediate table. But as you said, we have no DDL...

dwain.c (2/17/2015)

---

DECLARE @Account TABLE(AccountNo varchar(3), MasterAccount varchar(10) ) ;

INSERT INTO @Account

SELECT 'ABC','0000000ABC' UNION

SELECT 'DEF','0000000DEF' UNION

SELECT 'ABC','0000000000' UNION ---- unwanted duplicate

SELECT 'DEF','00000' UNION ---- unwanted duplicate

SELECT 'GHI','0'...