More like this:

AVG(datalength(CAST(embedded_data AS varbinary(MAX))))

However, the image data type length can fit in an int.

From BOL for DATALENGTH:

Return Types

bigint...

Can you include the CREATE TABLE script for task_user as well?

The error is not on that code.

Maybe something had to wait before completing? Too little information to be sure what's happening.

narayanamoorthy.a (6/28/2016)

---

Yes the query gets executed successfully from SSMS apart from the third step where I get error Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression...

No, it's not. CONVERT will allow to use format codes,...

Musk

Date data type is available since 2008.

The only problem seems to be possible in the COUNT(*), try using COUNT_BIG(*) instead.

If you're actually deleting all those rows, be careful on filling the log.

Another possibility is that the...

Bravo

Jeff Moden (6/27/2016)

---

Luis,

Quote the OPs post where he posted the data and you'll see that the spaces are not where you expect. The sub-fields within the column are all...

It makes sense, but I found no relation to the question.

The APPLY operator is similar to a JOIN but with additional capabilities. It allows you to reference columns from tables...

Duplicate post.

Answers in here: http://www.sqlservercentral.com/Forums/Topic1797738-364-1.aspx

You need to build the value of the variable as an expression as there's no place to define parameters in the data flow for the data source.

"select name as [name],...

Please share the values and data types, with the end format you wish to obtain. Please post different examples to understand the different possibilities.