SQL Server :: Convert Result To Positive If Negative?
Oct 25, 2010
i have a select statement below. The result of r1- @r1 may be positive or negative.
i want it to always result as positive, so it is a negative number then it to show the same number as positive. can i do this?
e.g.
r1 = 7, @r1 = 4
r1 - @r1 = 3
but
if r1 = 5, @r1 = 6
r1 = @r1 = -1, but i want this to be 1, because i am trying to work out the difference between the two numbers.
can this be done within a select statement? my select statement is:
SELECT imageurl, (r1 - @r1) AS difference
View 1 Replies
Similar Messages:
May 7, 2015
I want to put validation in a Textbox, that the numbers entered inside textbox should be between 1 to -1 only i.e., (-1, -0.1, -0.2, -0.3, -0.4, -0.5, -0.6, -0.7 ....... 1 )I tried below code but "RangeValidator" is not working as per requirement:
HTML:
<asp:RangeValidator ID="RangeValidator1" runat="server" MaximumValue="1" MinimumValue="-1" Text="value between 1 to -1" ErrorMessage="value between 1 to -1" ControlToValidate="TxtY" ValidationGroup="usrvalid"></asp:RangeValidator>
<asp:TextBox ID="TxtY" Text='<%#Eval("Y") %>' runat="server" Width="30%"></asp:TextBox>
<cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender5" TargetControlID="TxtY" FilterType="Custom" ValidChars="-01234567890." runat="server"></cc1:FilteredTextBoxExtender>
How to achieve it.
View 1 Replies
Jan 24, 2016
How to convert negative value (-) to 0 using C# and VB.Net? Below is my sample query:
dim finaltotalbonus as doubledim Sumtotalbonus as doubledim totaldeductamount as double
finaltotalbonus = Math.Round(Sumtotalbonus - totaldeductamount)FinalTotal = finaltotalbonus
sample data :
finaltotalbonus = Math.Round(200 - 500)FinalTotal = -300
How to make system show FinalTotal = 0 for negative value (-)?
View 1 Replies
Sep 8, 2010
Is there another currency format string besides "C"? "C" seems to convert negative amounts like you'd see on a bank statement (e.g. $-10.67 shows up as ($10.67)). The guy here at work doesn't like to see .00 at the end of money so in a gridview I wrote for him I was just dropped the last three characters after I converted the values to .ToString("C"), but one negative value in the bunch breaks that logic.
View 7 Replies
Jan 21, 2010
I have encountered a problem about "order by" sorting in SQL. As some of the items (strings) in a dropdown list contain negative sign on the left, it is surprising for me that the SQL server cannot sort the items in an alphabetical order and as a result I was forced to set the property value (IsSort = False) of the Ajax ListSearch, which slow down the searching speed a lot. Below are examples of two of the string items with a negative sign on the left.
View 6 Replies
May 6, 2010
I have a MVC project that has a Linq to SQL dbml class. It is a table called Clients that houses client information. I can easily get the information to display in a View using the code I followed in Nerd Dinner but I have added a stored procedure to the dbml and it's result set is of IQueryable, not IQueryable. I need to convert IQueryable to IQueryable so I can display it in the same View. The reason for the sproc is so I can pass a search string tothe sproc and return the same information as a full list but filtered on the search. I know I can use Linq to filter the whole list but I don't want the whole list so I am using the sproc.
Here is the code in my ClientRepository with a comment where I need to convert. What code goes in the commented spot.
public IQueryable<Client> SelectClientsBySearch(String search)
{
IQueryable<SelectClientsBySearchResult> spClientList = (from p in db.SelectClientsBySearch(search) select p).AsQueryable();
//what is the code to convert IQueryable<SelectClientsBySearchResult> to IQueryable<Client>
return clientList;
}
View 1 Replies
Aug 22, 2010
I've been trying to insert new values while I create a new user with a createuserwizard, but I've been getting this error over and over again:
"insufficient result space to convert uniqueidentifier value to char"
The code that does it is the following:
[Code]....
But when I debug, the error is thrown before reaching the previous code, so I suppose the error is in the SqlDataSource, look:
<asp:SqlDataSource ID="InsertExtraInfo" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>"
InsertCommand="INSERT INTO [User_Personal] ([UserId], [Gender], [ToGender], [StateName], [CityName],
[code]...
View 1 Replies
Aug 9, 2010
Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 Replies
Jul 1, 2010
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
View 3 Replies
Mar 1, 2011
I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
How can I get the query to return a simple
string[] = { "item100", "item400", "item500" }
View 4 Replies
Dec 3, 2010
I am looking for an example where I create CTE, and then using the result of first CTE, I create another CTE.With CTE1 as ( Col1, Col2, Col3)
(
--SOME RECURSIVE QUERIES
)
select Col1, Col2, Col3 from CTE1 where Col3 >100I want to now use the above query inside a recursive CTE2. One way is to store the above result in a temp table and use the temp table in a new CTE but I am NOT looking for temp table solution here. May be wrap the above result in another CTE, but I am missing the syntax.
View 5 Replies
Dec 27, 2010
I have the following request:
[Code]....
its result is:
ProductSUM
1355
310
210
220
150
95
60
235
90
545
How to SUM these values?
View 5 Replies
Nov 4, 2010
There is a certain query that is being called from an ASP .NET page. I studied the execution plan of that query in Management Studio and 87% is for a sort. I badly need the sorting or else the data displayed would be meaningless.
Is there anyway that I can request SQL Server to cache a sorted results set so it will return the data faster in consequent runs?
Or is SQL Server smart enough to do the cache handling and am I doing mistake by trying to force it to cache results, if that is possible?
UPDATE:
I just read in an article that creating a View with a clustered index will increase performance because the index will persist the data in a view to disk. Is this true? How do i get about doing this?
View 5 Replies
Aug 18, 2010
I retrieve data from databse
col1 col2 col3
0 0 1,000
1 0 0
0 1 5
0 -1,200 0
0 0 0
0 0 0
and now I want to sum each for total
[code]....
I will get error when dr["col2"].ToString() = -1,200
col2 += Int32.Parse(dr["col2"].ToString().Replace(",",""),NumberStyles.AllowDecimalPoint);
does the problem is the negative sign?
how to sum for negative number?
View 9 Replies
Jan 5, 2011
I need to bring the distinct result in third columnBelow one is my sample table
[Code]....
View 19 Replies
Aug 4, 2010
I am using datetime.now in vb.net to retrieve the current time and date. I passed this parameter into this dim strDate as datetime
strDate = datetime.now
I then saved this strDate into database. However, when I want to retrieve the following date with example, say 2/8/2010 3:58:58 PM
SELECT * FROM CUST WHERE DATE = '2/8/2010 3:58:58 PM'
the result is 0. So i went to SELECT * FROM CUST and realized that the date in the Date column is this:
2010-08-04 15:58:20.000
I have retrieve today's date and saved into database, by right the format should be the same.. May I know what has happened?
View 8 Replies
Feb 7, 2011
I have table with 'usercard' name , and a related tables :
- Computer
- Laptop
- Fax
- UPS
Now , Every Employee has one or more than one from these devices , When I used INNER JOIN in my select query , I didn't get what I need
the result show a one user in 4 rows,(user have all devices)
View 13 Replies
Nov 3, 2010
this script work with join and sum
and works good,but i want to make total sum of the result of this query for all rows of sum column
[Code]....
View 4 Replies
Mar 12, 2010
I am doing a md5 hash, and just want to make sure the result of:
md5.ComputeHash(bytePassword);
Is consistent regardless of the server?
e.g. windows 2003/2008 and 32/64 bit etc.
View 4 Replies
Oct 7, 2010
i am wishing to store the query result in any variable, have look at below code.
[Code]....
I have marked the code with bold, where I am getting error.
how do I store query result in any variable.
View 8 Replies
Feb 11, 2011
I got the following table:
Lane Bin1 Bin2 Bin3
1 B11 B21 B31
2 B21 B22 B23
3 B31 B32 B33
How can i change the layout to
Bin1(Lane1) Bin1(Lane2) Bin1(Lane3) Bin2(Lane1) Bin2(Lane2) Bin2(Lane3) Bin3(Lane1) Bin3(Lane2) Bin3(Lane3)
B11 B21 B31 B21 B22 B23 B31 B32 B33
I tried using pivot, but cant get it.
View 11 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
Feb 7, 2011
i need to export a query result to a .txt file , how can i do it ?
View 4 Replies
Oct 19, 2010
I have the following issue where I cannot seem to display a negative number and the result seems to stay on zero.
The code is as follows:
[code]...
In my code iNumber1 = 108 and iNumber2=27 however when the result is divided again by 108 the answer seems to stay on 108. I tried using doubles but with no luck.
View 3 Replies
Jul 26, 2010
I have a problem in my spilt function. When I pass the parameter, the data is getting splitted by given second parameter and it will return the result as table format. The resultant data is getting truncated. I have to create the dynamic update statement by using this table. Below I have shown the function and parameter.
View 2 Replies
