Viewing 15 posts - 16 through 30 (of 114 total)
it means you have values in your varchar fields that either are not numeric and cannot be cast to a int or they are a value that falls outside of...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
June 14, 2011 at 5:37 am
Yes the function will be called twice and as for the difference between the RBAR version and the select, you have to test.
We can't say the duplicate evaluation...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
June 14, 2011 at 5:35 am
if you have to call a UDF for each insert, by definition you have to RBAR it. I'm curious why you have to call a function before each insert...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
June 13, 2011 at 6:41 am
I'm not sure why you would ever have to do something like this unless you had a bad data model to start with but also followed some specific rules. ...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
June 7, 2011 at 11:24 am
Now, this may sound naive...but do you work hard to get the raise or do you work hard because it is its own reward. Sure, getting a nice raise...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
May 19, 2011 at 5:38 am
Couldn't you just use the ISNUMERIC() function on that field and anything with a zero won't cast to an int?
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
May 17, 2011 at 1:38 pm
Your welcome! Anytime.
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
May 16, 2011 at 6:42 am
sorry about that. i forgot to remove the UP references....
SELECT UP.TableRecordUID
...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
May 16, 2011 at 6:31 am
This should help:
SELECT UP.TableRecordUID
,UP.CreatedDate + UP.CreatedTime AS 'CreatedDateTime'
...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
May 16, 2011 at 5:35 am
Not to be rude, but are you just searching for #? It would only return one if you ended up searching for 'drop table #'
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 18, 2011 at 6:01 am
Here's the foundation of what you need: (there are some tweaks you'll need though for the zeros and first/last records)
select T1.Serial, (T1.I_C_O - T2.I_C_O) as Positive, (T2.I_C_O - T1.I_C_O) as...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 18, 2011 at 5:57 am
i don't understand your comment.
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 18, 2011 at 5:41 am
how do you know it doesn't? It want way doesn't it work? (I know it won't for encrypted procs, but other than that it looks ok).
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 18, 2011 at 5:28 am
Whats the order of the data? If you want to compare rows like that, they should have a logical order in the data and it only appears you have...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 18, 2011 at 5:25 am
did you paste the exact error? It states something about converting 'Waive' to an int. You have 'Waiver' in your example.
please double check...
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
March 17, 2011 at 1:41 pm
Viewing 15 posts - 16 through 30 (of 114 total)