singhamitpal (4/19/2016)

---

Thanks for the response...

I’VE have been advised to stay away from the stored procedures meaning the business logic should NOT be stored in stored procedures, except where really really...

This is a very interesting subject, one of spent a lot of time looking into and something worth really understanding when dealing with "Ranking" functions. First (in case you run...

Also...

order by T.samplePartnerCode

What's the purpose of this other than to make your query slower? If you truly need a presentation ORDER BY let the application do it.

doug moore (4/18/2016)

---

I currently have a very old dundas control that creates a MDX query using their object

DundasOlapDataProvider > Dundas.Olap.Data.DimensionDescriptor

we moved away from this dundas and moved towards Telerik....

Well, I got this one wrong. I know that at least one of the Friday shirts has boats on it though...

Good stuff Jeff!

les.61 (4/17/2016)

---

SSCommitted, Many thanks I have tried the "s2 = SUBSTRING(someString,CHARINDEX('PP', someString)+2,8000)" option and it works well for the entries in question However for some entries that have no PP...

You can use NGrams8K for a set-based way of solving this kind of thing.

The function:

CREATE FUNCTION dbo.NGrams8k

(

@string varchar(8000), -- Input string

@N ...

This will do the trick (note my comments).

DECLARE @yourTable TABLE (someString varchar(100));

INSERT @yourTable

VALUES ('DDR Return PP12345'),('DDR Resturns PP12356'),('DDR Retunrs PP12367');

SELECT someString,

...

[Quote]1. Moving mdf,ldf,tempdb to seperate drives.[/quote]

Yes, you want to do that anyhow but yes, do that.

2. Create 2 server one for transactions and one for reporting ,replicating data to second...

I know thread is a little old but this is exactly the kind of thing you could do with a good NGrams8K function. Here's the function:

CREATE FUNCTION dbo.NGrams8k

(

@string...

From the looks of your first and last picture - it would appear that SQL Server is not installed. There is a checkbox during the install for "Database engine services"...

(Note...

What PB_BI said.

It's also worth noting that you can access SSAS via BIDS or SSDT (depending on the version of SSAS you ate running).

Have you tried clicking the drop-down and selecting "<browse for more>" then looked at local servers? If there's nothing in there then there may have been an issue with you...

Transactional replication is a viable choice but implementing, maintaining and troubleshooting Replication is not a trivial task. If you go that route with production servers then push subscriptions are the...