Maybe because he can't control the past and have to correct the data.

Prevention is key, but you...

From your table design, I would say is a problem with trailing spaces.

Try this and tell us if it worked.

select REPLACE(TEXT,RTRIM(Group_ID),' ')

from #temp

That means that you don't have the columns in your table/view.

As Lynn said, you can do things in a better way.

If you need help translating, I could help you.

You could do something like:

SELECT RefID,

d_an,

CASE WHEN d_an >= 1998 THEN 1 ELSE 0 END AS d_1998,

CASE...

Check this image to know where to find the triggers.

Use the appropriate table.

This should help you.

--Parameters

DECLARE @Year int, @Month int

SELECT @Year = 2011, @Month = 11

DECLARE @Date date

SET @Date = DATEADD( mm, @Month - 1, DATEADD( yyyy, @Year - 1, 0))

SELECT itemno...

Eugene Elutin (9/14/2012)

---

Could you...

Do you always give untested results?

Where are Series defined? Where's DDL? Where's the data? Why aren't you using SQL-92 JOINS that are more clear? Are you stuck in the past?

Now, I'm confused.

Do you need active items in a particular month?

or active and not sold items in a particular month?

Would the simplest way be correct?

DECLARE @Date date

SET @Date = '20110112' --Any day in November

SET @Date = DATEADD( mm, DATEDIFF( mm, 0, @Date) + 1, 0) -- Get next month

SELECT...

It also depends on @@DATEFIRST = 7.

Otherwise you might be counting Sundays or another day.

Lynn Pettis (9/14/2012)

---

I worked for a company that does business internationally. We stored the DUNS numbers for those businesses that we sent to D&B and were returned that information....

The same results but with different performance (most of the time). 😀

CELKO (9/13/2012)

---

I really would love to listen to his answers regarding choosing natural keys for Persons and Companies entities (where the system is international and people/companies are not just...

For the example you posted, you might want to check this article.

Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

As they say, your better chance to improve performance would be...