Hello
I got child / parent tables as below.
MasterTable:
MasterID, Description
ChildTable
ChildID, MasterID, Description.
Using PIVOT / UNPIVOT how can i get result as below in single row.
if (MasterID : 1 got x child records)
MasterID, ChildID1, Description1, ChildID2, Description2....... ChildIDx, Descriptionx
Thanks
I'm trying to build a SQLCe table structure dynamically using a dataset as the temporary table structure...
Is there a SqlConnection string that will work with SqlCe?
There used to be a SqlCeConnection...but I don't find that in the 4.0 framework? Has something replaced this?
If the answer is L2S or Entity Framework...can I add columns to SqlCe tables at runtime?
If so...how?
I'm trying to enumerate the contents (feature classes and feature datasets, not interested in tables, etc) of a file geodatabase using vba/arcobjects.
I have the file GDB set as an IGxDatabase object, but can't find a way of getting further in. I've had a look at the geodatabase object model and tried using IFeatureClass and IFeatureDataset but neither seem to return useful results.
Thanks in advance for any assistance
Hi Guys,
I've got two tables (items / tags). Item has and belongs to many tags - tag has and belongs to many items.
It's no problem for me to fetch all related tags like:
$item = ORM::factory('item', 4);
foreach($item->tags as $tag){....}
But how can i fetch only one... and maybe a specific one?
Thanks in advance!
Hey guys, please recommend some tools you have used succesfully on DW, DataMart, BI an non-relational modeling.
Example for automatic creation of snow-flake Schemas, dimensions and facts tables.
Wich tools makes you sense familiarity with the diagrams and surrogates keys and it will have the option for export or connect to SQL Server 2008.
Thanks
Hi,
I am having issues setting the calendar font sizes to be smaller. I have changed setting a container div font size, no effect. I have also changed the fullCalender.css font from 1em to 0.5em and to a px size but the calendar text stays the same.
Is there anything obvious I am missing, sorry to post if this is very obvious but I have searched for hours and I have tried so many things to set this.
Thanks
Dkn
Hey guys,
I got 2 tables in my database: user and call. User exists of 3 fields: id, name, number and call : id, 'source', 'destination', 'referred', date.
I need to monitor calls in my app. The 3 ' ' fields above are actually userid numbers.
now i'm wondering, can i make those 3 field foreign key elements of the id-field in table user?
Thanks in advance...
STRAGG function implemention returns a result as a single column value. Implementation for Oracle seems pretty generic and can be consumed for different tables (and relationships). Could similar behavior be achieved for SQL Server. A search in the web, appears to return only hard coded implementations and not a generic one. Do we have any known solution for Sql server?
I have two tables -- Variables (id, name) and Variable_Entries (id, var_id, value). I want each variable to have a unique set of entries. If I make the value entry unique then a different variable won't be able to have that same value which is not right. Is there some way to make the value column unique for identical var_id's?
I am looking for a way to test/validate my html, css, js before they are committed to a repository.
Is there any way to automate this process. Ideally, I would like to have the ability to exclude certain files (js libraries for example).
I want to use YUI Compressor (the original) and use it as part of typical MS build processes (Visual Studio 2008, MSBuild).
Does anyone have any guidance or thoughts on this? For example, good ways for incorporating into project, what to do with existing CSS and JS references, and the like.
I am happy to hear on the benefits of YUI Compressor .NET and alternatives but I'm mor einterested in use of the original.
Thanks
Scott
I have an invoice that contains over 100 lines of product that I am trying to print. This single invoice should take over 3 pages, but when printed, the content flows off the footer and the next page is the following invoice.
I am using divs instead of tables, and I can't understand why the long invoices will not print on multiple pages.
Any ideas?
I have the following 2 tables in MySQL:
Customer(Id, Firstname, Lastname...)
Bonus(Id, CustomerId, Value, ...)
The relation is One-To-One, every customer has only one bonus.(the CustomerId is unique in the Bonus Table)
Q: Should I drop the Id column of the Bonus table?
(I want to know why or why not)
Does anyone know of where future features of SSRS are listed?
I found a page that describes the features that are released with SS2K8 R2 but they don't solve the main problem I have porting our Excel reports to SSRS which is vertical merging (plus rotated text to go in those cells) and horizontal tables.
I would like to be able to tell my angry users if/when they will be available...
in symfony 2.0 and django there are bundles that contain everything for a feature (html, css, js, img, php/python).
so if you want to delete one feature, you basically just delete that bundle and unregister it from "main".
are there java frameworks for this too? or is it different in java cause java is a compiling language.
thanks
Hi guys,
I have two SQL Server 2008 databases called Anna and Bob.
Bob has to pull and transform data from Anna to keep updated
his tables.
Ideally Bob will be
always synchronized with Anna,
but some delay would be acceptable.
What is the best way to do this?
Thanks in advance.
Is there a Class Map generator for Fluent NHibernate? I need something like db2hbm but I want it to generate Fluent Class Maps instead of xml mappings.
I am aware of AutoMapping for Fluent but that is not what I want. I want to be able to generate Class Map files from tables in database and push them to my src repository.
To continue to question further I'm more interested in blogs, websites who once in a while release a tutorial, tip or best-practice on the topics I mentioned. For ex :
http://net.tutsplus.com/ is very good website to follow if you wanna learn about or upgrade your knowledge about CSS, HTML, Javascript, PHP .. Is there a website like this for Java and related technologies?
Hi,
Is there anyway to wrap a TextView around an image?
It's the typical thing that people do in CSS like this http://www.echoecho.com/htmlimages08.htm
Thanks,
Tee
Hello,
I need to add documentation to all fields of 2 databases (1 postgresql & 1 sql server), around 100 tables each.
What tool would be convenient to do that (reverse the schema + add documentation manually on all fields) ?
My favors would go to an open source tool with a graphical & xml output.
Thanks for your help
Jerome WAGNER
I added the following code to my .vimrc:
" save and restore folds when a file is closed and re-opened
autocmd BufWinLeave *.* mkview
autocmd BufWinEnter *.* silent loadview
HTML and CSS documents save and restore their folds but code folding is not being saved in my .vimrc
Any suggestions?
EDIT:
The following code solves the problem:
au BufWinLeave ?* mkview
au BufWinEnter ?* silent loadview
but if I write it, the MRU files disappear from my list (and I have to open MRU twice in order to see my list of recent files why?)