SELECT DISTINCT P.PRE_DTT_PRESERVATION_ID,

CASE horizondm_dev2.dbo.LookupValue_dev(D.EVI_DEV_MEDIA_TYPE)

WHEN 'ORIGINAL STORAGE'

THEN 'Original: '+ EVI_DEV_BC_Barcode +' SN:'+ EVI_DEV_SN

WHEN 'WORKING STORAGE'

THEN 'Working: '+ EVI_DEV_BC_Barcode +' SN:'+ EVI_DEV_SN

WHEN 'For Remediation'

THEN 'For_Remediation: '+ EVI_DEV_BC_Barcode +' SN:'+ EVI_DEV_SN

ELSE

horizondm_dev2.dbo.LookupValue_dev(D.EVI_DEV_MEDIA_TYPE)...

Since YODA is your avetar... you might like this....

http://www.wimp.com/catpitbull/

Lynn Pettis (5/24/2012)

---

Can you post the DDL for the view? Our biggest problem is that we can't see from here what you see there. Makes it really hard...

I'll do better than that... I'll write you a pretty little script and show the output... I'll even put a ribbon on it... gimmie a couple minutes....

Lynn, I just realized what your reply was REALLY saying... I think I did that, but I'll double check.

Lynn, My typing was wrong, but the test was correct. You're right the ISDELETED flag needs to on the table not the view... BUT.. I ran the...

I'm a little late to the battle, but I'm fond of a saying...

How do you eat an elephant? One bite at a time. That Original query is...

Lynn Pettis (5/17/2012)

---

Jeff Moden (5/17/2012)

---

Lynn Pettis (5/17/2012)

---

CptCrusty1 (5/17/2012)

---

OK.. Case statement works, but is it the best way....

.....

AND (CASE WHEN COL_1 = 25 AND COL_2 <> 30 THEN 1

...

WHY is there an ORACLE add banner at the top of the SQL SERVER page??? PIRACY!!!!

OK.. Case statement works, but is it the best way....

.....

AND (CASE WHEN COL_1 = 25 AND COL_2 <> 30 THEN 1

...

Nah... it was the Texas comment. You'd really love it if you knew that I grew up in Southern CA. ...

:rolleyes: oh jeeeeez.....

PLEASE... I like SNARKY comments...

Since I have ya'll's attention. Can ya'll recomment a good starting point for more advanced SSIS schtuff? Reading material, things to try, etc?

Yes.....

Yes... That was a thank you... just a goofy one which is normal for me... 😉

---Although, don't think I'm ungrateful... I'm always grateful to those with more knowledge, experience, or both...