Amy.G (9/22/2011)

---

Even though Ninja's_RGR'us solution should have worked, this is what ended up doing the trick --

Case when RIGHT(rtrim(f3),1) = 'T' then LEFT( f3, LEN(f3)-1) else f3 end

I would...

Run only the inner part. Find what strings have a 0 for either patindex, especially the 2nd.

You might want to put a filter or case statement on that.

krypto69 (4/22/2011)

---

I need to export my RDL files from my report server to a file(s).

Here is the syntax to give me what I need - I just can't make it...

bkubicek (9/22/2011)

---

Amy.G (9/22/2011)

---

Hello all. I have a problem. A downloaded table includes a "T" character at the end of a string to mark where changes were made. I do not...

CASE WHEN Col LIKE '%T' THEN LEFT(Col, LEN(Col) - 1) ELSE Col END

SELECT

ITEM_desc

, SUBSTRING(ITEM_desc , Col + 1 , SCol - ( Col + 1 )) AS Extract

, YourOtherColumns

FROM

(

...

SQL_Nw (9/22/2011)

---

Thanks everyone. greatly appreciate that.

I have some confusion here , I have a table variable which first brings these strings after joining to different tables..

in other words...

GilaMonster (9/22/2011)

---

Ninja's_RGR'us (9/22/2011)

---

jcrawf02 (9/22/2011)

---

I suspect less than 5% in USA, but much more than 5% in Europe, the...

jcrawf02 (9/22/2011)

---

Ninja's_RGR'us (9/22/2011)

---

Kiara (9/22/2011)

---

Grant Fritchey (9/22/2011)

---

Ninja's_RGR'us (9/22/2011)

---

Kiara (9/22/2011)

---

GilaMonster (9/22/2011)

---

Doing the final checks and tweaks on Jonathan's book.

Keep...

Kiara (9/22/2011)

---

Grant Fritchey (9/22/2011)

---

Ninja's_RGR'us (9/22/2011)

---

Kiara (9/22/2011)

---

GilaMonster (9/22/2011)

---

Doing the final checks and tweaks on Jonathan's book.

Keep this lot...

george sibbald (9/22/2011)

---

we no longer have Analysis services (hurrah) having replaced it with Qlikview, but did you stop SSAS, move the 0.db directories to the new location and restart.

amending the...

Oh darn, a view in a view + slow linked server.

Sounds like I'd do a sp for each report they need.

I'd also look at some sort of replication, or at...

jcrawf02 (9/22/2011)

---

I suspect less than 5% in USA, but much more than 5% in Europe, the Middle East,...

The short answer is that neither of the servers know what the other server sees.

So the safest way to go about building a plan is to download all data and...

Thanks for the feedback, hopefully it'll help someone else in the future.