Stuart Davies (11/20/2014)

---

Koen Verbeeck (11/20/2014)

---

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable me):

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note...

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable me):

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note that you can cast...

GilaMonster (11/20/2014)

---

Your table is too wide. The fixed length columns in a table (data types other than varchar/nvarchar) cannot exceed 8060 bytes total. Your table is so large that adding...

Typically this is some sort of memory pressure issue. It might occur only during your nightly run.

Set up some monitoring to see what is going on at night.

Pointers:

* a lot...

Great question, thanks.

serg-52 (11/20/2014)

---

...

I'd argue ROWCOUNT_BIG is an odd one as well, as it is not calculated over the current result set, but over the results of a previous query.

Sean Lange (11/19/2014)

---

Koen Verbeeck (11/14/2014)

---

Jason-299789 (11/14/2014)

---

Koen Verbeeck (11/13/2014)

---

The CTE should be followed by a SELECT, INSERT, UPDATE or DELETE statement, not by an IF statement.

ps: the semicolon is a statement...

Take a look here[/url].

Try the REPLACE function.

=Replace(StrConv(Fields!name.value,vbProperCase),"."," ")

I'm not sure how your package is configured, but it would make sense to me that when a task is inside a loop, it can be executed multiple times.

Is the Send Email Task inside the loop?

The easiest way for people to understand your requirements, is that you post some sample data and the desired output.

And the expression doesn't work? It should result in the same query as the hardcoded one.

Sure, once he replies back 😀