SQL Query Error In Defining Alias For Column

Sep 4, 2010

My following sql query giving me the following error, What does it mean. Am i defining the alias fir column in wring way. Please help me out with this. My error is this and i am putting query just below the error. Error in SELECT clause: expression near 'Year'. Missing FROM clause. Unable to parse query text.

SELECT [tbl_students].passing_year as Passing Year,[tbl_branch].branch_name as Branch_Name FROM [tbl_students], [tbl_course], [tbl_branch] WHERE [tbl_students].course_id=@courseId
AND [tbl_students].branch_id IN(64)
AND [tbl_students].course_id=[tbl_course].course_id AND [tbl_students].branch_id=[tbl_branch].branch_id
AND (@firstYrPercent is null OR [tbl_students].first_year_percent>=@firstYrPercent)
AND (@secondYrpercent is null OR [tbl_students].second_year_percent>=@secondYrPercent)
AND (@thirdYrPercent is null OR[tbl_students].third_year_percent>=@thirdYrPercent)
AND (@finalYearpercent is null OR [tbl_students].final_year_percent>=@finalYearpercent)
AND (@currentDegeePercentage is null OR [tbl_students].current_degree_percent>=@currentDegeePercentage)
AND (@passoutYear is null OR [tbl_students].passing_year>=@passoutYear)
AND (@currentBacklog is null OR [tbl_students].current_backlog=@currentBacklog)
AND (@sex is null OR [tbl_students].gender=@sex)
AND (@eGap is null OR [tbl_students].gapin_education<=@eGap)
AND (@highSchoolPercentge is null OR [tbl_students].highschool_percentage>=@highSchoolPercentge)
AND (@higherSchoolPercentage is null OR [tbl_students].ssc_percentage>=@higherSchoolPercentage)
AND (@grauationPercentage is null OR [tbl_students].graduation_percentage>=@grauationPercentage)
AND (@diplomaPercentage is null OR [tbl_students].diploma_percentage>=@diplomaPercentage)
AND (@noOfAtkt is null OR [tbl_students].number_of_ATKT<=@noOfAtkt)
AND (@validDate is null OR [tbl_students].DOB>=@validDate)

View 1 Replies


Similar Messages:

DataSource Controls :: Include An Alias In Select Query?

Jun 22, 2010

I have an application that I am developing using ASP.Net with visual basic code. I have a table called "Customers" that contains 3 fields. The name of each field is "Name", "LocationA", and "LocationB". I want to code a select query that list two columns. The first column should contain the field "Name". I want the second column to contain the value in the field "LocationB" if "LocationB" is not null, else I want the second column to contain the value in the field "LocationA".

View 4 Replies

Web Forms :: Entity Framework With Stored Procedure Using Defining Query

Jun 28, 2012

I wrote a defining query

 <EntitySet Name="EntityFramework" EntityType="SEOAnalysisModel.Store.EntityFramework">
<DefiningQuery>
SELECT Keyword, ResultHead ,Year from SeoAnalysis where Year = 2005

[Code].....

And this column value is repetative.

Now how can i get all column value?

View 1 Replies

AJAX :: Got An Error On A Page Defining A Web Service

Feb 26, 2010

I recently upgraded from VS2005 to VS2008. I did a full install of VS2008, then opened my existing project in it. This launched the conversion wizard which successfully converted my VS2005 project to VS2008 and it opened in VS2008 owever, when I first tried to build the solution in VS2008, I got an error on a page defining a web service saying

View 6 Replies

DataSource Controls :: Select Query Not Working / Getting An Invalid Column Name Error?

Jul 9, 2010

i have the following select staement which deosnt work, can anyone advise me whats wrong with it:

string _name = ddl_Name.SelectedValue.ToString();
string cmd =
"SELECT ID, Telephone FROM User_List WHERE Name = '' + _name;

i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?

View 3 Replies

SQL Server :: Using Alias Right In Select Statement?

Feb 24, 2011

here is a sql select statement,

