Ninja's_RGR'us (10/21/2011)

Grant Fritchey (10/21/2011)

Throw out an...

Of course, the real way to do this in T-SQL isn't recursive, but that would violate your assignment.

select sum(X)

from (select top (n) X

from...

Is there any reason to not just delete the row with incomplete data? If you don't, you'll end up with two identical rows, and that's either a violation of...

Any reason you posted the same question in English and Spanish? (I read both.)

Is the precendence such that the one you want to replace will always have a zero-length string as the value, and there will always be at most one other row...

SSIS with a For Each Next Loop can do that easily.

Thought so.

Did you take a look at the recursive CTE article I linked to?

Homework or a test?

Take a look at: http://msdn.microsoft.com/en-us/library/ms186243.aspx

Jack Corbett (10/21/2011)

Brandie Tarvin (10/21/2011)

What sort...

Who's the intended audience?

Pants or snow?

Per the txt file he attached, it's a LATCH_EX wait (0x404), and the host process is Task Manager.

Doesn't tell us much, but it says it's code waiting to execute, not...

Open up the properties of your data destination. Go to "Error Output", and see what you have set as the "Error" property.

The options are:

Fail component

Ignore failure

Redirect row

"Fail component" will...

In the error-handling settings for the data flow, what are the settings?

Tools is tools, true.

On the other hand, specializing generally leads to a much higher degree of skill in the focus area. So, while all problems may look like nails...