Search Results

Search found 42428 results on 1698 pages for 'database query'.

Page 546/1698 | < Previous Page | 542 543 544 545 546 547 548 549 550 551 552 553  | Next Page >

• VB .Net LINQ query to determine whether more than one element has the same value for a property?

  - by Alex Hope O'Connor

  I am trying to write a LINQ query which will return true if there are multiple objects which have a property with the same value. Here is what I have come up with so far: Formatters.Where(Function(f As DataModel.Formatter) _ Formatters.Select(Function(f2 As DataModel.Formatter) f2.Name.ToLower()).Contains(f.Name.ToLower())).Count > 1 However the above always returns true as long as their are more then 1 elements in the list, can someone please give me a hand with this? Thanks, Alex.

  Read the article

• How to write linq query in Entity FrameWork but my table includes Foreignkey?

  - by programmerist

  i have a table it includes 3 foreignkey field like that: My Table: Kartlar ID (Pkey) RehberID (Fkey) KampanyaID (Fkey) BrimID (Fkey) Name Detail How can i write entity query with linq :? select * from Kartlar where RehberID=123 and KampanyaID=345 and BrimID=567 BUT please be carefull i can not see RehberID ,KampanyaID, BrimID in Entity they are Foreign Key. I should use Entity Key but How?

  Read the article

• SQL query that returns columns form table A plus a bit column that specifies with the PK of table A

  - by dannie.f

  How can I write an efficient SQL query that returns columns form table A plus a bit column that specifies whether the PK of table A exists in table B? I am using MS SQLServer 2005. Thanks.

  Read the article

• How can I replace/speed up a text search query which uses LIKE ?

  - by Jules

  I'm trying to speed up my query... select PadID from Pads WHERE (keywords like '%$search%' or ProgramName like '%$search%' or English45 like '%$search%') AND RemovemeDate = '2001-01-01 00:00:00' ORDER BY VersionAddDate DESC I've done some work already, I have a keywords table so I can add ... PadID IN (SELECT PadID FROM Keywords WHERE word = '$search') ... However its going to be a nightmare to split up the words from English45 and ProgramName into a word table. Any ideas ? EDIT : (also provided actual table names)

  Read the article

• limiting consecutive values of one column in a sql query.

  - by Brad Smith

  I have a table with the following structure: id -int(11) event_id -int(11) photo_id -int(11) created_at -datetime How do I write a query that will return the 100 most recent rows, but insuring that there are no more than 4 consecutive rows with the same value in photo_id

  Read the article

• Can a database function be called in the predicate of a llblgen query?

  - by Dan Appleyard

  I want to use a table-valued database function in the where clause of a query I am building using LLBLGen Pro 2.6 (self-servicing). SELECT * FROM [dbo].[Users] WHERE [dbo].[Users].[UserID] IN ( SELECT UserID FROM [dbo].[GetScopedUsers] (@ScopedUserID) ) I am looking into the FieldCompareSetPredicate class, but can't for the life of me figure out what the exact signature would be. Any help would be greatly appreciated.

  Read the article

• Support for encoding query string or POST data in YUI ?

  - by faB

  How do you encode a javascript object/hash (pairs of properties and values) into a URL-encoded query string with YUI (2.7.0 or 3.0.0 Beta) ? I want to do the equivalent of Object.toQueryString() from Prototype: I need this to encode parameters for GET and POST requests with YAHOO.util.Connect. It turns out YAHOO.util.Connect has a setForm() method to serialize a form but that still leaves me out cold to encode parameters for GET requests, or the 4th parameter of YAHOO.util.Connect.asyncRequest() to pass post data.

  Read the article

• How do you compare dates in a LINQ query?

  - by Gina

  I am tring to compare a date from a asp calendar control to a date in the table.... here's what i have... it doesn't like the == ? var query = from details in db.TD_TravelCalendar_Details where details.StartDate == calStartDate.SelectedDate && details.EndDate == calEndDate.SelectedDate select details;

  Read the article

• How to determine sql server object name from object id and database id (sql2000)?

  - by Tomek

  I need the behaviour of sql2005 where function OBJECT_NAME takes two arguments obj id and db id, while sql2000 takes only obj id so the execution must be in the context of the database to which inspected object belongs to. Solution must be possible to implement in a function, so it can be used in a select query.

  Read the article

• How may I store geographical data in an android database and query for it?

  - by Eduardo

  I want to store locations in my Android phone and be able for the application to tell me if I am inside these points&radius. What is the best way to store many point&radius locations and efficiently query for them?

  Read the article

• How do i append query string from managed bean to url? JSF

  - by Nitesh Panchal

  Hello, Can this method work? public String sayHello(){ return "Hello.jsp?name=" + "laala"; } I am unable to access, query string using the above method. I tried ${param.name} as well as request.getParameter("name"). They both return null. Please help!

  Read the article

• How to concatenate all the records in a column returned by a query into one varchar string in T-SQL?

  - by Ivan

  A query (SELECT/FUNCTION/VIEW/PROCEDURE) returns a column of varchar records. I need to concatenate them all into one single varchar line. How do I best do it in T-SQL?

  Read the article

• When using skip and take to page data, how can I get the total record count without a separate query

  - by Keith Myers

  I don't see how this is possible, but I really, really hate to run my query an extra time just to get the record count so I can build a pager. When I say a "pager" I simply mean the common gizmo with a link for each 10 records for example.

  Read the article

