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

Similar Messages:

Query For Search Based On Fileds?

Jan 9, 2011

i have 5 Text boxes , all are searching options like


View 6 Replies

Select Query In LINQ Based On Foreign Table

Mar 2, 2011

I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file. OrderDetailsID is a foreign key in Requests Table. I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId. And If there is a row in Requests Table for each OrderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum. Here is the way I implement that. I am looking to prevent using "For each".

iRefund = (From od1 In dc.OrderDetails _
Where od1.OrderID =1 _
Select od1.UnitCost).Sum
Dim objOrderDetails = (From od1 In dc.OrderDetails _
Where od1.OrderID =1 _
Select od1)
For Each OrderDetail As ORM.Entities.OrderDetail In objOrderDetails
If Not OrderDetail.Requests Is Nothing Then
IF OrderDetail.Requests.Last.RequestType="Refund" Then
iRefund -= OrderDetail.UnitCost
End If
End If

View 1 Replies

Web Forms :: Select CheckBoxList Items Based On LINQ Query Results

Apr 29, 2010


using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace find.Admin
public partial
class WebForm1 : System.Web.UI.Page
class servicetimeofday
public int servicetimeofdayid {
get; set; }
public int serviceid {
get; set; }
public int timeofdayid {
get; set; }
protected void Page_Load(object sender,
EventArgs e
List<servicetimeofday> servicetimesofday =
new servicetimeofday() { servicetimeofdayid = 1, serviceid = 1, timeofdayid = 1 },
new servicetimeofday() { servicetimeofdayid = 2, serviceid = 1, timeofdayid = 2 },
new servicetimeofday() { servicetimeofdayid = 3, serviceid = 2, timeofdayid = 1 },
new servicetimeofday() { servicetimeofdayid = 4, serviceid = 2, timeofdayid = 3 }
GridView2.DataSource = servicetimesofday;
var itemstocheck = from
servicetimeofday in servicetimesofday
where servicetimeofday.serviceid == 2
select ne
GridView3.DataSource = itemstocheck;
foreach (var timeofdayid
in itemstocheck)
foreach (ListItem i
in CheckBoxList2.Items)
if (i.Value == timeofdayid.ToString())
{ i.Selected =
true; }

View 10 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 :: Select Second Query If First Query Returns Nothing?

Oct 14, 2010

How can I SELECT second if first SELECT returns nothing?

View 8 Replies

Forms Data Controls :: Select A Grid Row Based On Query String Data?

Jan 13, 2010

I need to know how can I select a gridview row based on a query string data. In my case, the query string will contain the id that exist in the Table related to that grid. Is there a way to do this from the code behind? In other words, if I click a link with that specific query string, can I open the page and tell my grid to select a specific row based on the table row id?

View 1 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
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:


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

View 12 Replies

SQL Server :: How To Select Population Based On District

Dec 12, 2010

How to select population based on district?

Ex table: Country, District, Population, State

View 5 Replies

SQL Server :: Select Query Not Working

Oct 14, 2010

i have been having trouble trying to find out what is wrong with my sql select query... i wanted to select a sessionID by comparing the tourID and dates. the dates datatype at the database is datetime and the value of itemSessionDate is in string. i tried to convert itemSessionDate to date and dateAndTime but it gave me mm/dd/yyyy while the date in my database is dd/mm/yyyy hh:mm:ss. so i thought i can try using the itemSessionDate string as it has the same value as the one return from the database. but it keeps on goin to the if not reader.hasRows and quit the statement


View 3 Replies

SQL Server :: SQL Query - Select Subquery?

Jan 24, 2011

I have been utilising a SELECT query such as the following:


BSFLBWF_1.Severityx, BSFLBWF_1.Openx, BSFLBWF_1.Closex, BSFLBWF_1.Closurex, BSFLBWF_1.Customerx, BSFLBWF_1.Availabilityx, BSFLBWF_1.KPIx,

CONVERT(Decimal, BSFLBWF_1.Minsx) AS Expr1, BSFLBWF_1.Unusedx, BSFLBWF_1.FirstIntx, BSFLBWF_1.RepeatIntx, BSFLBWF_1.Corex,

BSFLBWF_1.OffPeakx, BSFLBWF_1.NonCorex, BSFLBWF_1.DedTypex, CONVERT(money, BSFLBWF_1.SchoolChargex) AS Expr2, CONVERT(money,

BSFLBWF_1.LANMLEChargex) AS Expr3, BSFLBWF_1.KPIFailx, BSFLBWF_1.Overridex, BSFLBWF_1.Reasonx, BSFLBWF_1.Contactx,

WHERE (BSFLBWF_1.Closex IS NULL) AND (BSFLBWF_1.DedTypex = 'School' OR
BSFLBWF_1.DedTypex = 'LAN-MLE')

The rest of the query continues as the above albeit selecting the same data from different tables and works fine.

The issue I have is that I want to Select some more data (another SELECT query) but with a different Where clause e.g. WHERE (BSFLBWF_1.KPIx NOT LIKE 'KPI%' OR
BSFLBWF_1.KPIx NOT LIKE 'Proactive%') AND (BSFLBWF_1.Availabilityx LIKE '')

The problem is that this WHERE clause returns data which the above in bold has null values for (and thus doesnt work). Im still selecting the same data its just the WHERE Clause has changed. Is it possible to run such a query? If so, can it be done via a sub query?

View 10 Replies

SQL Server :: Select Records Based On Previous Record?

Mar 23, 2011

If I have records in a table in this order:

Id - Date - Type
1 - 2011-03-01 - 1
2 - 2011-03-02 - 0
3 - 2011-03-03 - 0
4 - 2011-03-04 - (-1)
5 - 2011-03-04 - 0

Can I somehow select the records between a record having type 1 and type -1 without using a cursor,for example the records with ids 1-4 in this example?

View 9 Replies

SQL Server :: Select Query Is Repeating Records

Jan 3, 2011

I have an SQL 2005 db with a table named "industry_suppliers."

I've created a query to enable someone to search this table using 3 parameters.

The results need to be grouped by "product_description" (which is essentially a category). When displayed on an .aspx page, for example, the results need to look like this:


Acme Apple Company
Bradbury Orchards
A1 Citrus Company
Belfast Growers, Inc
Bradbury Orchards

Notice how "Bradbury Orchards" is repeated under both categories. This is the result I want, EXCEPT in cases where someone wants to filter the search results by category. Let's say someone wants to search just for apple suppliers. The problem I'm having is that any record that appears under apples will also get listed again under any other categories associated with that record. So, searching for apple suppliers, the results are this:

Acme Apple Company
Bradbury Orchards
Bradbury Orchards

I'm having trouble figuring out how to revise my query to avoid this problem.


View 4 Replies

SQL Server :: Select Query On A Partitioned Table

Jul 20, 2010

I have partitioned a table and it has been partitioned according to an account id. ie also rows that have accountid =1 will be in A partition and all rows that have accountid = 2 will be in B partition. so now if i execute a query with where condition accountid =1 sql server will search only in A partition. Suppose if i add another condition to it ie where accountid=1 and place="aaa" will this query search only A partition or the entire table?

View 3 Replies

SQL Server :: SELECT Query And Null Values?

Feb 3, 2011

I have stored procedure which selects records from an SQL table based on a bunch of user-input parameters.Just discovered that if a record in the table has null values in some of the columns (I haven't figured out which ones yet), then the SELECT is not returning the record (even if it satisfies all the parameters).The SELECT statement is supposed to allow for nulls, and I've been over it a bunch of times and am not sure what I'm doing wrong.Or do I need to get rid of all the null values in the SQL table, and prevent new ones from being introduced?


View 6 Replies

SQL Server :: Select Only Filled Column?

Jan 25, 2011

I have a suitation where i want to select only those columns only which contain any data blank, null or "0" values data couldn't retrive from query.

for eg.
SL NO Name Contact Address email remarks
01 Atul 0 Ranchi atul@hotmail.co.in
02 Atul 34753 fdsgsdfgdfs

what query i write which display only slno, name, address and email automaitcally for slno 1, or slno,name,contact and remarks for slno2.

View 8 Replies

SQL Server :: Query - Select 3 Record Order By Date?

Dec 2, 2010

i want to select three records order by Date .This is my News table.

NewID NewTitle NewContent NewDate
1 Example ExampleContent 01.12.2010
2 Example2 ExampleContent2 02.12.2010
3 Example3 ExampleContent3 03.12.2010
4 Example4 ExampleContent4 04.12.2010

So,query selects example4,example3 and example2.

View 5 Replies

SQL Server :: Passing Parameters For Select Query To Another Page

Dec 14, 2010

I have an asp.net site which includes a "search" page that queries an SQL table, then redirects the user to a "results" page where the results of the query are displayed. The parameters for the query are assembled into a string which is the SELECT statement. I've been asked to add additional functionality that requires a secondary search which takes place on the "results" page. How can I pass the parameters from the "search" page to the "results" page so that I can access those parameters in the code behind? Here's the first page code behind (I inherited most of this from another developer):


And the second page--it would be on line 51 that I would need to insert the parameters from the search above:


View 3 Replies

SQL Server :: How To Find And Replace Substring In Select Query

Sep 22, 2010

how to find and replace substring in select query


View 2 Replies

SQL Server :: Select Query Doesn't Return Values?

Oct 28, 2010


for some reason it doesnt return any values.

before i've added the inner join it worked perfectly.

i couldn't find my mistake, though i passed over it several times.

View 8 Replies

SQL Server :: Adding A New Table To An Old Databse And It's Select Query?

Jul 17, 2010

I have inherited a very old SQL Server Database for a live site, but have been asked to add a new table for invoice recording to it. Fairly easy to do for any new record added from now on, however I run into some issues with selecting older records.I need to find a way to select from 3 tables, see if a record exists in the new table and if not insert a new record to it.My stored procedue so far is (The new table is [Invoicing]:


View 3 Replies

SQL Server :: Select Query Where Duplicate Doesn't Occur?

Feb 22, 2011

in my table data are stored many times ...I want select the only one data from the repeated data

select ven.Id,ven.Vendor_Name from Purchase_Requsition pur,Item_master itm,Approved_Vendors ven where itm.Item_Id=pur.Item_masterItem_Id and ven.Id=itm.Approved_VendorsId and pur.Request_StatusId=1 and pur.StatusId<>4

1 Ranbaxy
1 Ranbaxy
1 Ranbaxy
2 cipla

i want to make it thru query as

1 Ranbaxy
2 cipla

View 3 Replies

SQL Server :: Select Column From All Tables In Database?

Sep 3, 2010

I want to retrieve the name and phone columns from all the tables in my database not in systables.

Ok this works but i dont want to get it from just the test table I want to get it from all the tables that I create

"USE mrpoteat SELECT name, phone FROM mrpoteat.dbo.test where name = name and phone = phone"

View 3 Replies

SQL Server :: Select Query That Returns Records By Date Today

Sep 22, 2010

In my data table i have a Date Column with of type DateTime.

In my sql select query, I want to return all records where the date is today.

View 8 Replies

SQL Server :: Query To Select Data From Multiple Tables And A Different Database?

Dec 1, 2010

Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.

My current statement is as follows (there are alot more fields but I have shortened it ):

WHERE (BSFLBWF_1.Closex IS NULL).........

View 4 Replies

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