No announcements
Found 4476532 threads
-
0 Votes
How to calculate max value for decimal type
Max value 12 digits before decimal and 6 digits after the decimalWith Thanks and Regards Sambath Raj.CAnswered | 4 Replies | 8178 Views | Created by Isolda - Friday, May 25, 2012 11:41 PM | Last reply by Sambath Raj.C - Monday, May 28, 2012 10:10 AM -
3 Votes
max value using decimal part
i did made use of packed value approach , i saw ur post on msdn but that is not working for me under some scenario that was the reason i opted this.Answered | 22 Replies | 2378 Views | Created by anki2010 - Monday, September 19, 2011 4:36 PM | Last reply by anki2010 - Monday, September 19, 2011 8:33 PM -
0 Votes
Min or Max value of ListBox
Hey Reed, how about the minimum??Answered | 7 Replies | 8536 Views | Created by Hoorayo - Wednesday, April 1, 2009 4:36 PM | Last reply by nikhilsharma1990 - Thursday, September 20, 2012 5:15 PM -
0 Votes
max value of a integer field in mscrm 2011
Hi San ; yes you are right let me explain you the scenario i have a counter field for all quote products so when i add new product the counter should add ...Answered | 5 Replies | 3216 Views | Created by anwar_addi - Tuesday, July 3, 2012 11:01 AM | Last reply by san Sanz - Friday, July 6, 2012 9:49 AM -
0 Votes
Format string decimal to a max decimal length
I think you can use StringFormat: http://blogs.msdn.com/b/llobo/archive/2008/05/19/wpf-3-5-sp1-feature-stringformat.aspx Something like this should do: ...Answered | 2 Replies | 1352 Views | Created by moondaddyx - Tuesday, January 24, 2012 4:47 AM | Last reply by Louis.fr - Tuesday, January 24, 2012 1:20 PM -
0 Votes
How to ensure that the max primary value is never exhausted
I wouldn't worry too much about running out if integers with a bigint data type.Answered | 4 Replies | 246 Views | Created by TechPassionate - Friday, October 17, 2014 9:47 PM | Last reply by Dan Guzman - Saturday, October 18, 2014 9:34 PM -
1 Votes
Get max value of column
So, I want to get before each insert, the max(id) of column in a variable, increase this variable by one and use it for the next record.Answered | 2 Replies | 5718 Views | Created by ChronisK - Wednesday, December 9, 2009 5:07 PM | Last reply by COZYROC - Wednesday, December 9, 2009 5:19 PM -
0 Votes
Not Getting max value In sql Max.
Hello, The MAX result 999999 is correct, because the first char "9" is higher then "5"; it's a varchar field and so the values are compared ...Answered | 3 Replies | 5041 Views | Created by kanchan singh - Friday, September 9, 2011 2:14 PM | Last reply by Olaf Helper - Sunday, September 11, 2011 7:04 AM -
0 Votes
How to get a max() value
select ID, max(value) as MaxValue from myTable group by ID order by IDPremature optimization is the root of all evil in programming.Answered | 1 Replies | 4166 Views | Created by chinnasql - Thursday, May 13, 2010 10:11 PM | Last reply by Naomi N - Thursday, May 13, 2010 10:19 PM -
0 Votes
Max Value
Hi Shivana, Based on your scenario, you can insert a new column for the tablix and use the Max() function to display the name of the department.Answered | 2 Replies | 2211 Views | Created by Shivana - Thursday, March 15, 2012 8:59 AM | Last reply by Mike Yin - Monday, March 26, 2012 12:05 PM -
8 Votes
Max value
On the other side, we do not need to sort in order to calculate the maximum value for the whole set.Answered | 7 Replies | 3894 Views | Created by ski_freak - Friday, March 20, 2009 8:03 PM | Last reply by Kent Waldrop _ - Saturday, March 21, 2009 1:59 AM -
0 Votes
Converting a decimal (including the integer and the decimals portion) into an integer
How about if it is greater than an Int32 and I need more than the first element in the array?Answered | 11 Replies | 2336 Views | Created by CalinMac - Thursday, September 3, 2009 3:23 AM | Last reply by CalinMac - Thursday, September 3, 2009 5:04 PM -
0 Votes
What is the downside to VARCHAR(MAX)?
Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.Answered | 3 Replies | 473 Views | Created by ryguy72 - Monday, December 30, 2013 4:11 PM | Last reply by ryguy72 - Monday, December 30, 2013 5:16 PM -
0 Votes
Max and Max but one date
Thanks for your replies and sorry for not providing enough details - I have to get the max and max but one date bu customer.Answered | 9 Replies | 2977 Views | Created by Sam1980 - Wednesday, June 29, 2011 4:18 PM | Last reply by Naomi N - Wednesday, June 29, 2011 4:33 PM -
1 Votes
Getting the max/min value of an array?
If so, how should I go about learning them?Answered | 27 Replies | 30347 Views | Created by Joan Venge - Tuesday, March 13, 2007 12:53 AM | Last reply by Tornike Bibiblashvili - Saturday, March 31, 2012 8:39 AM -
0 Votes
max value of a varchar with pivot
You should not get an error, VARCHAR is just fine with MAX: CREATE TABLE CampaignsTacticsColumns ( RowID INT, TacticsColumnsID VARCHAR(10) PRIMARY KEY, ...Answered | 1 Replies | 5896 Views | Created by gotaquestion - Friday, October 9, 2009 1:33 AM | Last reply by Plamen Ratchev - Friday, October 9, 2009 1:48 AM -
0 Votes
Nth Max value in a table
Hi Raji, If the data is in a DataTable and it's not sorted, you can use the following method.Answered | 3 Replies | 2124 Views | Created by Raji.IT - Monday, October 25, 2010 5:00 AM | Last reply by Manjuke Fernando - Monday, October 25, 2010 6:07 AM -
2 Votes
select max from a table
It can never have a key because everything is NULL-able.Answered | 11 Replies | 1574 Views | Created by Dkuud - Wednesday, September 26, 2012 1:55 PM | Last reply by GreenBinary - Thursday, September 27, 2012 1:52 PM -
0 Votes
How can I force the input value with Max integer and Max Decimal .
I resolved it another way and it seems working fine.Answered | 3 Replies | 330 Views | Created by An0nym0u5User - Thursday, May 27, 2021 6:39 AM | Last reply by An0nym0u5User - Friday, June 4, 2021 11:39 AM - Items 1 to 20 of 4476532 Next ›
No announcements