Search Results

Search found 42259 results on 1691 pages for 'group id'.

Page 9/1691 | < Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16 | Next Page >

SQL Server Update Group by

- by Gerardo Abdo

I'm trying to execute this on MS-SQL but returns me an error just at the Group by line update #temp Set Dos=Count(1) From Temp_Table2010 s where Id=s.Total and s.total in (Select Id from #temp) group by s.Total Do anyone knows how can I solve this problem having good performance.

Read the article
How to do a case sensitive GROUP BY?

- by Abe Miessler

If I execute the code below: with temp as ( select 'Test' as name UNION ALL select 'TEST' UNION ALL select 'test' UNION ALL select 'tester' UNION ALL select 'tester' ) SELECT name, COUNT(name) FROM temp group by name It returns the results: TEST 3 tester 2 Is there a way to have the group by be case sensitive so that the…

Read the article
Hibernate, select by id or unique column

- by Nican

I am using hibernate for Java, and I want to be able to select users by id or by name from the database. Nice thing about Hibernate is that it caches the result by id, but I seem to be unable to make it cache by name. static Session openSession = Factory.openSession(); public static User GetUser(int Id) { return (User)…

Read the article
Is it possible to have a local group for an LDAP user

- by fakedrake

I have an LDAP server to which i do not have full privileges and an ubuntu system with LDAP authentication to which i am root. Is it possible to add an LDAP user to a local group? (i dont know if i phrase this correctly but all i want is to have a user in LDAP in a group without edititing the actual database)

Read the article
SQL: How to order values inside group by

- by Denis Yaremov

Consider the following MS SQL Server table: ID | X | Y ------+-------+------- 1 | 1 | 1 2 | 1 | 2 3 | 1 | 3 4 | 2 | 40 5 | 2 | 500 6 | 3 | 1 7 | 3 | 100 8 | 3 | 10 I need to select the ID of the row that has the maximum value of Y…

Read the article
Diff between <head id="Head1" runat="server"> and <asp:ContentPlaceHolder runat="server" ID="HeadCon

- by justSteve

Looking for an better understanding of how an mvc project should define javascript and css includes. I'm working with sample code where includes are defined like: <head id="Head1" runat="server"> <title><asp:ContentPlaceHolder ID="TitleContent" runat="server" />Affiliate Checkout</title> …

Read the article
Get ID of a clicked parent ID

- by Yan Cheng CHEOK

I try using evt.parent.attr("id") inside jsddm_close, but it doesn't work. <script type="text/javascript"> var ddmenuitem = 0; function jsddm_open() { // When "help-menu" being click, I will toggle drop down menu. ddmenuitem = $(this).find('ul').eq(0).toggle(); } function jsddm_close(evt) { …

Read the article
How to find the latest row for each group of data

- by Jason

Hi All, I have a tricky problem that I'm trying to find the most effective method to solve. Here's a simplified version of my View structure. Table: Audits AuditID | PublicationID | AuditEndDate | AuditStartDate 1 | 3 | 13/05/2010 | 01/01/2010 2 | 1 | 31/12/2009 |…

Read the article
"Most popular" GROUP BY in LINQ?

- by tags2k

Assuming a table of tags like the stackoverflow question tags: TagID (bigint), QuestionID (bigint), Tag (varchar) What is the most efficient way to get the 25 most used tags using LINQ? In SQL, a simple GROUP BY will do: SELECT Tag, COUNT(Tag) FROM Tags GROUP BY Tag I've written some LINQ that works:…

Read the article
How to select the record contains MAX(some_field) within GROUP(group by)

- by lovespring

SELECT MAX(some_field) FROM table_A GROUP BY another_field. this only get the max value of the 'some_field', I wanna get the whole record which contains the MAX(some_field). thanks.

Read the article
Preventing out of office storms Exchange 2010, OWA and Auto Forward to a group

- by Simon McLaren

In my organization we have a group mailbox for a particular function. The actual function is preformed by 15 - 20 individuals on a rotating basis. The group mailbox serves as a record for all e-mail sent to that function. Individual access to the mailbox is established by adding a user to an A/D group. For…

Read the article
Transition from GPO to GPP

- by spelk

I have a Windows network with a 2003 server as the PDC, and a 2008R2 server as a DC. We have used GPO sparsely when the majority of our workstations were WinXP, but now we have Windows 7 clients and we're having some issues with printer mapping. I'm not quite sure how I would go about taking up GPP, would…

Read the article
how to match var/id to class

- by circey

Hi. I'm new to jquery and, in addition, I think I'm having a brain freeze. I have a number of links with different ids. I want to match the clicked link with a div with the corresponding class so the div will show/hide/toggle as appropriate. I have: <script type="text/javascript">…

Read the article
Joomla get plugin id

- by Christian Sciberras

I wrote a Joomla plugin which will eventually load a library. The path to library is a plugin parameter, as such when the path is incorrect, a message pops up in the backend, together with a link to edit the plugin parameters: …

Read the article
Is there a Generic USB TouchScreen Driver 12.04?

- by lbjoum

Is there a Generic USB TouchScreen Driver 12.04? Device 03eb:201c I've been looking for 4 days solid (not very skilled) and can't find a solution. I have a generic tablet: C97- Atom N2600 9.7" 2GB 32GB Bluetooth WiFi WebCam…

Read the article
Group Video Chat On iPad With Fring App

- by Gopinath

Apple’s Facetime is the simplest and most easy to use video chat application available for iOS devices and Apple Macs. Facetime lets you have a one-to-one video chat, but what about having a group chat on your iPad with a…

Read the article
How do I find out what process Id and thread id / name has a file open

- by peter

Hi All, I am using C# in an application and am having some problems with a file becoming locked. The piece of code does this, while (true) { Read a packet from a socket (with data in it to add to the file) Open a…

Read the article
Routing is using ID has action and action has ID after submitting a form

- by Victor Martins

I have a model User that has_one user_profile and a User_Profile belongs_to user in the User controller I have: def personal @user = User.find_by_id(params[:id]) @user_profile = @user.user_profile …

Read the article
how to hide webpart from a group?

- by kisin

can i hide (not by code) a webpart ONLY from a specific group?

Read the article
How to callback the new list id jQuery UI: sortable

- by PARyGuy

Hi, I'm trying to use the sortable widget for my site. I have a mini scheduling app that I'd like to display a list of appointments for the week sorted by days. For this example we'll use only two days ( 2…

Read the article
Unique SMS sender id?

- by Pascal

Hello, I want to build an app that send SMS to people. However, I want my users to know that the SMS comes from the app and nothing else so they can't fake it. Is there a way to guarantee that the sender ID…

Read the article
MYSQL - Group by limit

- by jono2010

Hello Is there a simple way to LIMIT the GROUP BY results to the top 2. The following query returns all the results. Using 'LIMIT 2' reduces the overall list to the top 2 entries only. select…

Read the article
Reading Active Directory group users in SharePoint

- by Faiz

Hi, Say that i have an active directory group called "Group1". I add this Group1 to a SharePoint site ( People and Group New User). All the users that are part of Group1 can now access…

Read the article
Two separate fields need to be grouped in one group

- by Sigita

I have two fields: Mother's employer and Father's employer, and I need to group on the employer. Could somebody help me combine the two above fields into one group? Both fields are in…

Read the article
Odd GROUP BY output DB2 - Results not as expected

- by CallCthulhu

If I run the following query: select load_cyc_num , crnt_dnlq_age_cde , sum(cc_min_pymt_amt) as min_pymt , sum(ec_tot_bal) as budget , case when ec_tot_bal 0 then 'Y' else 'N'…

Read the article

< Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16 | Next Page >