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)
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".
 <EntitySet Name="EntityFramework" EntityType="SEOAnalysisModel.Store.EntityFramework"> <DefiningQuery> SELECT Keyword, ResultHead ,Year from SeoAnalysis where Year = 2005
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
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!
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.
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:
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....?
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?
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.
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.
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).
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
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.
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():
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(); } }