SQL Server :: Calculating Is Only The First Row In OrderDetails
Dec 5, 2010I have this SP. When I run this one my calculations is only the first row in OrderDetails. I want it to calculate all rows
[Code]....
I have this SP. When I run this one my calculations is only the first row in OrderDetails. I want it to calculate all rows
[Code]....
in my application two time input will be passing to my sql stored procedures and I need to calculate the timespan between them. how can I do that? is there any way that I can do the following in t-sql?
[Code]....
I have two datetime2(1) fields in my db. I will calculate the time in hours and minutes between them. That I have done this way:
[Code]....
This works. But how can I calculate the avgerage speed if I have drived 665 kilometers in this time? I know how to do it with only houurs but not with the minutes to. I have tried this and I think it works. Is it correct?
[Code]....
I have events that have start and end dates and I want to display the current week that the event is in progress. To currently do this I am finding the week of the end date and subtracting the week of getdate(). This works unless the event goes into the next year and then it returns 0 .Here is my sql
course_status_1 = CASE
WHEN
GETDATE()[code].....
What I need to happen is for an event with start date and end date in differnet years to calculate what week of the event get date is currenty in.
Microsoft has two very helpful articles on DAL (Creating a Data Access Layer) &
BLL (Creating a Business Logic Layer) but they are Incomplete as the does not cover all the Tables.
The most Important tables in Northwind db are Orders & OrderDetails. Both the articles have nothing about them.
I have a problem with my first ASP.NET webpage. Im using ASP.NET 3.5 with VisualStudio 2008 and LINQ to SQL.
To easier communication we take a example from northwind data base. I want to list all the Orders and for each order I want to list all its OrderDetails. I have created a listview (lvOrders) with a LinqDataSource (Order table). Now I have create a new nested listview, for the order details, but I dont know how to load the orderdetails in this nested listview. I have tried to load the orderdetails in the OnItemDataBound of the first listview (lvOrders), but I miss functionatilly like DELETE command on the nested listview (to delete a orderdetail) This is my code:
[Code]....
On code behind:
[Code]....
Im thinking on some like a unique linqdatasource, returning a new Order entity (modified) with one field that is a list of orderdetails... this would work?
I am using a gridview on an OrderList page to present data from a database. Paging is enabled on the gridview.
Each row provides a link to an OrderDetails page which is used to display/edit data for the selected order.
I want to be able to return from OrderDetails page to the OrderList page and to set the gridview pageindex.
What is the best way to do this?
Can I have multiple paramaters with NavigateURL (i.e. the orderid and the pageindex)?
I am simply trying to determine age from a selection of Month, Day and Year representing birthdate, which I have captured from three drop down list boxes, by subtracting the studnetBirthDate from Today. How can I get Age? Using a calendar to select birth date seemed too clumsy because of the year navigation, age ranges from 3 to 26 yrs old. If anyone has a better idea I would be open to that as well. Instead I am using three dropdown boxes, one each for day, month and year.
Dim studentBirthDate
As
Date
Dim stMonth
As
String.........
Assuming I have a .css file with the following linebody { background-image: url('../images/bg.png') }My build process does some CSS magic and eventuall move this file from
~/Content/styles/styles.css
To
~/temp/styles.css
This invalidates the url statement in the file and needs re-written to ../Content/images/bg.pngThis is my question - given the original file location, the new file location and the background-image url in the file is there a reusable way calculate a new relative path for the image?In case someone doesn't know css urls should be relative to the css file it is contained within.
I was reading this article about relative time calculationThe problem is that the results are wrong due to the time offset. My webpage is Greek.So how should i modify that function to work correctly, including the GMT+2 or GMT+3 hours offset?
View 2 RepliesI have a dropdownlist having values 'today','yesterday',lastweek', 'last month', 'lastyear'.
when the user select any value from this dropdown, i want to show the from date and to date in two text boxes.
e.g. if the user selects last week, 'to date' should be today's date and 'from date' should be (today's date - 7). if current date is 12, 'from date' = 6 and 'to date' = 12
How do I do this?
I have a datatable as below:
Type Amount
A 1
A 2
B 3
C 5
B 1
How do I calculate and group the data to become the following datatable?
Type Amount
A 3
B 4
C 5
want to calculate age from data of birth in following following format.27 Year 03 Months 05 Days
View 3 Repliesi have a button and in click event i want to take the SUM() of a one cloumn and assign it into a integer and if that integer is > 20 display "pass" or something
i've tried many ways but non worked.
I need to calculate figures in a text file. There is a column which is number based in the file. I have two listboxes. I have the add/remove function on them. When I want to add one item to the right list box, I want it to start to add up in a 'label'. The label will calulate the figures once they are moved into the right hand listbox.
I'm nearly completed my project, but I'm struggling with a few minor points.
I need to calculate the number of free spaces between two characters.Consider the following Example
tring str = "This is the sample" ;
I need to calculate the spaces between "This" and "is"
als find the spaces between "is" and "the" How to find it?
Given a font size of 8pt, PaddingTop & PaddingBottom of 2pt each. Allow height increase is off.When the border is not drawn, to prevent clipping would I need a TextBox 12pt high? If a top or bottom border is drawn does that add to the height? Are there other things that need to be accounted for?
View 2 RepliesI have one problem.. I have two TextBoxs. 1 textbox for CalenderExtender and other textbox for displaying age from calenderextender. I display the from calenderextender but when i click a button(clientside code for navigation tabpanels in tabcontainer) it will be 0.Â
View 1 RepliesTo learn ASP.NET MVC, I am thinking of creating a community forum like SO where people can rate posts, users etc. and the user can thereby gain points. I just can't figure out if the points should be added to the user profile whenever an action is done (post rated up/down, user created new post etc.) or if it should be calculated from the different activities the user has done.
I have a few pro's and con's for both ways of doing it:
[code]....
I have a gridview where I placed several item templates with text boxes in them. I want to enter a number in the text boxes and have the total displayed in the footer.
The last footer template is where I want to display the total. I've placed a label there.
Here's my Gridview
[Code]....
I want to calculate total in a gridview and i want to show it in gridview footer below is my code
[Code]....
the problem is when i debug the code im getting null value into the textbox,i dont know why?my price comes from db and i enter quantity into the tetxbox any help on this problem??
[Code]....
I want to calculate the service tax on some amount. The value of service tax must be taken from textbox1.text and amount from textbox2.text and then after calculating it must be store in another textbox say,textbox3.text
service tax = textbox1.text - 14.5%amount = textbox2.text - 44000total amount= textbox3.text -((14.5*44000)/100 )+ 44000 ;
The Value of ((14.5*44000)/100 )+ 44000 after calculating will be store in textbox3.text
I have a gridview, which has bound field as "Birth Date", which is coming from the database. I want to show another field in the gridview as "Age", which should calculate age, Which should be Birth date - system date.
[Code]....
How to Calculate the age display the age in gridview columns.
I want to calcultae how many employees are scheduled less 24 hrs for each week,b/w 24 and 48 and greater than 48
In excel file i have weekly wise total hours scheduled for each employee and total no of days scheduled in week(example 6 days and 1 off)which i will upload it to database,based on this i want to display reports in bound controls Result should be like this
Scheduled Hrs 8/1/2010
8/8/2010 8/15/2010 8/22/2010
Less than 24 hrs 5% 5% 5% 5%
Between 24 and 48 hrs 5% 6* 3% 4%
greater tan 48 hrs 90% 89% 92% 91%
can u tell me Which control to use and words in bold are headers and dates should be dyanamic this month it is like shown above, next week it will change.so header should be dynamic.
I want to calculate total inside a gridview and i want to display in footer row below is my code
[Code]....
But i am unable to get the quantity in the textbox when i enter a quantity it is showing null into the tetxbox and i have different prices for the items when ever i enter quantity for a price i am getting only the starting price of the item.Another problem is when i click button once the page is getting posted back when i click second time the event is getting fired i dont know why?