Sounds more like you need a few derived columns rather than a conditional spit. You could then take the parts of the string that you need using the SUBSTRING and...

Although MERGE isn't available in 2005 you can still replicate it to a decent degree. See here for some links.

Since you're not letting on what type of load this...

The OLEDB command component in SSIS is a row by row transformation - I'm not surprised it's slow. If you must update changing rows, then consider using a MERGE in...

What method are you using to update the rows (in your original solution)? Is this a Data Warehouse? What is the size of the table?

No problem, happy to help.

Ranking functions are described here: http://msdn.microsoft.com/en-us/library/ms189798.aspx

They're quite handy 🙂

If you don't mind which code it is then something like

WITH Cte AS

(SELECT ref_id,

cus_id,

code,

amt,

ROW_NUMBER() OVER(PARTITION BY cus_id ORDER BY amt DESC) AS Rank

FROM

z_temp)

SELECT Code, count(*) FROM cte WHERE...

I'm happy to help 🙂

There are two screens attached here (too big for one!)

You'll notice something that I missed from my original description. If it's a new business year...

There are a few ways this can be achieved, depending on your data. I'll describe a solution I did for a client recently and hopefully it'll help you out....

The way...

Hi,

Sorry for the delayed reply, work has been mad.

It's a difficult one to do unless you are loading in a full table each time (and not doing anything incrementally). If...

If the destination is a SQL Server db, you cannot beat a MERGE statement in T-SQL for performance.

As for the Oracle thing, SSIS would be your best bet. Do...

Another thing you may want to consider is adding in some sort of check to see if the columns actually have different values. I use CHECKSUM for this....

[Code="sql"]

WHEN

MATCHED AND

(

CHECKSUM

(

[Source].whatever

)

<>

CHECKSUM

(

[Target].whatever

)

)

THEN...

What steve said is right. The actual code would be

ucase(fields!ifieldname.value)

Doh! I meant to say the XML code for the drillthrough action. 🙂

Hi Dave,

Post the MDX and I'll take a look. 🙂

If you use it in SSIS, for example, it can break your package if a new column is added.

Also, staying on the ETL thoughts, it's not always prudent to...