Viewing 15 posts - 3,631 through 3,645 (of 4,087 total)
Without sample data it's difficult to say what the best approach is, but there are two general approaches: Row_Number() or CROSS/OUTER APPLY. If you want tested code, you...
September 9, 2011 at 1:46 pm
If you have a set number of emails, wouldn't it be easier to do this in a Derived Column Transformation?
I suspect that the Derived Column Transformation may also be more...
September 9, 2011 at 12:30 pm
forsqlserver (9/1/2011)
Thanx Allen
It's either Drew or Mr. Allen.
Can u help me in start with practical LABS for MSBI and SSAS and MOSS.
That's beyond the scope of this site. There's...
September 2, 2011 at 9:59 am
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...
September 1, 2011 at 7:48 am
herladygeekedness (8/31/2011)
Gees, Drew, sorry to piss you off so thoroughly.
Proffering bad advice does a disservice to everyone who reads these forums. I wanted to make absolutely clear that I...
September 1, 2011 at 7:32 am
kramaswamy (8/31/2011)
If I understand the OP correctly, there's a whole bunch of servers and machines which...
September 1, 2011 at 7:14 am
stupid48 (8/31/2011)
I need to loop through all the records one at a time
You're not thinking about this as a set-based operation. As Jeff Moden recommends in his signature, the...
September 1, 2011 at 6:57 am
herladygeekedness (8/31/2011)
Yep, OLE Automation is your answer. Look into creating Access databases programmatically. Presumably it can be adapted to SSIS but I've not done it except from VBA.
How...
August 31, 2011 at 12:30 pm
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...
August 31, 2011 at 11:55 am
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...
August 31, 2011 at 9:05 am
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...
August 30, 2011 at 10:27 am
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...
August 30, 2011 at 9:29 am
ColdCoffee (8/29/2011)
; WITH CharsConvertedToDate AS
(
SELECT ID , SomeValue , FourCharDate ,
RN = ROW_NUMBER() OVER ( PARTITION BY SomeValue ORDER BY ...
August 30, 2011 at 8:43 am
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?...
August 29, 2011 at 11:46 am
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
August 26, 2011 at 2:03 pm
Viewing 15 posts - 3,631 through 3,645 (of 4,087 total)