No announcements
Found 3270380 threads
-
1 VotesRounding an integer number to lowest nearest number
declare @value int = 299 select Round(@value, -2, 1) TomAnswered | 5 Replies | 960 Views | Created by Lakshmi m - Tuesday, October 8, 2013 6:58 AM | Last reply by Tom Cooper - Tuesday, October 8, 2013 1:53 PM
-
0 Votes
How select distinct with lowest value for each?
I remembered: select Fruit, MIN(Price) from #tmp group by Fruit. duhAnswered | 3 Replies | 1617 Views | Created by coojbs - Sunday, July 15, 2012 2:36 PM | Last reply by coojbs - Sunday, July 15, 2012 2:41 PM -
0 Votes
select the record with the lowest datediff()
if you specify DESC, you will get the hightest number to lowest difference.Answered | 7 Replies | 4405 Views | Created by daNewGuy - Wednesday, September 8, 2010 4:00 PM | Last reply by daNewGuy - Wednesday, September 8, 2010 5:25 PM -
0 Votes
Get 6 lowest values for column with Group By
Are you saying that you want to slect 6 lowest scores FOR EACH Player, sum these 6 per Player and the Query will returm the Players and their corresponding sums?Answered | 1 Replies | 283 Views | Created by Rinso - Thursday, November 28, 2013 3:59 AM | Last reply by Van Dinh - Friday, November 29, 2013 1:37 AM -
2 Votes
Sorting numbers highest and lowest
; Console.WriteLine("Enter {0} whole numbers.Answered | 4 Replies | 294 Views | Created by confusedrightnow - Wednesday, May 14, 2014 12:59 AM | Last reply by confusedrightnow - Wednesday, May 14, 2014 7:46 PM -
0 Votes
Count of the attributes at lowest granularity
when we use count we get aggregated value of all the calls and that is 21 .Answered | 4 Replies | 1315 Views | Created by VS_SQL - Saturday, November 17, 2012 10:41 PM | Last reply by Nishink - Monday, November 19, 2012 7:20 PM -
0 Votes
Displaying the lowest number in a list box
Two conversions are required, first to a string, then to a number: public static decimal?Answered | 3 Replies | 2610 Views | Created by RKramer - Monday, September 21, 2009 6:25 AM | Last reply by nobugz - Monday, September 21, 2009 3:03 PM -
0 Votes
Selection of value from lowest number in gridview
User702002538 posted For example subjectid column in gridview with checkbox and i and value ...Unanswered | 5 Replies | 101 Views | Created by An0nym0u5User - Sunday, May 30, 2021 11:37 PM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 12:27 AM -
0 Votes
Selection of value from lowest number in gridview
User702002538 postedFor example subjectid column in gridview with checkbox and i and value ...Unanswered | 5 Replies | 168 Views | Created by An0nym0u5User - Sunday, May 30, 2021 11:37 PM | Last reply by An0nym0u5User - Monday, May 31, 2021 12:14 AM -
0 Votes
How to select the lowest available item ID to insert in order table
In that case, try something like this: ;WITH CTEvw_ItemsNotOnOrder AS ( SELECT i.ItemID, i.ProductID, ROW_NUMBER() OVER (PARTITION BY ...Answered | 7 Replies | 3538 Views | Created by Swan_E - Thursday, February 23, 2012 4:11 PM | Last reply by Diane Sithoo - Friday, February 24, 2012 11:16 PM -
0 Votes
Textboxes Count Up: Highest and lowest numbers
But, that code does not set your min and max values you are looking for.Answered | 5 Replies | 406 Views | Created by Mafia_ManA - Saturday, January 11, 2014 2:31 PM | Last reply by Joel Engineer - Saturday, January 11, 2014 9:45 PM -
0 Votes
How do i sort a list of strings containing numbers from highest to lowest value please
Yes now you say that it was the zero location that was missing from the sorted list.Answered | 7 Replies | 291 Views | Created by AussieHack - Thursday, April 17, 2014 7:08 AM | Last reply by LeonCS - Thursday, April 17, 2014 11:50 PM -
0 Votes
SELECT statement to find highest values
It should be: SELECT TOP 5 <columns> FROM <Table> ORDER BY <value_column> DESC;Plamen RatchevAnswered | 6 Replies | 3013 Views | Created by Techie_Jones - Wednesday, September 16, 2009 3:38 AM | Last reply by Techie_Jones - Wednesday, September 16, 2009 8:20 PM -
0 Votes
how to indicate the lowest datetime
In addition to what Cor wrote, note that if you intend to insert that into Sql Server, it will fail, because Sql Server does not accept a date with that value.Answered | 3 Replies | 2333 Views | Created by marck68 - Wednesday, November 17, 2010 8:24 AM | Last reply by Chris Dunaway - Wednesday, November 17, 2010 10:33 PM -
3 Votes
Getting 6 lowest values for each group returns more than 6 rows
[Type] FROM @T AS T1 WHERE ( SELECT COUNT(*) FROM @T AS T2 ...Answered | 13 Replies | 3435 Views | Created by Tom McMaster - Saturday, March 6, 2010 5:14 PM | Last reply by Hunchback - Tuesday, March 9, 2010 3:31 PM -
0 Votes
The number of SELECT values must match the number of INSERT columns.
You are missing some commas in the SELECT list, one after [ID] and another after 'true'.Answered | 2 Replies | 3653 Views | Created by RichIEvans - Tuesday, May 29, 2012 11:39 AM | Last reply by RichIEvans - Tuesday, May 29, 2012 12:02 PM -
8 Votes
Find missing numbers from a sequence visual basic
''' <summary> ''' Returns the lowest value in the list or -1 if nothing missing ''' ...Answered | 6 Replies | 1975 Views | Created by HJohn2 - Thursday, January 10, 2013 6:36 PM | Last reply by Kevininstructor - Thursday, January 10, 2013 8:37 PM -
1 Votes
MDX Question to find lowest member in hierarchy
To simply put the requirement, From a set of members at all levels of Time hierarchy Year (2010, 2011, ...Answered | 3 Replies | 2695 Views | Created by Sunny Dagliya - Thursday, February 16, 2012 10:27 AM | Last reply by Rakesh M J - Tuesday, February 21, 2012 9:34 AM -
2 Votes
Select the numbers between two numbers
You can make an (big as needed) number table, from which you filter.Answered | 7 Replies | 6269 Views | Created by johnr2000 - Monday, October 18, 2010 8:02 PM | Last reply by Bjorn D. Jensen - Saturday, October 23, 2010 6:58 AM -
4 Votes
Get value from gridview column
I get the value from grid by function: function FindRowByCellValue (Grid, ChildView, ColName, SoughtValue){ var Val, ...Answered | 10 Replies | 85158 Views | Created by Sparc3 - Wednesday, May 24, 2006 12:56 PM | Last reply by MiracleRose - Thursday, October 13, 2011 8:12 AM - Items 1 to 20 of 3270380 Next ›
No announcements
