SQL Server :: Strategies For Using Order By?
Oct 2, 2010
using .NET 4 and SQL Server 2008R2
I have a table of persons that used for different purposes in a database. One of those purposes is to present a list of organization contacts to users. I use a gridview and stored procedures to get the data.
On one page listing all organization contacts the client requires the order of the persons to be presented as President first, Vice President second, Secretary third, etc. I accomplished this requirement by simply entering the persons in the table in the order in which they were required to be displayed on that particular page.
But then on another contacts page the client requires only a subset of the persons in the table to be displayed, moreover, the order of the persons is to be presented as Secretary first, Office Administrator second, President third and Vice President fourth.
I have no idea how to pull the data into my gridview in the order that's required for the 2nd page. I thought about adding a column in the table that I could use to store a numeric value and then order by that value in the procedure that pulls the data for the second contact page, but this somehow seems wrong.
View 4 Replies
Similar Messages:
May 17, 2010
In this case I have a system where a user logs in, they get a dashboard and they can see all their related projects. The user can click on the project and open it. (ie /View/79) The problem the user can also just type /View/68 which they are not supposed to be able to view.
Obviously I am aware of how to filter my data, but this application has many many lists of data and it all needs to be scoped to data that user has been allowed to see. I can insert a plethora of joins and wheres in all my queries but.. it's a lot of work and a bit convoluted.So I was wondering what strategies other had used for filtering data based on the user scope.One approach I was thinking of was to extend my user-role-permission model so "permissions" could be assigned to various entitites (like projects). This way, rather than doing a series of joins etc to see confirm a user has been assigned to a project, my join is just onto the EntityPermission table to confirm the user has PermissionX (like: CanView) on that entity. I could either maintain a seperate M2M table for each entity i need to restrict or something a bit more general (but without referential integrity).
View 3 Replies
Sep 29, 2010
using asp.net 4 and vs 2010 I have a listview that displays data from a database. I have to configure it to display all column data where present, however, not all columns have data, with the result that blank spaces get rendered where this data would normally be displayed.
The code:
[Code]....
So, for example, some of the individuals that exist in this table might no longer be associated with a specific department, institution or have data in the "Address2" column.
View 4 Replies
Jan 23, 2010
I have 5 hard corded texboxes in a page in a sequence with sequence Number . Now i want to add re-order /re-arraning functionaly .. but i can't use ajax reorder list because i have 5 hard corded texbox. how can i maintain the order in Insert/Update cases. And also suggest me control that i can use, another than ajax re-order list. coz i not using any list items i have hard corded items on the page.
View 1 Replies
Feb 7, 2011
The AjaxToolkit has a ReorderList. I'm searching for a jQuery solution that does the same and found this page. I would like to change the order of divs (vertically) and upload the new order to the database (ajax).
View 2 Replies
Oct 22, 2010
I have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
View 7 Replies
Apr 24, 2010
From my testing, it appears that the order of parameters for the UpdateParameters must match both the order of the bound fields on the form (asp:Formview), and the order of the parameters in the UpdateCommand. Is that correct? If so, why do the parameters have names if all that matters is the order? I tried both asp:ControlParameter and asp:Parameter. Maybe the more relevant question is why aren't the names used instead of the order, particularly for the form order?
So, given I display the Identity field (CID), and need that for the update, I cannot get the update to work without including it in the UpdateCommand. Of course, since it is an autonumber field in Access, I cannot actually set it. So, I had to add another field to the db (lngUpdateCID) that I could set. That can't be how it has to be done, but I could not figure out another way to do this.
The relevant code is below:
[Code]....
View 23 Replies
Oct 15, 2010
I have this statement:
[Code]....
The problem is, it is not ordered correctly. How can I order it correctly with earliest datetime on top?
View 5 Replies
Aug 24, 2010
How can I order this by count? so if it appears above and below the union statement, I want it on top
[Code]....
View 3 Replies
Jan 8, 2011
I have a column TimePeriod with values in mmm-yyyy format. ex. Jan-2010, Apr-2010,Nov-2010, Dec-2010, Jan-2011
How can I wirte query so result will be in order by Jan-2010, Feb-2010,..... Jan-2011.
I tried to cast, convert but i couldnt figured it out. I did googling... can't find solution.
View 3 Replies
Aug 27, 2010
the Document Rank column is numeric and contain the values are 2,1,0,4,0,5,3,0,6
we need to get the document rank with the following orders 1,2,3,4,5,6,0,0 how can i do this?
View 1 Replies
Jan 19, 2011
I am having trouble with my ORDY By Case Statement. It doesn't seem to be ording correctly. To see it in action, please go to [URL] and click on "latin" and it should change the sort order and when you click back on "common" it should change it back but it doesn't. Here's my code:
[Code]....
View 17 Replies
Feb 2, 2011
using sql server 2005. I have table setup as follows
Table: Orders
Col: CustomerID
Col: OrderID
Col: OrderDate
so a given Customer can have many orders in this table however I only want to return the last order (using OrderDate) for each customer. how do you do this? I assume that I need to group by customerID and then use max on the OrderDate but not sure of the exact syntax.
View 4 Replies
Feb 2, 2011
I want to update the database as shown below. I want to sort the values from col1,2,3,4 in numeric order and save the sorted values back to the database.
Now in database table
IdentityInteger Col1 Col2 Col3 Col4
1 4 2 1 3
Wanted results in database table
IdentityInteger Col1 Col2 Col3 Col4
1 1 2 3 4
View 15 Replies
Jan 11, 2011
Below the is working fine but I am not getting in month order.
SELECT SUM(TaxableAmt) [NSV], (UPPER(CONVERT(VARCHAR,LEFT(DATENAME(MM,invoicedate),3)))+'/'+ CONVERT(VARCHAR,RIGHT(DATENAME(YYYY,invoicedate),2))) AS MONTHYEAR
FROM SALESDATA where (invoicedate >='4-1-2009' and invoicedate <='4-30-2010')
GROUP BY (UPPER(CONVERT(VARCHAR,LEFT(DATENAME(MM,invoicedate),3)))+'/'+
[Code]....
View 5 Replies
Dec 2, 2010
i want to select three records order by Date .This is my News table.
NewID NewTitle NewContent NewDate
1 Example ExampleContent 01.12.2010
2 Example2 ExampleContent2 02.12.2010
3 Example3 ExampleContent3 03.12.2010
4 Example4 ExampleContent4 04.12.2010
So,query selects example4,example3 and example2.
View 5 Replies
Oct 7, 2010
Ascending order based on the Date and month?
[Code]....
View 2 Replies
Sep 29, 2010
we are a company that owns more than 12 domains and we would like to have our own server in our office that we could put our websites, ms sql database in. we are thinking to get Windows Server 2008 R2 but we do not know how to proceed in order.
are we allowed to have our own server in our office to store our websites, sql servers?is it going to work fast if we have one or is it going to be slower than now ( we have dedicated server now)how do we pay? do we need to pay every year or we pay once and then it is all ours? I await for the replies.
View 5 Replies
Feb 10, 2011
ing to show customers and their order totals. There are a few joins involved since the order items quantity and price come from 2 different tables. Here is the query:
select DISTINCT
c.custnumber
ordertotal = convert(money, (SUM(c.quantity) * d.Price))
from custOrders c
left join purchaseorders p on p.cust_code = c.cust_code and p.purchno = c.ponumber
left join purchasedetail
[code]...
View 10 Replies
Oct 12, 2010
In my table I have a varchar type column, the values like..
sale_date
04/23/2010
02/03/2010
12/24/2010
I need to retrieve the records in both ascending and descending order. Problem is now it is a varchar type if I use order by o/p like
02/03/2010
04/23/2010
12/24/2010
I tried with convert(DATETIME,sale_date) but no use.
View 4 Replies
Jul 24, 2010
In C# I need to connect to a database. How do I find out the username and password to use for that database? I know that sometimes the "sa" username can be used. I don't know how to find the password though. I am working on a contract and no DBA, and the developer left for a different job.
View 1 Replies
Nov 5, 2010
I wanna save the order of my list to the sql server database in jquery drag & drop using asp.net c#. How can I do this?
View 1 Replies
Jan 20, 2010
Am using the addrotator in an update panel to display people images.
The data source is MS SQL server.
On my data access layer I have queried the information Ordered alphabetically using Names.
However the add rotator displays them randomly.
View 7 Replies
Jan 3, 2011
i just create table simply like this: create table tblDemo
(
PK_intID int primary key identify(1,1),
intHits int not null
[code]...
View 3 Replies
May 21, 2014
There are many customer' order as pdf file stored in one file server.my app just open url (file path) to display pdf file on the screen.Now, boss want me to create a asp.net app to send an email with attached order pdf file which is the same url as intranet. How to complete it?
View 5 Replies
