This works.. I can then colour my grid view cells accordingly using the substring function.. the problem is that I have been told that using GETDATE three times is not a good use of resources, is it possible to use the Datediff function to get the same result?
I have a table that contain the votes(publicVotes) against each contestant. Now what i am trying to do is to calculate the percentage of votes each contestant recieved according to the column SchedularID. how i can get it done and would it be easy to user store procedure or view?
I have a certain report I want to make where I want to calculate the slope of a dataset(turnover column) following the formula:
SumXY-MeanY*SumX / SumXX-MeanX*SumX
In order to do that the X-range has to be an integer from 1 to the last datarow. In my report I get this exact number with the rownumber(nothing) formula. But it seems I can't calculate with it in the expression for the slope because it gives errors:
I have a GridView that populates the days between the start and end date. What i want to ask is that is it possible to display a word "Overdue" (If possible "Overdue by 7 days") when the datediff is negative (eg: -7 days) The following are parts my codes for now:
<asp:TemplateField HeaderText="Date Raised" SortExpression="DateRaised"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("DateRaised","{0:d}") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Expected Close Date" SortExpression="DateClose"> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Bind("DateClose","{0:d}") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="DaysTaken" HeaderText="Allocated Days" /> <asp:BoundField DataField="RemainingDays" HeaderText="Remaining Days" /> <asp:SqlDataSource ID="SqlDS_UnresolvedIssues" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString_PITLog %>" SelectCommand="SELECT [IssueLog].[DateRaised], [IssueLog].[DateClose], DATEDIFF(dd,DateRaised,DateClose) AS DaysTaken, DATEDIFF(dd, GETDATE() ,DateClose) AS RemainingDays FROM [IssueLog] INNER JOIN [ActDetails] ON [IssueLog].[ActID]=[ActDetails].[ActID] WHERE [ActDetails].[ProjID]=@ProjID AND [ActDetails].[DevPhase]=@DevPhase AND NOT [IssueLog].[IssueStatus]=@IssueStatus"> <SelectParameters> <asp:ControlParameter ControlID="DD_PMProjID" Name="ProjID" /> <asp:ControlParameter ControlID="DD_DevPhase" Name="DevPhase" /> <asp:Parameter DefaultValue="COMP" Name="IssueStatus" /> </SelectParameters> </asp:SqlDataSource>
By the way, I am using Web Developer 2008, VB.net.
I have problem like to count the repeated chars from a string using sql server.Also i have used functions in sql server thats working fine.But i want the solution using a sql query...
[i have a column like ID,name,Secure_name],here 1 ,'kamal','welcome'.so findout 'e' howmany times repeated in a column secure_name.....
I need financial year in system date.actually i calculate financial year like below in VB code. [Code].... i just like the same in sql server query.for example suppose my query like"select*from admission where std_code=1 and fnyr in (select finy in system date)"<---i need here.
We have a demand system where customer can demand the quantity they want for a particular deal.
For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity
I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.
However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?
my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it
I am trying to calculate the total amount of shopping cart by multiplying the quantity with the product price and then sum up the sub results.I am doing this but it does not make the multiplication.
[Code]....
decimal? TotalAmount = (from shopCart in dc.KP_ShoppingCarts
I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.
Suppose we have a website with 10,000 viewers each second. And we want to insert the viewer's information to the SQL database. So we must insert 10,000 records to the SQL each second. And it may take long time to do.
CREATE PROC [dbo].[SP_NEWS_SELECT] ( @NB_NEWS int, @ID_NEWS int, @DT_PUBLICATION datetime ) AS SELECT TOP @NB_NEWS * FROM [REP_CLI].[S_ETATS].[T_NEWS] ORDER BY [DT_PUBLICATION] ASC
im learning t-sql, infact i needed its while-loop to loop through records of a table, i found this code in some book:
[Code]....
i understand here that setting the rowcount variable to 1 will force the select statements to return only one record, do all above select statements return one record only?
if the underlined select statement returns one record everytime it is executed, isn't it supposed to return the same first record of the table everytime? is there a better way to loop through a table's records?
I am developing web applications using csharp. How can I ensure that some records are not picked using sql. I have a table with records and its content differ from each other dot ".". Table is as follows
Student1 Details2 Details2
1 Musol School Books 2 Musol School Books. 3 Golpp Temo Books 4 Golpp Temo Books.
How can I select records without dot "."at the end only. For example
1 Musol School Books 3 Golpp Temo Books
I have used sql but I am not getting it. My sql is as follows
I'm trying to query records from a db using a date. But somehow the db doesn't return records.
The datetime collums have the data stored in this format in the db as datetime :
12-Apr-10 12:45:12 AM The string a have available is in this format : 12-Apr-10
I need to somehow strip the time part of so i can use my date string in the query.
When i use the below method the database converts the datetime to a rounded date (12-Apr-10 12:00:00 AM). But when i query for that date i still get no results.
I tried this:
SELECT ID, PerformedBy, SystemId, ServerId, CAST(FLOOR(CAST(CreateDateTime AS FLOAT)) AS DATETIME) AS Expr1, Reason, Action, Summary, EnteredBy, Collumn1, Collumn2 FROM Changes WHERE ('Expr1 = '12-Apr-10 12:00:00 AM')
What is the best method in T-SQL 2008 for extending a table's records with the criteria of 'repeating' all fields but the Primary KEY e.g. Consecutive Date for the previous n Records.
So you have for example 7 records (Easy...2 Fields. Date and nvarchar) with th Date runing from Jan-01 to Jan-07
We want to extend the table by 21 records...so
Record 1,8,15,22 will look identical apart from the DateField.
Record 2,9,16,23 will look identical apart from the DateField. etc...etc..
I have tried a number of methods ...all coming up short....
