Viewing 15 posts - 5,026 through 5,040 (of 9,726 total)
I've been testing further and it turns out it's the setting of the result to the variable that's causing the issue.
Try this:
DECLARE @result as numeric(38,9),@ftest as numeric(38,8), @ResultNonConvert as numeric(38,8),...
December 15, 2011 at 6:10 am
Is there a reason why the second line uses UPPER() instead of LOWER()?
I'm trying to test this just using the code inside the function and it is taking a damn...
December 15, 2011 at 6:05 am
Wow. I have just replicated this behavior using your code.
Hmm. What version SQL Server are you using?
EDIT: In further testing, it's not the function that is the problem. Try this...
December 15, 2011 at 5:44 am
As I have said in many of my SQL Saturday presentations, Books Online is your best friend. Learn it, Live it, Love it.
December 15, 2011 at 5:41 am
Stefan Krzywicki (12/14/2011)
Here I go asking for opinions againDoes anyone know about configuring your sql server on a SAN? Or have opinions about the best place to put the files?
Yes,...
December 14, 2011 at 11:51 am
So I'm about ready to murder a pork chop or two at this point. Anyone have a pork chop flinger handy?
Moved the package to another environment. Recreated the job (scripted...
December 14, 2011 at 11:23 am
Roy Ernest (12/14/2011)
You all are NUTS. I think I am the only sane person in the THREAD. 😀
That's what all the crazy people say...
December 14, 2011 at 11:07 am
Good idea, but if it were a permissions issue, I would not expect a syntax error.
We've had permissions issues on other packages / jobs before, and never gotten this...
December 14, 2011 at 10:57 am
TedT (12/14/2011)
Open each of the script tasks individually, and right click - build them... Do they build successfully?
Build succeeded on both.
EDIT: Although now I can see, on the Build menu,...
December 14, 2011 at 8:24 am
Steve Jones - SSC Editor (12/9/2011)
Brandie Tarvin (12/9/2011)
Oh, it's not a thread. I didn't post on this. I just found it and put a dent in my desk the shape...
December 12, 2011 at 11:22 am
Dev (12/9/2011)
Brandie Tarvin (12/9/2011)
DUH!Code
December 9, 2011 at 9:41 am
DUH!Code
Example: Brandie's code...
December 9, 2011 at 7:14 am
Let me try again, but it's going to be tomorrow. I've got a work emergency.
December 8, 2011 at 12:07 pm
p-nut (12/8/2011)
So, for the feeble minded Jared, what is the difference in function by having a column in the key or the include?Jared
Gail feel free to correct me if I'm...
December 8, 2011 at 12:01 pm
jcrawf02 (12/8/2011)
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
Evil, evil, evil...
Seriously, though, with all the grease in Jason's brain from all those Cheezburgerz, how can...
December 8, 2011 at 11:26 am
Viewing 15 posts - 5,026 through 5,040 (of 9,726 total)