sql server - Creating dynamic view? -

-

i working in database stores park information in table. table lists park names , components of parks , ids of component types. below...

"parkname", "componentname", "componentid", "componenttypeid" -------------------------------------------------------------- smith park, north slide, 1, 12 smith park, south slide, 2, 12 smith park, swing set a, 3, 14 smith park, swing set b, 4, 14 adams park, east slide, 5, 12 adams park, west slide, 6, 12 adams park, swing set a, 7, 14 adams park, swing set b, 8, 14 adams park, sandbox a, 9, 15 adams park, sandbox b, 10, 15

the attributes of each component type stored in own table following...

dbo.attributes_12 dbo.attributes_14 dbo.attributes_15

the attributes in each table different, have 4 common fields - "componentname", "componentid", "year constructed" , "comments"

i did not create database, i'd able create view lists each park components , attributes of each component. like

"parkname", "componentname", "componentid", "componenttypeid", "year constructed", "comment" smith park, north slide, 1, 12, 1999, 'slide comment 1' smith park, south slide, 2, 12, 1999, 'slide comment 2' smith park, swing set a, 3, 14, 2006, 'swing set comment 1' smith park, swing set b, 4, 14, 2008, 'swing set comment 2' adams park, east slide, 5, 12, 2006, 'needs repair' adams park, west slide, 6, 12, 2004, 'ladder broken' adams park, swing set a, 7, 14, 2009, 'in shape' adams park, swing set b, 8, 14, 2010, 'chain needs replacing' adams park, sandbox a, 9, 15, 2001, 'needs new sand' adams park, sandbox b, 10, 15, 2002, 'in shape'

is there "dynamic" way this?

what i'm struggling how join various attribute tables without manually adding them (ie through sort of sql code). there can many types of components in park beyond swing sets , slides (ie lights, benches, ponds, ornamental trees, garbage cans, signs, etc) , manually adding attribute tables view become cumbersome , not efficient if new type of component added.

i'm hoping can provide suggestions, maybe i'm trying isn't possible.

carl


Comments

Post a Comment

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

-
i getting error message , further 1 here: failed read artifact descriptor org.apache.maven.plugins:maven-install-plugin:jar:2.4: even though when go .m2 repository path c:\users\a591024.m2\repository\org\apache\maven\plugins\maven-resources-plugin\2.4 the maven-resources-plugin-2.4.jar file there , maven-resources-plugin-2.4.pom there. have tried delete .m2 repository no luck. far maven not build project desperately need to. any ideas? it seems proxy issue please aad following in setting.xml grabbing lan setting , proxy information. <proxies> <proxy> <id>proxy</id> <active>true</active> <protocol>http</protocol> <host>hostname</host> <port>port</port> </proxy> </proxies> this frequent issue, please see below link well. plugin org.apache.maven.plugins:maven-clean-plugin:2.5 or 1 of dependencies not resolved maven: failed ret...
Read more

Round ImageView Android -

-
Image
i working on android application in doing rounded image view. working fine images, images 160x120 resolution shows oval shaped. code custom imageview given below, please me out here: public class roundimage extends drawable { private final bitmap mbitmap; private final paint mpaint; private final rectf mrectf; private final int mbitmapwidth; private final int mbitmapheight; public roundimage(bitmap bitmap) { mbitmap = bitmap; mrectf = new rectf(); mpaint = new paint(); mpaint.setantialias(true); mpaint.setdither(true); final bitmapshader shader = new bitmapshader(bitmap, shader.tilemode.clamp, shader.tilemode.clamp); mpaint.setshader(shader); mbitmapwidth = mbitmap.getwidth(); mbitmapheight = mbitmap.getheight(); } @override public void draw(canvas canvas) { canvas.drawoval(mrectf, mpaint); } @override protected void onboundschange(rect bound...
Read more

java - Unable to make sub reports with Jasper -

-
i using jaspersoft studio create reports. having sub report in jasper main report. problem unable make work, because if add sub report detail band of main report, sub report generated number of times, row row, entire sub report repeated in number of pages. can't put in summery band due same reason. i unable put in column footer band or other footers because displays below error net.sf.jasperreports.engine.jrexception: net.sf.jasperreports.engine.jrruntimeexception: subreport overflowed on band not support overflow. @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.fillreport(reportcontroler.java:467) @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler.access$18(reportcontroler.java:442) @ com.jaspersoft.studio.editor.preview.view.control.reportcontroler$4.run(reportcontroler.java:334) @ org.eclipse.core.internal.jobs.worker.run(worker.java:54) caused by: net.sf.jasperreports.engine.jrruntimeexception: subreport overflowe...
Read more