Select
ColA = ID
,ColB = Name
,ColC = invtotamt + (SELECT SUM(TableA.camount) FROM TableA WHERE TableA.csucceed = 1 AND TableA.cID = InventoryTotal.invID GROUP BY TableA.cID)
,ColD = ((SELECT SUM(TableA.camount) FROM TableA WHERE TableA.csucceed = 1 AND TableA.cID = InventoryTotal.invID GROUP BY TableA.cID)
,ColE = (SELECT SUM(TableB.camount) FROM TableB WHERE TableB.csucceed = 1 AND TableB.cID = InventoryTotal.invID GROUP BY TableB.cID)
FROM TABLE

it look complicated, and long statement, actually it's easy, it is like: (it's a sample, not a really one)

Select
ColA = ID
,ColB = Name
,ColC = ColD + ColE
,ColD = ColE + ColC
,ColE = ColC + ColD/100
FROM TABLE

it looks much easier with ALIAS. But, it seems i cannot directly use alias in select stetement like that.
if i cannot use alise, i have to copy paste lots of same column definition. how can i use the alias in select statement?? this bothers me a lots of times!

View 5 Replies

SQL Server :: Stuck On Update Query / Identify That The First Letter In A Column In T1 Corresponds To One Letter In The Middle Of A String In A Column In T2 For Instance?

Nov 30, 2010

Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2).

My constraints are:

That I have to match the first 4 letters of a column in T2 to one column in T1 I have to identify that the first letter in a column in T1 corresponds to one letter in the middle of a string in a column in T2 For instance:

My Table (T1):

Order Type Combined
Place
0090 0001 YYXX 1YY
0091 1001 YYXX YYY
0092 1002 XXXX 2XX

Table 2 (T2):

Order Value
00900001YY XX
00911001YY XX
00921002XX XX

The Combined column in T1 is what i'm trying to complete. The T1.Place column contains the first character that I want to check for.

If it's a "1" then I want to make sure the 5th letter in T2.Order is a "0" If its a "Y" then I want to look for a "1001" If its a "2" then I want to make sure the 8th letter is a "2" in T2.Order
If all that matches then I was the last two letters in T2.Order + T2.Value to be combined and put into the appropiate spot in T1.Combined

Here's what I have:

[Code]....

I know it's a little complex, but i'm really stuck on it and any help would be greatly appreciated.

View 12 Replies

JQuery :: Selectors - Create A Sort Of Alias For Variable?

Feb 4, 2011

In my jquery functions, I have many references like this: $("[id$=DDL_DOB_Day]"). I use this format as it works with master pages. The question I have is can i create a sort of alias for this variable so my code is not full of longwinded names? For instance:

dd = $("[id$=DDL_DOB_Day]");
if(dd == 1)

View 5 Replies

Databases :: Fetch The Data From A Table With Alias Name In Oracle?

Aug 11, 2010

I need to fetch the data from a table with Alias name in oracle.

example: select f1 'Field Name1',f2 'Field Name2' from sometablename;

View 2 Replies

ADO.NET :: Getting The Error As "Cannot Set Column 'column Name' To Be Null

Jan 15, 2011

I am using VS 2010, C# and Sql server 2008. I am having a list returned from the database. I am trying to convert the

list to a dataset.

I am getting the error as "Cannot set column 'column name' to be null. use DBNull instead.

This is the code i have used:

[Code]....

How to fix this?

View 1 Replies

Databases :: Run Query In SQL Error / Error In SELECT Clause: Expression Near ')'?

Dec 7, 2010

I am not able to understand what is the problem with My sql ..as same query is run sucessfully while i use SQL Server 2005 whit out any Exception or error.........

Select Count( Date ) From Attendancemaster
Error in SELECT clause: expression near ')'.
Unable to parse query text.

this is very simple query run sucessfully in SQL Server 2005 but not in

MY SQL and giving Error..and the query on which any datetime avar comes in WHERE clause allso generate error always....?

View 2 Replies

ADO.NET :: Linq - Order By Column That Contains Query?

Aug 19, 2010

I got a sql table and is trying to sort the data by the column that contains the data entered in a search form.

My code is below:

[Code]....

View 2 Replies

Databases :: Update Multiple Column Using Sub Query?

Apr 1, 2011

I want to update multiple column of a table using subquery ...My sample code is shown below

