It's either Drew or Mr. Allen.

That's beyond the scope of this site. There's...

Yes, SSAS is a component of MSBI, which usually utilizes SSRS and SSIS and sometimes MOSS. Loosely defined, MSBI doesn't even need to include SSAS. It can be...

Proffering bad advice does a disservice to everyone who reads these forums. I wanted to make absolutely clear that I...

kramaswamy (8/31/2011)

---

That would only be the case if the database was actually located on Server 2.

If I understand the OP correctly, there's a whole bunch of servers and machines which...

You're not thinking about this as a set-based operation. As Jeff Moden recommends in his signature, the...

How...

If there is nothing in the outer query that limits the account code, you can use a CROSS APPLY instead.

SELECT p.ORDENV, p.acountcode, p.Description, m.CodeAgency, m.Balance

FROM dbo.T_PLANT1 AS p

CROSS APPLY (

SELECT...

MDX is as different from T-SQL as T-SQL is from procedural languages. While it's possible to "translate" T-SQL into MDX just as it's possible to "translate" procedural languages into...

My MDX is quite rusty, but the issue is that when you calculate your running total you are using currentmember for the time dimension when you want to be using...

I was able to get around a similar problem with fuzzy grouping by partitioning on one of the grouping fields using a ForEach ADO Enumerator. This worked, because I...

ColdCoffee (8/29/2011)

---

How about this?

; WITH CharsConvertedToDate AS

(

SELECT ID , SomeValue , FourCharDate ,

RN = ROW_NUMBER() OVER ( PARTITION BY SomeValue ORDER BY ...

Wouldn't it be easier to convert your constant '1970-01-01' UTC to local time than convert your variable local time to UTC time, particularly since DST is driven by local time?...

Save yourself some trouble and combine your columns 2 and 3 into one column with the appropriate numeric type. SSIS can handle postfixed signs.

Drew

I think this is what you are looking for.

WITH Test(TestField) AS (

SELECT 'aaa'

UNION

SELECT 'abc'

UNION

SELECT 'bbb'

UNION

SELECT 'bcd'

UNION

SELECT 'ccc'

UNION

SELECT 'cccccc'

UNION

SELECT 'cccccccccccccccccccccccc'

)

SELECT *

FROM Test

WHERE NOT TestField LIKE '%[^' + Left(TestField,1) + ']%'

It basically...

I never said anything about adding square brackets. Those tell SQL to treat your filter as if it were the name of a single item.

You may want to put...