SQL Server :: Reference 2 Columns In A Query?
Aug 31, 2010
reference 2 columns in a query? I have 4 tables
First Table
[Code]....
My first method I tried I thought I had solved it. The last 3 tables are populated through a webform. The query I created definitely produces the output above but I had to create 4 more duplicate tables. The solution was a bit shortsighted as users can also delete items from the last table. So when users deleted amounts it did not reflect on the output. I want to know if the above tables can be used to produce the intended output
View 5 Replies
Similar Messages:
Feb 15, 2011
I am looping through a JSON table using jquerys foreach operator. I am having to reference the the columns by name e.g:
$.each(items, function (index, item) {
if (item.CustomerFname == "Bob") {
alert(item.CustomerFname + " " item.CustomerSname)
}
Whereas I would like to be able to say something like:
[code]....
Ultimately I'm trying to make this function dynamic with respects to the json list I pass in which will of course mean that the column names will change. However I would like to perform the same operations on the columns...
View 2 Replies
Oct 20, 2010
I have two queries
Dim query1 as String = "Select * from openquery (devbook, 'SELECT start_date FROM bookings WHERE investor = ''00000'' ')"
Dim FlightQuery as String = "Select * from openquery (devbook, 'SELECT price FROM flight_prices WHERE dep_date = start_date ')"
Where it says dep_date = start_date I need to grab the start_date from the first query and put it into my 2nd query.
View 1 Replies
Dec 21, 2010
I have a WCF Dataservice which i am comsuming for Dynamic Data. My entity where i am facing problem looks like this
[Code]....
Now i want to query all the children who has the father with Id=14. The way i will write a linq query will be
[Code]....
where query is of type DataServiceQuery sent from the UI.
However, above query is generating the URI as [URL] instead of [URL]
If i manuall add a filter AddQueryOption("$filter", "father/Id eq 14"); It works fine. But problem is i just have to extend the query in my method, not replace. if there is already a filter added this addqueyoption fails.
View 1 Replies
Dec 28, 2010
I have a label control in an aspx page, can i set value to the label from an handler file? How can i pass the reference of the label through query string?
View 1 Replies
Apr 15, 2010
this is my sample script
[Code]....
after execute this script which returns a column name "XML_F52E2B61-18A1...." can I change this column name?like this
select EMPNO AS EmployeeName -- we can use AS to change column name
from EMPLOYEE
View 1 Replies
May 11, 2010
I need to concatenate several columns of a table into a single value, then show that value in an asp dropdownlist. The SQL code I'm issuing is as follows:
SELECT UserID, CustomerNum, UserName + ' - ' + UserAddress + ',' + UserCity + ' ' + UserState AS UserInfo
FROM Users
WHERE (CustomerNum = @CustomerNum)
ORDER BY UserName
I then set 'UserInfo' as the text field in the dropdownlist.This generally works, except occasionally one of the columns in the database is null (for example, UserState). When that happens, the entire concatenation is null, and I get an empty entry in the dropdownlist.
Is there something in SQLServer that will allow me to ignore those NULL results, or will I have to code something up in the DataBind event?
View 6 Replies
Mar 2, 2011
I am using SQL Server2005 with asp.net. I want validation at server side to restrict duplicate entries, Here i am using two tables companies and Branches. In Branches Table i had maintain a foreign key of CompanyId. In Branches the BranchName can be duplicate but not for the Particular CompanyId
View 2 Replies
Feb 9, 2010
I am trying to create an application in which there is a summary of outstanding payments.
One table is Table_Bills.
The other table stores records of Payments made and is called Table_Payments.
In summary i want to show 3 figures - each in separate one field datagridview with a data_source in separate data_adapter:
1) Ammount_Due 2) Amount_Paid 3) Balance.
The first two are no problem but the last is giving me a headache.
I tried this:
SELECT SUM(DHB_New_Jobtable.DayWage) - SUM(DHB_Payments.Ammount) AS Expr1
View 4 Replies
Mar 14, 2010
I creat a Family Website and i use Dataset to get Family members from sql databace.
In my databace i have MemberID, Name, MiddleName and Last Name.
I want also return the Member FullName and i use this Query to return the members from database table:
SELECT MemberID, ParentID, Name, MiddleName, LastName, Name + MiddleName + LastName AS FullName
when we have Name="Jon" MiddleName="" Lastname="Smith" it return JohnSmith
my only problem is how can i get space between the Name MiddleName And Last name like "Jon Smith"
View 2 Replies
May 17, 2010
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies
Mar 2, 2011
I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
Month-download-GameID-UserID
1 1
1 1
1 1
1 1
View 2 Replies
Feb 1, 2011
I am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables
View 7 Replies
Sep 3, 2010
I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2
View 1 Replies
Nov 4, 2010
i have tow query in one stored procedure
first query and the second one every of them return only value
i want to copy the result of tow values in a new row in new table
as i want to check on this tow values in ado.net
i want to get only this tow values as a row not first and secon query
only a row has result of first and second query results
[Code]....
View 3 Replies
Oct 14, 2010
How can I SELECT second if first SELECT returns nothing?
View 8 Replies
Aug 3, 2010
i am making relation between two datatables and m getting this error
in this ds.Tables(0).Columns("In_ID") datatype is string
ds.Tables(1).Columns("row_id") datatype is integer
how i do the type casting here to make dataset relation
ds.Relations.Add("Rel_1", ds.Tables(0).Columns("In_ID"), ds.Tables(1).Columns("row_id"), True)
View 3 Replies
Dec 17, 2010
Using sql server 2005.
I have an Query A of fields that returns X number of records.
I create a Query B of same fields that returns X-80 number of records.
I want to find out the 80 records that are in Query A but are not in Query B. what is the syntax for this?
View 4 Replies
Nov 8, 2010
Trying to get a query going in SQL server but I get bad/ errors in the query.I have a 2 tables. One is the "Project" table while the other is the "Task" table.Table structure is as follows.
Project table => ProjectID,ProjectName
Task table => TaskID, TaskName,ProjectID,Quarter, Hours
A project can have many task. The ProjectID in Task table is the foreign key which reference the project ID.What I need to do is to SUM all the hours in the Task table and group it by quarter and then group it by ProjectID. Output of the SQL should be in the form of projectID,Quarter, Hours.
View 2 Replies
Jan 22, 2011
I want to transfer the data from one server to another by sql query. I want query. I dont know how to write?
View 2 Replies
Dec 15, 2010
I have the following query that uses a linked server that is on a different VLAN of our network:
[Code]....
It works fine in Query Analyzer but when I put it into Visual Web Developer 2008 Express as a SQL Data Source I get an error:
"OLE DB Provider 'MSDASQL' reported an error. Authentication failed."
View 16 Replies
Jan 28, 2011
I think this is simple, but I don't know how to do it.I have a table with 13 decimal type columns. I want to return columns in my query where the value of the column is greater than 0. What I think is to do a nested select within my WHERE statement, but that seems clunky, is there a better way?
View 12 Replies
Mar 7, 2011
I'm not even sure if I'm using the correct terminology of "Pivot". I've seen several examples of pivoting in SQL but I have not found anything like I am trying to do.Can someone tell me if it's possible to pivot columns for one row like so?:
[code]...
View 2 Replies
Jan 31, 2010
How does one put up a server maintenance page or reference..
Do you build a whole separate asp.net project with you basic page and logo and use that on the domain, until your main project is back up and running..
View 8 Replies
Mar 9, 2010
I've added a web reference locally which looks up post codes. All works ok locally. Now I just want to deploy this to my web space. There is a app_WebResources folder with various files that were created when I added this. Basically what I want to know is How do I get all this to work online?
View 7 Replies