Luis Cazares

Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 8,731 total)

RE: Return string between 2 characters from the end of the string

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...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 9:22 am

#1887354
RE: Issue with query

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...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 9:17 am

#1887350
RE: Issue with query

Can you include the CREATE TABLE script for task_user as well?
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:52 am

#1887334
RE: Issue with query

The error is not on that code.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:35 am

#1887320
RE: Question about profiler

Maybe something had to wait before completing? Too little information to be sure what's happening.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:32 am

#1887318
RE: Issue with query

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...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:29 am

#1887317
RE: Issue with query

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,...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:28 am

#1887316
RE: Today's Random Word!

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)
Red
Rum
Shining
Johnny
Bravo
Tango
Foxtrot
Whisky
Delta
Dawn
Dusk
Musk
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:27 am

#1887314
RE: Issue with query

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.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 8:08 am

#1887305
RE: Issue with query

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...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 7:52 am

#1887294
RE: Today's Random Word!

Ed Wagner (6/28/2016)
Grumpy DBA (6/28/2016)
ThomasRushton (6/28/2016)
Ed Wagner (6/28/2016)
Red
Rum
Shining
Johnny
Bravo
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 7:19 am

#1887278
RE: Return string between 2 characters from the end of the string

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...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 7:00 am

#1887269
RE: Matching 2 separate UNPIVOT statements with Null Values

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...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 28, 2016 at 6:52 am

#1887264
RE: SSIS 2008, how can I use parameterized query in OLEDB source of Data Flow task?

Duplicate post.
Answers in here: http://www.sqlservercentral.com/Forums/Topic1797738-364-1.aspx
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 27, 2016 at 2:29 pm

#1887139
RE: How can I use parameterized query (Select statement Where Col1= 'U') in OLEDB source of Data Flow task?

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],...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

June 27, 2016 at 2:28 pm

#1887138

Viewing 15 posts - 2,581 through 2,595 (of 8,731 total)