SQL Server :: Cannot Reference Column Names To Calculate Percentage

Feb 15, 2011

I have the following SQL:

SELECT SRFILE_1.SRCONMAE, COUNT(LBWF_1.Incidentx) AS SLAFailed,
(SELECT COUNT(Incidentx) AS Expr3
FROM LBWF AS LBWF_2) AS TotalCalls
FROM SRFILE AS SRFILE_1 INNER JOIN
LBWFAS LBWF_1 ON LBWF_1.Incidentx = SRFILE_1.SRONUMBER
WHERE (LBWF_1.KPIFailx = '1') OR
(LBWF_1.Chargex > '0.00') OR
(LBWF_1.LChargex > '0.00')
GROUP BY SRFILE_1.SRCONMAE

What I'm trying to do is divide TotalCalls by SlaFailed and * by 100 into a new variable such as Percentage. However, everytime I try to select SLAFailed or TotalCalls I receive a 'Column Names do not exist' message.

Is there any way I can reference said values?

View 5 Replies


Similar Messages:

SQL Server :: Sorting On Column Take More Percentage In Execution Plan

Dec 28, 2010

when I use 'RowNumber' = ROW_NUMBER() OVER(ORDER BY ColumnName) then due to orderby Column name consume 76% usage in execution plan . in such case what I have to do? I can see sorting taking much time in execution plan.

View 9 Replies

How To Calculate The Percentage Of Scheduled Hours

Aug 30, 2010

I have weekly wise scheduled hours of each employee and no of days scheduled for each employee,now i need to calculate no of employees scheduled less than 24 hours,no of emp's scheduled b/w 24 and 48 hrs and emp's scheduled more than 48 hrs in percentage for fisrt week,second week,3rd week and 4th week.

Like this

SCheduled Hrs 8/1/2010 8/8/2010 8/15/2010 8/22/2010

Less tha 24 hrs 5% 5% 5% 5%

b/w 24 and 48 hrs 4% 5% 5% 5%

>48 91% 90% 90% 90%

View 5 Replies

DataSource Controls :: Calculate Percentage From Table?

Jun 22, 2010

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?

ID
ContestantID
SchedularID
PublicVotes
JudgesVotes
1
4
2
4
NULL
2
2
1
1
NULL
3
3
2
2
NULL

View 10 Replies

Web Forms :: Calculate Exact Number For Given Percentage In C#

Jan 30, 2013

I need to deduct the amount for the given percentage but i am having small difference in the calculatiion

I do the following

  int input = 6065;

  int result = input * 60/100;

The result i got is 3657.  But the actual result is 3657.6 and i need to round up so i need to get

3658.

View 1 Replies

Web Forms :: In Crystal Report How To Calculate Total Marks Percentage

Apr 27, 2016

As i am trying to do crystal report task as it is aim is to calculate the Sum Of Subjects Marks And calculate the percentage ....I am not able to calculate the percentage.

View 1 Replies

SQL Server :: Converting Dates To Strings For Column Names?

Jan 13, 2011

I am working on a query to pull the revenue for the last 7 days, as individual days, to be used in a bar graph. My query does what I want it to:

[Code]....

My question is: How do I change the Date1, Date2, Date3, etc to display the actual date it is pulling from? So instead of Date1, it will say "Jan. 3 2011" and so on...

View 2 Replies

SQL Server :: Using String Variables As Column Names In A Select Statement?

Dec 20, 2010

I'm trying to use a function in my code behind to let me select a different column each time by calling the function with a different parameter.

However, I keep being told 'invalid column name', even though in the error page the column name appears perfectly valid.

Private Function getData(ByVal s As String) As String

View 4 Replies

SQL Server :: How To Calculate A Column Data For Different Conditions Using Single Query

Jan 12, 2011

I am using below query to count a particular column data based on single condition.

[code].....

But I have to calculate for 3 more conditions. Is it possible to count based on 3 conditions(i.e. 2001 - 3000,3001 - 4000, 4001 - 5000,>5000) and I want result set for all the conditions?

View 8 Replies

Forms Data Controls :: Validate Column Where Sum < 100 Percentage?

Jan 8, 2011

I have a gridview in which I have a column for Percentage and I enable footer to display the totol of that columnI have in my grid Edit and Delete template column...I need to validate when user click Edit if he inserts a value inside the textbox of a row in the column Percentagenot to exceed the 100 % ..the sum of all rows should be 100 % but i need to validate by a message to ask user :please insert another value cause sum is exceding 100 % then he can clicks on updateI want to validate the data where sum of values of all rows of "Percentage Column" should not exceed 100. If it exceeds more than 100, a pop up window needs to be shown saying "value exceeds 100, Re-enter" and . All of this validation should happen with out a postback.

View 1 Replies

Getting The Column Names When Using E.oldvalues

May 28, 2010

How do I get the column names when using e.oldvalues?

[Code]....

View 9 Replies

SQL Server :: Percentage Of Matching Days Off Among Employee's?

Sep 2, 2010

i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday).I want result in percentage.result like this

Consistency Days of assignment Across 4 weeks 3 weeks 2weeks
0 2% 0% 0%
1 98% 100% 100%
2 0% 0% 0%

Here 0,1,2 are macthing days off.Across 98% of employees getting 1 days matching in off i.e 98% of employee might off in sunday.For this we need calculate matching days off for all the days from sunday to saturday across 4,3 2 weeks Here 98% of employees getting off in same day.0 indicates 0 days,1 is 1days and 2 is 2 days(for example 50 percentage of people will get off in saturday and sunday)

