Viewing 15 posts - 2,581 through 2,595 (of 8,731 total)
manderson 20961 (6/28/2016)
Sorry guys my first post on here. I'll try to be better the next time. Thanks for all your help!
No problem, as long as you understood the problems...
June 28, 2016 at 9:22 am
ChrisM@Work (6/28/2016)
Just a thought - try this mod:
AVG(CAST(datalength(embedded_data) AS BIGINT))
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...
June 28, 2016 at 9:17 am
Can you include the CREATE TABLE script for task_user as well?
June 28, 2016 at 8:52 am
Maybe something had to wait before completing? Too little information to be sure what's happening.
June 28, 2016 at 8:32 am
narayanamoorthy.a (6/28/2016)
Arithmetic overflow error converting expression...
June 28, 2016 at 8:29 am
durga.palepu (6/28/2016)
Exactly what I am thinking i.e. instead of using convert() its more accurate to use CAST() most of the times.
No, it's not. CONVERT will allow to use format codes,...
June 28, 2016 at 8:28 am
Y.B. (6/28/2016)
djj (6/28/2016)
Ed Wagner (6/28/2016)
Ray K (6/28/2016)
crookj (6/28/2016)
eccentricDBA (6/28/2016)
Luis Cazares (6/28/2016)
Ed Wagner (6/28/2016)
Grumpy DBA (6/28/2016)
ThomasRushton (6/28/2016)
Ed Wagner (6/28/2016)
RedRum
Shining
Johnny
Bravo
Tango
Foxtrot
Whisky
Delta
Dawn
Dusk
Musk
June 28, 2016 at 8:27 am
durga.palepu (6/28/2016)
@luis,CONVERT(DATE,GETDATE()-180) may not work for the OP if he uses SQL Server 2008 or earlier.
Date data type is available since 2008.
June 28, 2016 at 8:08 am
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...
June 28, 2016 at 7:52 am
Ed Wagner (6/28/2016)
Grumpy DBA (6/28/2016)
ThomasRushton (6/28/2016)
Ed Wagner (6/28/2016)
RedRum
Shining
Johnny
Bravo
June 28, 2016 at 7:19 am
Jeff Moden (6/27/2016)
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...
June 28, 2016 at 7:00 am
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...
June 28, 2016 at 6:52 am
Duplicate post.
Answers in here: http://www.sqlservercentral.com/Forums/Topic1797738-364-1.aspx
June 27, 2016 at 2:29 pm
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],...
June 27, 2016 at 2:28 pm
Viewing 15 posts - 2,581 through 2,595 (of 8,731 total)