sql server - Cast a "-" after a varchar string and then left join another table, sql -


i working in sql server visual management studio 2012. have 2 tables. table1 has 2 columns; partnumber varchar, , dateordered smalldatetime. table2 has 2 columns, partnumber varchar, , time float. part numbers on table1 9 digits long , looks '999999999.' table2 part numbers have "-" @ end , '999999999-.' need add "-" end of part number on table1 , cross reference number table2 , time column.

select right('9', cast(varchar, partnumber)) partnumber  table1     left join table2 on table1.partnumber = table2.partnumber  dateordered between ('2015-01-01 00:00:00.000') , ('2015-05-11 00:00:00.000')    , partnumber not null

-----------------update new code-----------

select table1.partnumber, table2.time table1 left join table2 on table2 + '-' = table1.partnumber dateordered not null

not quite sure question, not working?: 

table1.partnumber + '-' = table2.partnumber

(not elegant way of doing things)


Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more