How to get multiresult with multicondition in Sql Server -


i need solve this.

hopefully can giving me advices.

for sample, i've got data :

                            proclib.march                                1                           first 10 rows    flight     date  depart  orig  dest     miles   boarded  capacity   -----------------------------------------------------------------   114     01mar94    7:10  lga   lax       2475       172       210   202     01mar94   10:43  lga   ord        740       151       210   219     01mar94    9:31  lga   lon       3442       198       250   622     01mar94   12:19  lga   fra       3857       207       250   132     01mar94   15:35  lga   yyz        366       115       178   271     01mar94   13:17  lga   par       3635       138       250   302     01mar94   20:22  lga          229       105       180   114     02mar94    7:10  lga   lax       2475       119       210   202     02mar94   10:43  lga   ord        740       120       210   219     02mar94    9:31  lga   lon       3442       147       250

and have condition ('lax,ord'), 'lax','lon','yyz',('par,lon,fra'),'fra' ...and else

what should data show report condition in sql?

parameter made is

 dest @dest -> (from table condition(('lax, ord'), 'lax','lon',('par,lon,fra'),'fra',..etc)) +'%'   , date @date + '%'   , depart @depart + '%'

if choose 'lax' @dest, 'lax' show

if choose 'lax,ord' @dest, 'lax' , 'ord' show

please need help, advice , suggestion this.

thanks

if @dest value 'lax,ord', 1 query solve solution is

 select *  proclib.march  dest in ('lax','ord')

to parameterise that, need become table.

 dest  ====  lax  ord

and query becomes

 select *       proclib.march  dest in (select dest @desttable)

if want pass @dest string parameter, need split somehow table. search sql split function give number of options.

if query encapsulated in stored procedure, better method pass values table valued parameter. see http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/


Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more