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

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

vb.net - Virtual Keyboard commands -

i wondering difference between virtual these keyboard commands is: keyeventf_extendedkey , keyeventf_keyup is. everywhere have looked gives me description based off integers , not want know each of them does. you've tagged question vb.net, these have nothing @ vb.net. they're constants defined in windows header files, use win32 api functions. as far difference, can't tell looking @ values. individual values not particularly important, that's why named identifiers used. what's important used , documentation functions tells mean. the first one, keyeventf_extendedkey , used keybdinput structure (which used along e.g. sendinput function) pass information synthesized keyboard input. if flag used, means scan code should interpreted extended key. technically, means scan code preceded prefix byte value 224 (&he0 in hexadecimal notation). the second one, keyeventf_keyup , 1 of flags available use structure. means key being released (going up)...
Read more

css - Firefox for ubuntu renders wrong colors -

Image
i've got following problem: i'm developing website, while testing around i've noticed firefox , chromium display css bar in different colors. when switched between several machine come conclusion firefox ubuntu problem. on other devices i've tested website. it's fine. the differences between chrome , firefox rendering: firefox: chromium: note: firefox ubuntu problem. does knows why , came solution? https://bugzilla.mozilla.org/show_bug.cgi?id=655637 bug 629312 - firefox displays wrong colors on image (only linux) open about:config , rechange gfx.color_management.mode 2 0.
Read more