[Code]....

its throwing syntax error...I dont know where i commiting mistake.

View 1 Replies

DataSource Controls :: Adjusting Column Through Sql Query

May 27, 2010

I am looking to display the value of a column and divite it by 1.175and display only the result do you know how to adjust the value of a column through a select statement in SQL?

View 7 Replies

DataSource Controls :: SQL Query With Complex Column?

Jun 14, 2010

I have following tables.

Items
ItemId
ItemName
GroupId
CatId
1
Apple
5
6
2
Banana
5
6
3
Blackberry
5
6
4
Grapes
5
6
5
Guavas
5
6
6
Beans fresh
5
7
7
Bitter Gourd
5
7
8................

View 7 Replies

SQL Server :: Query Solution One Column Convert Into Two?

Mar 2, 2011

i have a salary table that have data like this ID EmpNo mYear Net Salary 29 3 January 2010 29217 1210 3 February 2010 29217 2052 3 March 2010 29217 3102 3 April 2010 29447 4153 3 May 2010 29447 6376 3 July 2010 28803 7231 3 August 2010 28281 7893 3 September 2010 29303 5207 3 June 2010 29197 8874 3 October 2010 29303 10076 3 November 2010 31276 11318 3 December 2010 31216 12503 3 January 2011 31266 13880 3 February 2011 31266 13414 1613 January 2011 19445 12043 1613 December 2010 19445 10563 1613 November 2010 19445 9364 1613 October 2010 18150 6163 1613 June 2010 10075 8433 1613 September 2010 18150 5154 1613 May 2010 18806 But i want to create a view like this ID EmpNo ThisMonth Previous Month mYear ThisNetSalary PreviousNetSalary Net Salary 29 3 January 2010 December 2009 January 2010 29217 0 29217 1210 3 February 2010 January 2010 February 2010 29217 29217 29217 2052 3 March 2010 February 2010 March 2010 29217 29217 29217 3102 3 April 2010 March 2010 April 2010 29447 29217 29447 4153 3 May 2010 April 2010 May 2010 29447 29447 29447 5207 3 June 2010 May 2010 June 2010 29197 29447 29197 6376 3 July 2010 June 2010 July 2010 28803 29197 28803 7231 3 August 2010 July 2010 August 2010 28281 28803 28281 7893 3 September 2010 August 2010 September 2010 29303 28281 29303 8874 3 October 2010 September 2010 October 2010 29303 29303 29303 10076 3 November 2010 October 2010 November 2010 31276 29303 31276 11318 3 December 2010 November 2010 December 2010 31216 31276 31216 12503 3 January 2011 December 2010 January 2011 31266 31216 31266 13880 3 February 2011 January 2011 February 2011 31266 31266 31266 13881 3 March 2011 February 2011 March 2011 0 31266 0 5154 1613 May 2010 April 2010 May 2010 18806 0 18806 6163 1613 June 2010 May 2010 June 2010 10075 18806 10075 8433 1613 September 2010 August 2010 September 2010 18150 10075 18150 9364 1613 October 2010 September 2010 October 2010 18150 18150 18150 10563 1613 November 2010 October 2010 November 2010 19445 18150 19445 12043 1613 December 2010 November 2010 December 2010 19445 19445 19445 13414 1613 January 2011 December 2010 January 2011 19445 19445 19445 13415 1613 February 2011 January 2011 February 2011 0 19445 0.

View 4 Replies

SQL Server :: Dynamically Add Column Name In Query For Search?

Sep 25, 2010

i want to add add coulmn name in sql query at run time and if any field is blank or null than it should not goes with sql query for search ....

column name:

firstName.Text
lastName.Text
address.Text
SqlCommand cmd = new SqlCommand("select * from hotelreg where '" + firstName.Text + "' and '" + lastName.Text + "', and '" + address.Text + "' like '%"+textbox1.Text+"%'", con);

View 1 Replies

Access :: "Operation Must Use An Updateable Query" Error With Sql Query?

Apr 4, 2010

I executed the following sql command, and got error "Operation must use an updateable query.".

[Code]....

