View Complete Post
I need to compare the current price to an old price and not quite sure how to approach it. I am bringing in 3 CTE's that contain all of the data. Then # the bottom I'v got effective dates but I'm not sure how to re-write this and compare current prices to the old price that was effective before. The DNC Column is the column i have to compare in the last query
declare @dt datetime
set @dt = getdate();
With itmlvl as (
column0 Column1 ResultColumn
1 Mon, 07/12/2002 0 days
2 fri, 11/12/2002 4 days
3 mon, 14/12/2002 1 days
I have a problem that I want to show total of previous page in current page.
I have a table that I show sum of page in page footer. but i can not show that in next page.
I tried any way but I can do that in reporting service 2008.
Please help me as soon as possible.
I am trying to assign a value to a row based on the value of a field in the previous row. In this case, I am able to identify where first left character of the item number of the previous row is 5. When this is true I need to display the value of the meal_typ
field in each succsessive row until the condition is met again. So far the only thing that I have managed to do is pass the value to the first line.
I'm just not sure how to approach this issue. Perhaps there is a way to set a field in the main query equal to the result of the case in the subquery? Or perhaps there is a way to assign a variable to the subquery and set another variable equal to it
in the main query? I haven't been able to make it work yet but I believe that there must be a way.
I am not able to use a stored procedure for this because I need to post this in our ERP systems "sql query requester" which does not recognize references to a stored procedure.
Here is the query i am using now and a sample of the current result set:
select cur.line_nbr, cur.item_nbr, cur.meal_typ,
(select case when left<
I'm looking to have a search page where a user will select an item from a listview, then then taken to another page that wil display data based on their original selection.
A user will type in a string and be presented with a list of usernames that are like that string, when they select a user name who's profile they would like to view I would like the page that they're taken to, to be that users profile.
How would I transfer the variable from the search page to the profile page, and when I work on the profile page, how can I access that variable?
We've been trying to fix this one for a couple years, and I'm just out of ideas, so any help is really appreciated!
We've got a fairly large, complex web application that uses Forms Authentication to authenticate users. Throughout the application we store and retrieve information about users in the Session object, and in some cases in cookies. In a couple places we check for the existence of the context, and if it's null we send the user back to the login page to re-establish the session.
Just a quick run-down of this web app: C#, .NET 3.5, IIS 6, ASP.NET State Service to manage session
As for the session timer, we use our own home-grown timer, which is basically a client-side timer, which is backed up by a check to the SQL database to see when their last activity was. This seems to work well for us. It's not perfect, but it allows us to notify the user before the session times out, and allows us to be certain we're not logging a user out before their 60 minutes of inactivity is up.
What's happening is that certain users are being logged out after just a few minutes. We've eliminated the timer as a cause and believe what's happening is the HttpContext.Current is null, so the user is logged out. We do not know why the HttpContext.Current is null, and I underst
I have created a simple ASP.net Web Application (2.0) and have added a web user control.
Now in my page I have added this control but I have registered like this,
<%@ Register Assembly="WebApplication1" Namespace="WebApplication1" TagPrefix="Custom" %>
Which means I want to access all the controls in my current Web Application project
Then I have added my user control like this,
<Custom:MyUserControl ID="MyUserControl1" runat="server" PublicProperty="Hello" />
Every thing is fine but when I execute the project, NO control on my user control gets "instantiated" and thus I receive error "Object Reference Not Set"
Note that My Control has,
1) Public property PublicProperty as String
2) 1 Label control
In Load Event Handler I am setting Text property of Label Control to PublicProperty. Here object reference NOT set error occurs (which means Label control is NOT initialized).
I don't want to register my control using Src, TagPrefix etc. Any ideas?
MSDN Magazine June 2000
I Created a setup file with Custom Actions.
How can i get the Current directory of msi file is running?
I copied my installer on Desktop and installing.. in this case my current directory would be desktop location
Any Help would be Greatly Appritiated!!
My web application has user control which uses third party controls called Devexpress controls. The user control is a menu and is part of the Master page. It is placed there because this needs to be available in all the pages. My user controls raises a even on item clicked. Now, My question is that Is there any way to know that the event has occurred in page_load of the current page in which I am in?
In the Site Usage Reports, there is a section for 'Top Queries Over Previous 30 Days'. I would like to display this information to users.
Is there a existing webpart for this?
Is the data stored in a list that can be used for this purpose?
I finally got membership and roles setup and seems to be working.
I have setup a page to allow the creation of a user and editing of roles for a user.
I would like to setup a page with a gridview that displays all users and what roles they are assigned. I remember running across someone else that was looking to do the same thing, but cant find it. Not sure if it was in this forum or online somewhere else.
But i found that i can use the aspnet_Membership_GetAllUsers procedure in my db to get all the users, but how can i add the roles to each person and possibly setup the gridview so that each role they have, is displayed on their row in the gridview
So i would like to see something like this maybe more data displayed depending on the client request.
Username Email Last Login Roles