Use a CTE or a table with the additional email addresses to be added, cross join to a filtered set with code replacement and union the result to the original...

WayneS (4/3/2014)

---

Eirikur,

This is an excellent modification to an already excellent function. Very well done!!! (And it was such a simple change at that.)

Jeff Moden (3/24/2014)

---

Eirikur asked me to review it...

Ran your example through on

http://xslttest.appspot.com/

noticed the grouping is incorrect, if it is on lccs/lcc/, you will get multiple lines of subtotal.

NaN could be null or empty string.

😎

What about SSDT (Sql Server Data Tools) ?

😎

Luis Cazares (4/3/2014)

---

Isn't that over complicating something that could be achieved like this?

SELECT PONum

,POLineNum

,POSublineNum

...

Straight forward using Window functions

DECLARE @POSTUFF TABLE

(

PONum INT ...

Think of the columns in the group by as buckets, any aggregation is then applied to each bucket;

ColAColB

A1

B2

A2

B3

Group by ColA -> Aggregation on B

A (1,2)

B (2,3)

or in other words, it...

Thanks!

😎

If I remember correctly, you should re-configure the connections which before the protection level changes, where using the users credentials.

If you are using a SSIS configuration settings, walk through...

Did you try to expand the Favorites (first on the list in the toolbox)?

😎

Looks like the protection level is set to "encrypt with user key", if moved to another scope, it will fail.

😎

It is a simple base36 to base10 number conversion.

01Z(base36) == 71 (base10)

😎

bugmesh (4/3/2014)

---

Woke up and sprained my brain this morning. That's the only reason I can think of as to why this popped into my head.

Has anyone used a Raspberry for...

One small change needed

<td><xsl:value-of select="sum(../../*/*/costs)" /></td>

😎

todor.belchev (4/3/2014)

---

Hi,

I want to use a third party component in my SSIS package but I don't want to install it on the SQL server. This component is installed on a...