xenophilia (4/11/2012)

---

OK back to the original DDL and general problem. That CASE statment works, however I don't have counts returning for two of those values. This would be fine except...

dwain.c (4/11/2012)

---

Gilamonster said:

Semicolons are referred to as statement terminators only...

I'm glad to see that you have a working solution and that I could help.

SQLKnowItAll (4/11/2012)

---

I'm in...

capn.hector (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

xenophilia (4/11/2012)

---

No, for the original DDL that I posted, her trimming functions worked. They returned Beverages.

I still only need the string between the first...

I do get the satisfaction of having helped someone who thought I was wrong regarding a problem with compressed backups. That makes me feel good.

Jeff Moden (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

Please, someone tell me why, just why do I keep helping...

I...

Are we talking T-SQL code or SSIS?

And your point? The only fixed point the first \ in the...

Instead of constantly asking questions how about trying things out yourself?

Murphy'sLaw (4/11/2012)

---

SQLKnowItAll (4/11/2012)

---

Let me get this straight... Instead of meaningless ?'s, your client wants other meaningless characters? Clearly, the conversion is finding some conversion for the characters in columns 7...

Reorg is fully logged and can be aborted without losing any work already completed and it olny works at the leaf level so runs faster.

A rebuild is all or nothing....

Please, someone tell me why, just why do I keep helping someone who doesn't try...

See if this helps you:

DECLARE @tststr VARCHAR(64);

SET @tststr = '\Beverages\Soda Pop\Mountain Dew ';

SELECT SUBSTRING(RIGHT(@tststr,DATALENGTH(@tststr) - 1),1,PATINDEX('%\%',RIGHT(@tststr,DATALENGTH(@tststr) - 1)) - 1);