Search Results

Search found 7706 results on 309 pages for 'inner join'.

Page 140/309 | < Previous Page | 136 137 138 139 140 141 142 143 144 145 146 147  | Next Page >

• mysql query and index

  - by parm.95

  Does this query will be faster with a index on "t.type1" and "x.type1" or only index on "x.type1" is enought? SELECT t.id, x.id FROM t INNER JOIN x ON x.type1=t.type1 WHERE t.id=1

  Read the article

• Order by is not working

  - by coure06

  With Results as ( SELECT Top(100) percent ROW_NUMBER() over (Order by (select 1)) as RowNumber, Ad.Date, Title FROM Ad inner join Job on Ad.Id = Job.AdId Order by case When @sortCol='Date' and @sortDir='ASC' Then Date End ASC, case When @sortCol='Date' and @sortDir='DESC' Then Date End DESC ) Select * from Results Where RowNumber BETWEEN @FirstRow AND @LastRow END Whatever is passed in @sortDir and @sortCol it does not work.What am I doing wrong?

  Read the article

• CASE statement within WHERE statement

  - by niao

  Greetings, I would like to include CASE Statement inside my where statement as follows: SELECT a1.ROWGUID FROM Table1 a1 INNER JOIN Table2 a2 on a1.ROWGUID=a2.Table1ROWGUID WHERE a1.Title='title' AND (CASE WHEN @variable is not null THEN a1.ROWGUID in (SELECT * FROM #TempTable)) However, this 'CASE' statement does not work inside 'WHERE' statement. How can I do it correct?

  Read the article

• cocoa, mac, is there any tools can inspect the class constructs hierarchy of the window or view on

  - by Robin

  as topic, I want see the inner constructs of a special view on Mac, like the class name,and hierarchy , etc. as we know, on Windows, we can use Spy app for this purpose, if any the same feature app can be use on Mac ? thanks for you reply. Regards

  Read the article

• Big, Thick Reference Books (PHP / MySQL / Unix) [closed]

  - by Josh K

  I'm looking for in-depth reference books / guides in PHP, MySQL, and Unix. I'm aware there other other questions pertaining to good books for short references of function names, or detailed beginner guides to these systems. I'm looking for something different. I want a book that I can either use as a quick but in-depth (decent write up, not a pocket reference guide) reference to common functions (JOINS, string manipulation, Regular Expressions, etc) while also providing a detailed inner workings explanation on the system itself.

  Read the article

• SQL Update to the SUM of its joined values

  - by CL4NCY

  Hi, I'm trying to update a field in the database to the sum of its joined values: UPDATE P SET extrasPrice = SUM(E.price) FROM dbo.BookingPitchExtras AS E INNER JOIN dbo.BookingPitches AS P ON E.pitchID = P.ID AND P.bookingID = 1 WHERE E.[required] = 1 When I run this I get the following error: "An aggregate may not appear in the set list of an UPDATE statement." Any ideas?

  Read the article

• How to find the worst performing queries in MS SQL Server 2008?

  - by Thomas Bratt

  How to find the worst performing queries in MS SQL Server 2008? I found the following example but it does not seem to work: SELECT TOP 5 obj.name, max_logical_reads, max_elapsed_time FROM sys.dm_exec_query_stats a CROSS APPLY sys.dm_exec_sql_text(sql_handle) hnd INNER JOIN sys.sysobjects obj on hnd.objectid = obj.id ORDER BY max_logical_reads DESC Taken from: http://www.sqlservercurry.com/2010/03/top-5-costly-stored-procedures-in-sql.html

  Read the article

• MySQL, Coldfusion, Selecting records that were timestamped in the last 24 hours.

  - by nobosh

  With Coldfuson & MySQL - How to update the query to check for new entries that have a timestamp that occurs in the last 24 hours? Query: <cfquery name="caller.sel_BlogEntries" datasource="#request.db#"> SELECT blogentry.dateAdded, person.personName FROM blogentry INNER JOIN person ON blogentry.personID = person.personID WHERE blogentry.deleted = 'N' ORDER BY blogentry.dateAdded DESC </cfquery> blogentry.dateAdded is a MySql TimeStamp Thanks

  Read the article

• DataGrid SelectionChanged happens too often

  - by Tokk

  Hey, Guys As I have a DataGrid as another DataGrid's RowDetailsTemplate, I've got a strage effekt. If I Change selection in my inner DataGrid, the SelectionChanged-Method in the outer Grid is automatically caled, too. I don't know why, but I would like to know, what I can do against this. Thx

  Read the article

• Javascript: how to access anonymous object within object?

  - by Caballero

  I have a string generated by php's json_encode() that looks like this: [ { "key1":"value1", "key2":"value2", "key3":"value3" }, { "key1":"value1", "key2":"value2", "key3":"value3" } ] I use Javascript function to convert the string to Javascript object: var jsonObj=JSON.parse(string); How do I access the data inside since the inner objects have no names? I tried something like: alert(jsonObj.firstChild.key1); It gives me "undefined". Why is that so?

  Read the article

• Breaking out of a nested loop

  - by dotnetdev

  If I have a for loop which is nested within another, how can I efficiently come out of both loops (inner and outer) in the quickest possible way? I don't want to have to use a boolean and then have to say go to another method, but rather just to execute the first line of code after the outer loop. What is a quick and nice way of going about this? Thanks

  Read the article

• about onmouseout event.please help.

  - by lazyanno

  as follow codes: <div id="outerBox" style="border:1px solid red;width:300;height:300" onmouseout="alert('out')"> <div id="innerBox" style="border:1px solid blue;width:50;height:50">inner</div> </div> why when i move mouse on the "innerBox", it was trigger alert('out') ? i want mouse out "outerBox" trigger alert('out') only, mouse on "innerBox" don't trigger alert. hot to do this? thanks all :)

  Read the article

• ASP.NET MVC ActionLink in jquery-tmpl template

  - by Justin

  I have a jquery-tmpl defined: <script id="postTemplate" type="text/x-jquery-tmpl"> <div class="div-msg-actions-inner"> @Html.ActionLink("Edit", "Edit", "Post", new { postId = "${PostId}" }, new { @class = "button" }) @Html.ActionLink("Reply", "Reply", "Post", new { topicId = "${TopicId}" }, new { @class = "button" }) </div> </script> The action link results in the "$" being encoded into "%24". Is there a way around this so the ID in my action link will get replaced correctly?

  Read the article

• Why does Linq to Entities generate Left Outer Joins?

  - by DJCasey

  I was wondering if anyone knew why linq to entities always seems to generate left outer joins. I would understand it on an optional relationship but it doesn't make good sense when the relationship is mandatory. Does anyone have any idea how to make it generate inner joins instead?

  Read the article

• Is using joins in select clause slow in Oracle?

  - by gniquil

  I would like to write a query like the following select username, (select state from addresses where addresses.username = users.username) email from users This works in Oracle (assuming the result from the inner query is unique). However, is there a performance penalty associated with this style of writing query?

  Read the article

• Display Malformed HTML "Safely?"

  - by yar

  Let's say I have some HTML like this: <ol><li>a knock at the door, I'll be back in a second which I display as inline HTML within a div that I produce. Is there any way to stop the inner, malformed HTML from screwing up the alignment of the entire document that comes after the HTML? I realize that intelligently parsing it is one option (since I do have it on the server side), but I'm looking for a lighter solution.

  Read the article

• Incorrect syntax near the keyword 'select' while execuing query

  - by sam

  I am getting Incorrect syntax near the keyword 'select' after executing the following code. declare @c int SELECT @c = COUNT(*) FROM (select id, max(date_stored) from table B INNER JOIN table P ON B.id = P.id where id = 3) select @c I want to select total no of records having max stored dates in database. Can any one plz tell what I am doing wrong

  Read the article

• Converting SQL Query to LINQ 2 SQL expression

  - by Shyju

  How can i rewrite the below SQL query to its equivalent LINQ 2 SQL expression (both in C# and VB.NET) SELECT t1.itemnmbr, t1.locncode,t1.bin,t2.Total FROM IV00200 t1 (NOLOCK) INNER JOIN IV00112 t2 (NOLOCK) ON t1.itemnmbr = t2.itemnmbr AND t1.bin = t2.bin AND t1.bin = 'MU7I336A80'

  Read the article

• can this simple SQL query be optimized?

  - by ibiza

  Hi, I have the following query : SELECT COUNT(*) FROM Address adr INNER JOIN Auditable a on adr.UniqueId = a.UniqueId on a big DB (1.3M adresses, 4M+ auditables) both UniqueId columns are clustered primary keys the query is taking quite long to complete...I feel dumb, but is there any way to optimize it? I want to count all the address entries that have an underlying auditable... thanks!

  Read the article

• What did you develop using a microcontroller?

  - by DR

  I've always been fascinated by microcontrollers and I'm planning to do a few hobby projects just to satisfy my inner geek :) I'm looking for ideas and motivation, so what did you develop using a microcontroller? If possible please state the microcontroller and/or development environment and an estimate on hardware costs beyond the basic equipment (if applicable). I'm interested in both successful and failed projects and any problems you encountered.

  Read the article

• Rails, using ActiveRecord to find all rows matching a parent row attribute

  - by randombits

  I have a class Foo which has_many Bars. Foo has an attribute, some_id. I want to Retrieve all Bar instances where the Foo has some_id = N. In SQL this translates into something like: select * from bar inner join foo on foo.id = bar.foo_id WHERE foo.some_id = N

  Read the article

• How to Stop Frame Clipping

  - by Tomas1

  Hi All, I have a Page built in xBap with a frame, and another page in the frame How can I take out a control from the inner page outside of a frame in visual, in other words, I want to stop clipping for the frame. Thanks in advance

  Read the article

• how to avoid deadlock in mysql

  - by noam

  I have the following query (all tables are innoDB) INSERT INTO busy_machines(machine) SELECT machine FROM all_machines WHERE machine NOT IN (SELECT machine FROM busy_machines) and machine_name!='Main' LIMIT 1 Which causes a deadlock when I run it in threads, obviously because of the inner select, right? The error I get is: (1213, 'Deadlock found when trying to get lock; try restarting transaction') How can I avoid the deadlock? Is there a way to change to query to make it work, or do I need to do something else?

  Read the article

• Retrieving the Selected value dynamically in JQuery

  - by Chakradhar

  i have this html, this is generated dynamically based on question number <fieldset id="selectfield"> <label class="select">What ur is Profession? </label> <br> <div class="ui-select"><a href="#" role="button" id="72+_select-button" aria-haspopup="true" aria-owns="72+_select-menu" data-theme="c" class="ui-btn ui-btn-icon-right ui-btn-corner-all ui-shadow ui-btn-hover-c ui-btn-up-c"><span class="ui-btn-inner ui-btn-corner-all" aria-hidden="true"><span class="ui-btn-text">Business</span><span class="ui-icon ui-icon-arrow-d ui-icon-shadow"></span></span></a> <select name="selectedObjects" id="72+_select" data-native-menu="false" tabindex="-1"> <option value="-1">--Select--</option> <option value="769">Salaried</option> <option selected="selected" value="770">Business</option> <option value="771">Self Emp</option> </select></div> </fieldset> click button is <div data-theme="c" class="ui-btn ui-btn-corner-all ui-shadow ui-btn-hover-c ui-btn-up-c" aria-disabled="false"><span class="ui-btn-inner ui-btn-corner-all" aria-hidden="true"><span class="ui-btn-text">Next</span></span> <input type="submit" id="72+_b" onclick="return SaveDropDown(this);" value="Next" class="ui-btn-hidden" aria-disabled="false"> </div> i have written this JS in SaveDropDown(this) function SaveDropDown(button) { var fieldsetName = getQuestionName(button.id)+'+_select'; var select = $(fieldsetName +"option:selected").val(); return false; } the questionname function is function getQuestionName(buttonid) { var splitstr = buttonid.split('+'); var fieldsetName = '#' + splitstr[0]; return fieldsetName; } but its returning the undefined how do i retrieve the select value dynamically. any help is appreciated.

  Read the article

• How to read MIDI file in C#?

  - by melculetz

  Do you know any library in C# that I can use in order to read an existing *.mid file? I want to draw the sound frequency graph for the MIDI file, but I cannot get the inner data. I tried using NAudio and Alvas.Audio, but I wans't able to read a MIDI file. Any suggestions?

  Read the article

< Previous Page | 136 137 138 139 140 141 142 143 144 145 146 147  | Next Page >