No announcements
Found 2316533 threads
-
0 VotesData grid dynamic filter/ sort solutions.
Sorting in database would be costly.Answered | 2 Replies | 907 Views | Created by vikas kumar pathak - Saturday, April 29, 2017 9:54 AM | Last reply by Sarat (SS) - Sunday, April 30, 2017 1:14 AM
-
0 Votes
Display grid data in random order.
In LightSwitch (or in the service itself), you can sort by that property.Answered | 3 Replies | 1225 Views | Created by Stu Ryan - Friday, April 5, 2013 9:39 PM | Last reply by Yann Duran - Monday, April 8, 2013 2:11 AM -
0 Votes
select data in reverse order
Ok, another possibility, if you create a clustered index and sort the index in descending order, then it should work, as it normally returns rows in table order, but this is ...Answered | 11 Replies | 7680 Views | Created by Wojciech Wojtulewski - Tuesday, August 2, 2011 1:44 PM | Last reply by Badii Gharbi - Tuesday, August 2, 2011 3:26 PM -
0 Votes
dynamic data - data grid and storing sort order and last record selected
User-330204900 posted Hi Jrees, have a look at my article here Filter History for Dynamic Data 4 I have not yet expanded it to handle ...Answered | 2 Replies | 31 Views | Created by Anonymous - Tuesday, January 22, 2013 7:20 AM | Last reply by Anonymous - Friday, January 25, 2013 10:10 AM -
1 Votes
Select the last records inserted to table
No, without a special column that will dictate the sort, there is nothing in SQL Server (except for checking the transaction logs) that will tell us which record was inserted ...Answered | 11 Replies | 12552 Views | Created by Jammusi - Wednesday, March 16, 2011 8:59 PM | Last reply by MarcDeVegas - Monday, July 11, 2011 7:30 AM -
1 Votes
Order of data has changed after sorting with date values in data.
So that i have split and stored the each date in collection and sort them by date to set the proper order like below, A - ...Answered | 7 Replies | 673 Views | Created by Piruthiv - Wednesday, December 18, 2019 8:38 AM | Last reply by Piruthiv - Friday, December 20, 2019 6:12 AM -
0 Votes
ordering the data
0,record.Field<string>("hotkey"), record.Field<string>("name") select record; DataView dv = ...Answered | 4 Replies | 2690 Views | Created by prk - Monday, March 15, 2010 1:05 AM | Last reply by CiaranODonnell - Monday, March 15, 2010 1:30 PM -
3 Votes
Iterating Over LightSwitch Data Grid Records
I have x, y, z columns in data grid which mapping with the data item.Answered | 8 Replies | 7818 Views | Created by ell22 - Monday, September 19, 2011 6:33 PM | Last reply by Haridas12341234 - Tuesday, September 11, 2012 12:32 AM -
0 Votes
Create a dynamically ordered stored procedure
Hi, Yes, it can be done by dynamic SQL.Answered | 3 Replies | 969 Views | Created by Mad-Dog - Wednesday, October 9, 2013 6:32 PM | Last reply by Saeid Hasani - Thursday, October 10, 2013 7:54 AM -
0 Votes
Selecting Last Record Per
The OP stated "Select the records, GROUP BY the FKID and MAX(ID)", but your suggestion or idea doesn't have to be exact.Answered | 13 Replies | 4124 Views | Created by Nathon Dalton - Friday, October 7, 2011 2:46 PM | Last reply by Nathon Dalton - Friday, October 7, 2011 5:27 PM -
2 Votes
Sorting data problem
hi i tested this and it works as i want; but i was unable to do the same thing with a data table in access database. please can you specify how to do the same ...Answered | 3 Replies | 1899 Views | Created by Valentine Wickramarathne - Saturday, March 24, 2012 5:36 AM | Last reply by Valentine Wickramarathne - Tuesday, March 27, 2012 3:30 AM -
1 Votes
data base- data grid error
Hi, Add a sort criteria (either in your SQL statement or client side for your DataTable if this is what you are using).Answered | 4 Replies | 875 Views | Created by fauji-ak47 - Saturday, March 30, 2013 10:45 PM | Last reply by BonnieB - Sunday, March 31, 2013 1:01 AM -
0 Votes
SELECT and order of data returned......
In this case, data is sent in a different order unless it is explicitly ordered using the ORDER BY.Answered | 3 Replies | 5145 Views | Created by edm2 - Friday, January 14, 2011 7:12 PM | Last reply by Sankar Reddy - Saturday, January 15, 2011 12:12 AM -
1 Votes
ADF copy data and sort data in ascending order
It is better to copy CSV as is to Storage and then use data flow to sort by ascending while writing to destination as JSON.Answered | 4 Replies | 1101 Views | Created by abhinav_9 - Friday, January 24, 2020 8:03 AM | Last reply by KranthiPakala-MSFT - Wednesday, January 29, 2020 7:49 PM -
2 Votes
OLE DB Source - Data is not displaying in Sorted Order
You set this property when you use the ORDER BY clause in your SELECT SQL statement to instruct the downstream components the data is coming sorted using particular ...Answered | 6 Replies | 2427 Views | Created by Nag2222 - Tuesday, September 16, 2014 4:59 PM | Last reply by COZYROC - Wednesday, September 17, 2014 7:37 PM -
2 Votes
Data Sorting Location?
Select the Edit Query link.Answered | 3 Replies | 2880 Views | Created by Felyjos - Wednesday, September 22, 2010 7:42 PM | Last reply by Felyjos - Wednesday, September 22, 2010 9:35 PM -
0 Votes
Bind sorted data view to grid view
No..This is for Grid View in .NetAnswered | 5 Replies | 1386 Views | Created by ME_77 - Thursday, March 5, 2015 11:36 AM | Last reply by George123345 - Monday, March 9, 2015 4:59 AM -
0 Votes
Report Parameter to sort the grid
It works, but... the last row which contains the average is sorted too.Answered | 6 Replies | 4009 Views | Created by Gaboss - Thursday, March 29, 2012 8:29 AM | Last reply by Josh Ashwood - Tuesday, April 3, 2012 9:40 PM -
0 Votes
Data Ordering
Here is an example of q query that doesn't return the result in clustered index order even though all you are doing is selecting the clustered index key.Answered | 2 Replies | 348 Views | Created by Priya Bange - Thursday, June 15, 2017 1:59 AM | Last reply by Tom Cooper - Thursday, June 15, 2017 3:06 AM -
1 Votes
sort group as last created order??
> you can not display group as a last created order?Answered | 1 Replies | 938 Views | Created by rakib1 - Monday, February 17, 2014 4:46 AM | Last reply by Devendra Velegandla - Monday, February 17, 2014 5:20 AM - Items 1 to 20 of 2316533 Next ›
No announcements
