sql - Determine correct column in dataset -



sql - Determine correct column in dataset -

i need remap info export. info beingness pulled multiple tables view.

in view pertinent columns , illustration values are:

size_bucket size_desc 2 xs 3 s 4 m 5 l 6 xl

size bucket corresponds column in table contains various size descriptions; example:

size02 size03 size04 size05 size06 xs s m l xl

the problem export, values of size_bucket wrong , don't correspond related sizexx column in other table. have table right mappings contain right values various sizexx columns.

what need determine column contains right value , switch out value of size_bucket right corresponding sizexx column.

so right values in mapping table have

size02 size03 size04 size05 size06 size07 xxs xs s m l xl

finally, here sample psuedo query i'm trying create right values size_bucket:

select case (u.sizebucket) when '1' u.sizebucket when '2' case when u.size_desc = k.size02 '2' end case when u.size_desc = k.size03 '3' end /* , on different sizexx columns */ when '3' /* repeat above code */ /* repeat when sizes */ end size_bucket, k.size_name, u.size_desc, k.size01, k.size02, k.size03, k.size04, k.size05, k.size06, k.size07, k.size08, k.size09, k.size10, k.size11, k.size12, k.size13, k.size14, k.size15 exportview u inner bring together size_map_table k on u.size_code = k.size_code

any suggestions or ideas on how in much simpler way appreciated. i'm not sure yet if way have in mind here work yet.

here info examples per request:

for view columns nvarchar, likewise in mapping table.

some sample info in view:

size_code size_desc size_bucket lds xs 3 lds s 4 lds m 5 ldn 0 2 ldn 2 3 ldn 4 4

in mapping table:

size_code size01 size02 size03 size04 size05 lds xs lds s lds m ldn 0 ldn 2 ldn 4

expected results right values size_bucket this:

size_code size_desc size_bucket lds xs 2 lds s 3 lds m 4 ldn 0 1 ldn 2 2 ldn 4 3

sql sql-server-2008

Comments

Post a Comment

Popular posts from this blog

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more

C++ 11 "class" keyword -

C++ 11 "class" keyword - i've started using c++ 11 little bit more , have few questions on special uses of class keyword. know it's used declare class, there's 2 instances have seen don't understand: method<class t>(); and class class_name *var; why precede typename keyword class in first example, , keyword pointer in sec example? that known elaborated type specifier , necessary when class name "shadowed" or "hidden" , need explicit. class t { }; // love of god don't t t; t t2; if compiler smart, give these warnings: main.cpp:15:5: error: must utilize 'class' tag refer type 't' in scope t t2; ^ class main.cpp:14:7: note: class 't' hidden non-type declaration of 't' here t t; ^ if class not defined, deed forwards declaration. for example: template <typename t> void method() { using type = typename t::value_type; } method...
Read more