You can nest For Each loops in SSIS.

I agree. NULL and let the UI do the work on that.

Can you wrap the whole thing in a For Each Next loop? Around the Data Flow task?

(Emphasis added)

Why is it even necessary to...

Depends on what you want to do with the values.

Try this:

SELECT

OBJECT_NAME(I.object_id),

I.name,

I.type_desc,

Cols.IDX_Width

FROM

sys.indexes AS I

CROSS APPLY (SELECT

SUM(C.max_length) AS IDX_Width

FROM

sys.index_columns AS IC

INNER JOIN sys.columns AS C

ON C.object_id = IC.object_id

AND C.column_id = IC.column_id

WHERE

IC.object_id = I.object_id

AND IC.index_id = I.index_id)...

fergfamster (5/26/2016)

---

Well I gave the code at the beginning.

here is my original with 1 inline query:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[MyFunction](

@Usage_Date SmallDAteTime,

@RateCode Varchar(4)

)

RETURNS TABLE...

Don't leave because you think something else might be better. Leave because you know it will be better.

I've seen a LOT of "greener grass" that turned out to be...

The most important thing to keep in mind about performance tuning is: Be sure you're tuning what needs it.

I've seen months and fortunes wasted tuning things that nobody cared about...

I just found another query by the same person, where it divides a Numeric column by 100, then casts it as Varchar, then LTrims and RTrims the result, in a...

Jeff Moden (4/11/2016)

---

J Livingston SQL (4/11/2016)

---

It would be appreciated if the OP can post some sample data etc.

if there are millions of rows as suggested then it would be good...

No single-quotes...

Hugo Kornelis (4/10/2016)

---

Without CREATE TABLE and INSERT statments I cannot test anything, but my gut feeling is that you will end up with a pattern somewhat like the below:

SELECT List,...

Then, of course, there are the opposite situations:

I was interviewed for a Senior SQL Dev position a while back. First question they asked was the differences between Truncate and...

Phil Factor (3/21/2016)

---

I once interviewed a candidate that was very obviously a different person to the one I did a preliminary telephone interview with. I politely terminated the interview when...