The database is access 2003. The tables are T1 (code (key), n) and T2 (code(key),num). Why do I get this error and how do I solve it? EDIT: Found solution somewhere else.

View 3 Replies

.net - Trouble Defining Bindings Using Ninject?

Mar 28, 2011

having trouble defining bindings using ninject.I am in a standard ASP.NET WebForms application. I have defined an http handler to Inject dependencies in pages and controls (Property injection).Here is what I am trying to do:I am creating a custom combobox usercontrol. Based on the value of an enum on that combobox, I want to be able to Inject a different object in a property (What I am trying to do is a bit more involved than that, but answer to this should be enough to get me going).

View 1 Replies

Forms Data Controls :: Make Gridview Data As Hyperlink With Alias Open In New Window?

Sep 28, 2010

I have one asp.net C# page in which i have gridview..

This are the url comes from database and binded in gridview

www.xxxxxx.com/A/Default.aspx
www.xxxxxx.com/B/Default.aspx
www.zzzzz.com/C/Default.aspx

what i need is i need to show this url has like this

www.xxxxxx.com/A/Default.aspx is like Test1
www.xxxxxx.com/B/Default.aspx is like Test2
www.zzzzz.com/C/Default.aspx is like Test3
if user click Test1 it will open a new browser window with www.xxxxxx.com/A/Default.aspx
if user click Test3 it will open a new browser window with www.zzzzz.com/C/Default.aspx

how to make this in gridview

View 28 Replies

Datetime Column Messes Whole Query Up When Inserted Into Group By

Jan 18, 2011

We have a webservice which stores data in sql server 2008R2.I am trying to build a billing system and struggling with the next sql query.

scriberID,X.SubscriberName,X.ProductID,X.ProductDesc,X.NumOfTransactions,X.UnitPrice,SUM(X.NumOfTransactions
* X.UnitPrice)
AS ExtendedPrice
[code]...

View 15 Replies

SQL Server :: Select Query Based On Two Fileds With Different Column

Dec 21, 2010

This is my Table structure:-Table1

Field1 Field2 Age

Dean Chen 20

Janel Wast 25

ann Miller 20


I used this select statement

select Field1+' - '+Filed2 from Table1

and i binded this in dropdownlist

now on selecting dropdownlist i need to show age in label. so how would be my select statement... to show age base on Filed1 and Filed2

View 6 Replies

LINQ To SQL Defining Where Class Depending On Parameters?

Jan 26, 2010

[code]....

I am going to return an Object depending on the Class and Year params. I want to remove the where condition when the Class and Year parames are null or zero.

View 2 Replies

MVC :: Defining Validation Rules With Data Annotations?

Sep 24, 2010

Defined RegisterModel class - with some validation rules for creating new users, and this works fine.

Then I get this class, strip few properties and wanted to reuse it as UserInfo_Form_Model, for editing user properites.

No changes, just deleted few items, renamed and reused in strongly typed View for editing.

And result of validation is: -

[DisplayName("Name")] works fine, showing correct

[StringLength(20, ErrorMessage = "xxxx...")] - not working, no message showed when suppose to be one

[Required(ErrorMessage = "xxxx.")] - not working, not showing messages when delete required values?

but (ModelState.IsValid) is false when I checked it in controller (it had to be because required value is missing)?

Is it this only partially correct and how this can be?

Well this is a bit frustrating because it cant be simpler than this and I cant make this simple code reuse.

View 3 Replies

MVC Routes: Defining Route Including Subpaths

Jan 4, 2011

Let's say I want to forward all requests at /js/* to a JavaScript controller Index method. In other words, these routes should all invoke JavaScriptController.Index():

/js/root/index.css
/js/user/account/index.css
/js/master.css

What would the route definition be in my Global.asax.cs file? This doesn't seem to work:

routes.MapRoute("JavaScript", "js/{*path}",
new { controller = "JavaScriptController", action = "Index" });

The breakpoint is never invoked during Debug mode with:

public class JavaScriptController : Controller
{
[HttpGet]
public void Index(string path)
{
var browser = HttpContext.Request.Browser;
System.Diagnostics.Debugger.Break();
}
}

View 2 Replies







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