Sp

how can return values of mainemail in query below, delimited commas , still count mdcselect? declare @mainhospital varchar(50)='hospital 1' select distinct mainhospital , f.item, count(*) count surveypiclist s cross apply splitstrings(s.mdcselect,':') f mainhospital = @mainhospital group mainhospital, f.item order count desc to clear above returns this: http://i.imgur.com/f1opu6p.jpg so there 3 separate entries/people selected "02-eye". want list out emails(mainemail) comma delimited. please let me know if unclear. assuming use of cross apply using sql server, , @ least version 2005, can use xml concatenation follows: declare @mainhospital varchar(50)='hospital 1'; select mainhospital , f.item, count(*) count ,stuff( (select distinct ', ' + m.mainemail surveypiclist m m.mainhospital = @mainhospital , ':' + m.mdcselect + ':'...

i have made delete/clear button works, after using cannot make new search...i have refresh button doesn't work @ all. want able make ned search , thought use refresh button this. can me? if can, please explain me example. private void button_click(object sender, routedeventargs e) { datagridtest.itemssource = null; } private void refresh_click(object sender, routedeventargs e) { datagridtest.items.refresh(); } there's part of code need see can able help. if working wpf, wpf awesome mvvm design pattern. you can check start here . josh smith's tutorial best tutorial mvvm.

i using collection.disjoint find disjoint set of 2 string collections c1, c2. not ignore cases, example - string str different str . return collections.disjoint(c1, c2); can find disjoint of both collections ignoring cases without using loop? if absolutely insist no for loop used, can find disjoint between 2 collection s of lowercased string s. using google guava , should like: package ru.zombator.stackoverflow; import java.util.arrays; import java.util.collection; import java.util.collections; import java.util.locale; import com.google.common.base.function; import com.google.common.collect.collections2; public final class disjointignorecase { public static void main(string[] args) { collection<string> coll1 = arrays.aslist("donald", "duck"); collection<string> coll2 = arrays.aslist("donald", "donut"); collection<string> coll3 = arrays.aslist("homer", "donut...

been working on systematic file search script retrieve name of documents in directory, , sub directories contain determined search string. essentially, log search results. nice have search file names, that's not yet important. code: @echo off echo - search files in current directory, , subdirectories. echo - ignore case sensitivity. echo - search term within readable documents. set /p searchfilter=search filter: set results=%cd%\results.txt echo searching... echo results: > "%results%" /f "usebackq tokens=*" %%i in (`dir /s/b/a:-d/o:e`) ( find /i "%searchfilter%" "%%~nxi" >nul && echo %%~nxi >> "%results%" ) echo search complete. pause run-down: system requests string user. then, system saves handle results file (thought fix problem, didn't). system filters files, excluding folders, directory, , sub directories, printing bare name of file (with extension), proceed scan each file search string, ...

i searching highly stable way feed text (output of program) vim through vimserver. assume have started (g)vim session gvim --servername vim myfile . file myfile contains (unique) line out: marks position text should pasted. can straight forwardly achieve commandline vim --servername vim --remote-send ':%s/out:/text\\rout:/<enter>' . can repeatedly feed more text using same command. inside c-program can execute system() . text dynamic , arbitrary (received stream in c-program) needs passed on command line , hence needs escaped. furthermore using replacement command %s vim jump position text inserted. find way paste large chunks of arbitrary text seamlessly in vim. idea have vim read posix pipe :r pipe , write the string within c-program pipe. ideally solution such can continuously edit same file manually without noting output added @ out: long location outside visible area. the purpose of text feed create command line based front end scripting languages. block...

i'm using woocommerce theme called "mystyles", til every change i've made in custom.css file has worked, reason today no matter change make isn't working! i've edited css of site within browser using devtools chrome , it's worked once upload actual website reverts old css few days ago. don't understand! i've tried uploading both ftp , in-wordpress editor, double checked make sure changes uploaded re-downloading file , found nothing wrong. checked in different browsers, cleared caches, it's driving me insane. ideas? website www.bettinasboutique.com it's in process of being set (if can figure poop out). have of had problem wordpress not accepting changes css? i've tried making changes html files, text in nav bars spot causing me trouble, , it's worked fine! it's css. i've tried uploading custom css original stylesheet file instead of custom css file , still reads old nav styles. please help!

i searched here , on big g, willing learn, didn't found answer yet. i trying transform external xml data xslt read in html or php. tested few things , transformed simple xml files xsl , php. problem actual xml files need use not typical dot xml files see, more format " http://webservices.nextbus.com/service/publicxmlfeed?command=vehiclelocations&a=sf-muni&r=14&t=0 ". when use these addresses, seems read these files , xsl stylesheet, parse correct numbers of table cells, return them empty. what's wrong? also, can related xml formatting used external site? noticed xml more "xhtml styled" rather other files seen in past. their style using 1 big tag , closed slash: <vehicle id="5464" routetag="14" dirtag="14_ib2" lat="37.7637" lon="-122.4087" secssincereport="86" predictable="true" heading="218" speedkmhr="0"/> the same example, if writting...