I'm in Chicago,...

dec_obrien (4/11/2012)

---

SQLKnowItAll (4/11/2012)

---

That really depends on SO many things... I would say that database administration "could be" minimal if the application uses SQL Server correctly. You say you are proficient...

As it many times is 🙂 I'm out of guesses...

Lynn Pettis (4/11/2012)

---

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...

That really depends on SO many things... I would say that database administration "could be" minimal if the application uses SQL Server correctly. You say you are proficient in SQL,...

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 and 8,...

You need to get a book or find some online tutorials my friend. Try posting your question in the Data Mining forum.

This fixes the patindex, can't start it with a - in the regex. However, your query only displays the last character replaced. Is that what you want?

Declare @idx_Operator nvarchar(10)

Declare...

Try reading through this... http://msdn.microsoft.com/en-us/library/ms189850.aspx

Before I say "Yes," You need to explain to me more what you are doing and what this query is trying to accomplish.

Well... I'm certainly no expert, but I think you should be doing this in SQL, not in MDX. You use SQL to populate your DW and use SSAS to...

Hmm... That won't work either. Take out the + from the string and leave in the -, then the result of the patindex returns 0 again. Hmm...

No problem, but I am certainly not an expert (or even the least bit knowledgeable) on REGEXs. Should look at this a bit more.

SQLCrazyCertified (4/11/2012)

---

SQLKnowItAll (4/11/2012)

---

In mirroring, the data is not "restored." It is synchronously applied to both the primary and secondary server so that the data is always in sync. Failover happens...

Actually... start with this:

Declare @idx_Operator nvarchar(10)

Declare @Operator nvarchar(10)

Declare @formula nvarchar(100)

select @formula = 'BRIDGESTONE+FIRESTONE perelli-MyTire'--formula from goal_formulas where id = 1

SELECT PATINDEX('%[+-/*|]%', @formula)

SELECT PATINDEX('%[+%-%/%*%|]%', @formula)

See?