c# - group by first letter of the string -

-

i have person table, huge number of records, , want group duplicate persons in it, 1 of requirements persons duplicates, if have same family name, , first letter of first names equal, want group first name, , first letter of family name, there way group in sql this? need in c#, code processing done, number of persons huge, should fast algorithm.

select member.member_firstname, count(member.member_lastname) dbo.member group member.member_firstname, substring(member.member_lastname, 1,1) having count(member.member_lastname) > 1

this query give (members in case) first name same , last name's first letter same more 1 member. in other words duplicates you've defined it.


Comments

Post a Comment

Popular posts from this blog

c# - Outlook Add-in,group emails based on color category -

-
i need set sub folder group property through c# outlook add-in code basically, got mails in folder different color categories.i need sort them through code initially thought of sorting: microsoft.office.interop.outlook.items oitems =m_outlook.inbox.items; oitems.sort("[categories]"); dosnt work... :( pretty lost here also trying bubble sorting : but cant assign mail item next index object objmessage = subfolder.items[counter]; object objnextmessage = subfolder.items[counter + 1]; subfolder.items[counter] = objnextmessage; subfolder.items[counter + 1] = objnextmessage; error: property or indexer 'microsoft.office.interop.outlook._items.this[object]' cannot assigned -- read sorting seemed difficult option thought of grouping . how go ? cheers! rajat sort re-order items in collection won't update view: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook._items.sort.aspx you'd need set collection di...
Read more

PHP: Exploding array elements -

-
i have 2d array have exploded string. once has exploded output: ---> 0 - 16~4~0.0~~~~false~~~~ ---> 1 - 1000.0~21.75~l~1~2.0~2.0~l~2~ ---> 2 - ---> 0 - 2~5~951.3~6.4~~~false~~~~ ---> 1 - 1000.0~11.77~l~1~ ---> 2 - ---> 0 - 3~6~1269.02~5.1~~~false~~~~ ---> 1 - 5.0~213.66~l~1~4.9~2.56~l~2~4.6~19.5~l~3~ ---> 2 - 5.1~53.44~b~1~5.4~8.48~b~2~5.5~15.53~b~3~ i want make each position in array takes first value before ~. unsure how this. code have far: $test = explode(":", $string); foreach($test &$value) $value = explode('|', $value); just in case need original string input: 1~1~828.32~12.5~~~false~~~~|1000.0~41.73~l~1~2.0~2.0~l~2~|:4~2~4.16~12.5~~~false~~~~|1000.0~21.75~l~1~2.0~2.0~l~2~|:9~3~0.16~24.0~~~false~~~~|1000.0~21.75~l~1~2.0~2.0~l~2~|:16~4~0.0~~~~false~~~~|1000.0~21.75~l~1~2.0~2.0~l~2~|:2~5~951.3~6.4~~~false~~~~|1000.0~11.77~l~1~|:3~6~1269.02~5.1~~~false~~~~|5.0~213.66~l~1~4.9~2.56~l~2~4.6~19.5~l~3~|5.1~53.44~...
Read more

javascript - Checkbox in firefox extension -

-
i want place menu item extension has check. <menupopup id="menu_toolspopup"> <menuitem type="checkbox" label="convert" id="menu_toolspopupitem"/> </menupopup> overlay.js window.addeventlistener("load", function() {myextension.init()}, false); init: function() { window.addeventlistener("copy", function() {myextension.test()}, false); }, test: function (win) { var x= document.getelementbyid("menu_toolspopupitem"); //not null!!! alert(x)=> [object xulelement] alert(x.checked);//-> undefined } i don't state of menu item. and how save selection after restart browser? looks have access attribute -- there's no convenient property wrapper in case: [attribute] checked type: boolean indicates whether element checked or not. use hasattribute() determine whether attribute set instead of getattribute(). https://...
Read more