• SQL Server 2000: Why is this query w/ variables so slow vs w/o variables?

  - by William DiStefano

  I can't figure out why this query would be so slow with variables versus without them. I read some where that I need to enable "Dynamic Parameters" but I cannot find where to do this. DECLARE @BeginDate AS DATETIME ,@EndDate AS DATETIME SELECT @BeginDate = '2010-05-20' ,@EndDate = '2010-05-25' -- Fix date range to include time values SET @BeginDate = CONVERT(VARCHAR(10), ISNULL(@BeginDate, '01/01/1990'), 101) + ' 00:00' SET @EndDate = CONVERT(VARCHAR(10), ISNULL(@EndDate, '12/31/2099'), 101) + ' 23:59' SELECT * FROM claim c WHERE (c.Received_Date BETWEEN @BeginDate AND @EndDate) --this is much slower --(c.Received_Date BETWEEN '2010-05-20' AND '2010-05-25') --this is much faster

  Read the article

• how to mark line in database in Crystal-report ?

  - by Gold

  hi i have crystal-report that show my DataBase. how i can mark line in the crystal-report ? for example: i run any query that return one line - and i want to see all the table - and only this line will be mark thank's in advance

  Read the article

• How to stop looking in a database after X rows are found?

  - by morningface

  I have a query to a database that returns a number X of results. I am looking to return a maximum of 10 results. Is there a way to do this without using LIMIT 0,9? I'll use LIMIT if I have to, but I'd rather use something else that will literally stop the searching, rather than look at all rows and then only return the top 10.

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery if we only want to

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery or vice versa if we only want to find the intersection? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery. But if all we care is to find the intersection, without caring what is being displayed, then we can always convert one to the other?

  Read the article

• How do I select the first row per group in an SQL Query?

  - by mafutrct

  I've got this SQL query: SELECT Foo, Bar, SUM(Values) AS Sum FROM SomeTable GROUP BY Foo, Bar ORDER BY Foo DESC, Sum DESC This results in an output similar to this: 47 1 100 47 0 10 47 2 10 46 0 100 46 1 10 46 2 10 44 0 2 I'd like to have only the first row per Foo and ignore the rest. 47 1 100 46 0 100 44 0 2 How do I do that?

  Read the article

• How to find out whether SqlCe query Has rows?

  - by Tomas

  Hi, In my simple db I use SqlCe and I cannot figure out how to correctly find out whether the query has rows or not. HasRows does not work. So far I have this: _DbCommand.CommandText="SELECT * FROM X" SqlCeDataReader reader=_DbCommand.ExecuteQuery(); if (reader.FieldCount!=0) //I thought it could work (O rows - 0 fields?), but its true even with 0 rows { while (reader.Read()) { // } } Thanks

  Read the article

• How to convert rows returned by a query into columns in oracle?

  - by Piyush Lohana

  I have to display the results of the below query as columns. select to_char(sysdate + 1 - rownum,'MON-YYYY') as d from all_objects where trunc(sysdate + 1 - rownum,'MM') = trunc(to_date(:from_date,'MON-YYYY'),'MM') minus select to_char(sysdate + 1 - rownum,'MON-YYYY') as d from all_objects where trunc(sysdate + 1 - rownum,'MM') trunc(to_date(':to_date','MON-YYYY'),'MM') Please help me in figuring that out.

  Read the article

• Turning On General Query Logging FOR WINDOWS in MySQL.

  - by Joshua

  I want to view the actual SQL resulting from a php call to mysqli-prepare, and apparently the only way to do that is by logging all queries. However, I can't seem to manage to turn on query logging in mysql for windows. Help?

  Read the article

• Get the count of items in a GroupBy Linq-to-sql Query?

  - by Curtis White

  I have a groupby that I groups all elements. I can see the items are there in LinqPad but can't find a way to get the count. Here is what I have so far: SurveyResponses.Where( q = q.QuestionId == 4).GroupBy(q = q.AnswerNumeric).Where( g = g.Key == 1) In Linq Pad I can see there are 4 items in this query. If I do Count it returns 1. I've tried, ToList().Count, Select(x = x).Count, etc.

  Read the article

• MDX: How to exclude ancestors from being returned in this query?

  - by wgpubs

  I have this MDX query: Exists([Group].[Group Hierarchy].allmembers, {[Group].[Group Full Name].&[121 - Group A], [Group].[Group Full Name].&[700000 - Group C]}) ... which works fine EXCEPT that it returns all of the ancestors of the specified groups as well. What I want is to return JUST the groups from the hierarchy with the specified Group Names (this is a type 2 dimension so there may be many at different levels). Any ideas?

  Read the article

• Design ideas in constructing (from the UI) and parsing (at the server) a query.

  - by Vishal

  The UI looks like: I am looking for an elegant logic or any library to parse the query for all possible combinations of the above. PS: May be the UI can be designed better. Posts appreciated. Thanks

  Read the article

• What the linq query for SQL like and Soudex for sql server 2008?

  - by KentZhou

  In sql server, we can issue sql to get data like select * from table where column like '%myword%' select * from person where Soundex(LastName) = Soundex('Ann') what's the linq query to match above sql?

  Read the article

< Previous Page | 542 543 544 545 546 547 548 549 550 551 552 553  | Next Page >