I'll mess with the CHARINDEX. I think that is my best option. There isn't a - in the field, just the codes. As far as normalizing, that's...

I have already gone and changed all of the subscriptions to a default user for the accounting group so I can't go looking at the owership of all those reports....

Thanks Toolman, that works.

I followed your instructions and it does not work. No one has been able to tell me why I can send a test email, but still not have the...

I never got mine to work.

When I first set it up, it was working fine for months, then one day after an error with integration, I noticed I didn't get...

rbarryyoung (10/24/2008)

---

So, let me check ... yes, the SOP way to address this in SQL Server is to hide it behind a CASE function:

declare @wh varchar(2)

set @wh='10';

Select obitno, oaorsc

From...

Just so I can try and understand more...

If I rewrite it to the following:

declare @wh varchar(2)

set @wh='10';

select obitno, oaorsc

from

(select obitno, oaorsc

from hsdet inner join hshed on obhssq=oahssq

where oainvd>20050100) as...

Garadin (10/24/2008)

---

Can you do this?

DECLARE @wh char(2)

SET @wh = '1'

SET @WH = CASE WHEN LEN(@WH) = 1 THEN '0' + @WH ELSE @WH END

select obitno, oaorsc

from hsdet inner join hshed...

Lynn Pettis (10/24/2008)

---

Then I'd try this:

select

obitno,

oaorsc

from

hsdet

inner join hshed

...

Here are the results. The...

Lynn Pettis (10/24/2008)

---

Just a guess, but try this:

select

obitno,

oaorsc

from

hsdet

inner join hshed

...

that's the history sequence number to join up the order header file (hshed)with the order detail file(hsdet). They are...

Yes I added the isnumeric=1 to my CTE. If I ran this statement alone,

select obitno, convert(int,oaorsc) as orsc

from hsdet inner join hshed on obhssq=oahssq

where isnumeric(oaorsc)=1

I would get a series...

Gotcha. I ran the query like you have it. It comes back with 37,000+ rows. I modified it to show distinct oaorsc and it comes back with...

Gave it a shot with the isnumeric, but it still came back with the same error.