View 27 Replies

ADO.NET ::calculate A New Column IN In Linq?

Aug 12, 2010

I would like to select some data from multiple tables and calculate a new column IN the query.In SQL it would look like: (select A, B, ((C * D) + (C * E)) as 'calc' from tab1 join tab2 on.join tab3 on.join tab4 on ...);I've tried this in linq, but it didn't work as I believe.

[Code]...

View 3 Replies

ADO.NET :: How To Get Column Names From Linq Datasource

Jan 14, 2011

how to get column names from linq datasource?

[Code]....

View 7 Replies

SelectCommand Dynamic Column Names?

Feb 8, 2011

I have a database with two columns: Retailers or Traders. A row can have only one of them with values while the other must be 'Null'. Both are nvarchars kinds. What I am trying to do is to show data if a radio button is selected for either Retailer or Trader. So I constructed a SelectCommand statement which is getting column names of either 'Retailers' or 'Traders' as a parameter but the SelectCommand statement still returns all records. What can I do?

<asp:SqlDataSource ID="dsSearchResults" runat="server" ConnectionString="<%$ ConnectionStrings:AdoFabricsConnection %>"
SelectCommand="SELECT Name,Address1,City,State,Zip, Telephone, Email_Address, TO_THE_Trade, Retailer,

[code]...

View 1 Replies

Crystal Reports :: Calculate SUM Of A Particular Column?

Feb 20, 2014

How to find sum of a particular column in crystal Report?

I have a column "Price" in Crystal Report. I want to calculate the sum of all the Prices and Show in Footer of Crystal Report.

View 1 Replies

ADO.NET :: DataTable Column Names Not Matching Case

Nov 4, 2010

I am getting a datatable from the SQL Server. In SQL Server the column headers are fine (mix of Capital and Small Letters). But when i am getting it in the front end, all the column names are in lower case. How can i get the column names in original Case.

View 3 Replies

C# - How To Change Column Names Randomly In Gridview

Jun 11, 2010

I am struggling to show different views of gridview with database values. Here is my requirement.

Database Table:

I need to show one drop downlist with three values 1,2,3. If user selects 3 i Need to show a grid like below

Age,AnnualSales and Assortment are names which are coming dynamically from database.

High,Medium and Core all are values

Here my question is I need to show same attribute names.

Like If the name changes from "Assortment" to "Location" I need to show it in different page index .

In page index 2 i need to show like below.

View 2 Replies

.net - Add Table Column Names Automatically In An ASP ListView?

Feb 17, 2010

I have an ASP ListView which I am using to display some pivoted information (across years) in a table. Currently I have the ListView templates defined as:

<LayoutTemplate>
<table id="listViewTable" class="tableData">
<tr class="rowHeader">

[code]...

View 2 Replies

Read Column Names Of An Excel Sheet?

Apr 26, 2010

im trying to read column names from excel .

View 3 Replies

Databases :: Play Around With Column's Names Filled By OleDbDataAdapter?

May 3, 2010

I tried to query an excel file which contains a lot of customers' information but my problem is most of those don't have a specific column names. E.g. it's in the following format. (Excel File)

A B C
Info1 blur blur
Info2 blur blur
Info3 blur blur

So, when I query using SqlDbDataAdapter, in my DataTable, info1 blur blur becomes column header. e.g. it's in the following format. (DataTable)

Info1 blur blur
Info2 blur blur
Info3 blur blur

I been working on it so that it actually goes down one row and Change the column name in the DataTable into some appropiate name. Something like the following format.

Name1 Name2 Name 3
Info1 blur blur
Info2 blur blur
Info3 blur blur

Is there any way that I could work around it rather than actually going back to change the excel files ? Because I have like 1,000 excel files in that kinda format and seriously giving me headache now.

View 5 Replies

.net - Dynamic Data - Make Friendly Column Names?

Jun 17, 2010

I've created a Dynamic Data project with an Entity Framework model. It works nicely. But, right now it shows all my database tables with the db column names - which aren't always the most friendly (e.g. address_line_1). How can I got about giving these more friendly column titles that will display to the end user?

View 2 Replies

C# - Get Column Names From Table Returned From Stored Procedure?

Feb 10, 2011

I have a stored procedure which returns a table. The stored proc is called via a linq datacontext.

It works fine and I get the table back however I really want to also get the title relating to each particular cell returned.

The stored procedure call is like:

var table = DataContext.GetTable().ToList();

So I get a List<GetTable>. The data is fine I just want the column names as well.

View 2 Replies

Web Forms :: Display Alphabets Above Each Datagrid Column Names?

Feb 14, 2011

I have a requirement to display alphabets above each datagrid column names (like shown in excel). The datagrid columns (and header text) are dynamically created at run time and the alphabets on top could grow like excel A, B, C,....Z, AA, AB, AC,.....AZ etc. Any suggestions on how to get the alphabets showing for each columns?

View 1 Replies

Data Controls :: Calculate Sum Of Each Column Of GridView Using JQuery

Jul 17, 2015

I just want to calculate the Grand Total of the quantity. So basically i want to sum up all the quantity for each row and show the total at the bottom of the page. I don't want to use the total and the price column in this example. How can i modify this code and just sum up only the total quantity without referencing the price and the total? here is the javascript

<script type="text/javascript">
$(function () {
$("[id*=txtQuantity]").val("0");
});
$("[id*=txtQuantity]").live("change", function () {
if (isNaN(parseInt($(this).val()))) {
$(this).val('0');
} else {

[Code] ..

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved