Search results for query: *

Thanks very much. The whole document made me go o_O but I thought perhaps I had just missed a whole chunk of my education :) It is no doubt a highly classified document, and me posting it on the Internet would be frowned upon :( How does this grab you? I am not sure I understand it :( "•...

I have been asked to comment on a table structure that a contractor wants to use the structure is as follows Columns must be listed in the following order: Primary Keys NUMBER, not null (shortest to longest) DATE, not null VARCHAR, not null (shortest to longest) NUMBER, nullable (shortest to...

Sex is of course in the bird table, sorry if that was not clear. There are 12 bits of info for both sexes, an extra 14 for males, and only an extra one bit for females. I see the point of the simpler one table solution I think that that may be the way I go. Certainly for this disc space is...

I had envisioned it, Bird 1-many RandomData RandomData 1-1 maleData RandomData 1-1 femaleData I think flipping it as you suggested would make it unnecessarily opaque and queries a little too complex... I need to keep things simple for my poor brain! A good thought though and one that had not...

I am designing a databse and have a question about my design. If there is a better forum for this then can you point it out to me :) I am writing the database in SQLServer, but it is a non-specific question I have. Ok so here is the question. The database is to store some information about...

I am not sure if I have this right but you could try setting the imagebuttons "commandname" to something sensible. Then in the outer datagrid raise the _ItemCommand and do your find control in there Protected Sub myDataGrid_ItemCommand(ByVal source As Object, ByVal e As...

Well I may be being stupid but I cannot see how to get it to copy the keys... certainly no "Copy keys?" checkbox! Could I ask you to have a quick look to see how you would do it? Thanks...

Sorry had my inarticulate hat on! I mean the relationships between tables, Primary keys, Foreign keys, that sort of thing. Thanks for asking for clarification and not just moving on to the next thread!

I have a need (expect to see it on dailywtf soon!) to export a database OUT of SQLServer INTO Access. However when I use the DTS export wizard it gets tables and data but loses the join information. Is there a way of keeping the structure as well as the tables/data? Thanks Fr

Thank you both for your time. Carlen has elucidated the final structure I had in mind... I think my difficulty was with the "simple pivot lookup and some joins"! I am NOT a whizz in excel but I will head off with Google and see what I can come up with! if you have any further hints I am all...

I have some data like so ID name Thing1 thing2 thing3 other 1 bob 0 0 1 <null> 2 fish 0 1 0 <null> 3 Steve 1 0 1 <null> 4 Holmes 0 0 0 thing4 I would like to import this into my db to get a look up table of...