Forum: MS SQL  1 Day Ago |
| Replies: 3 Views: 99 Re: SQL SUM problem
And also that "unaltered" code went through some modification meanwhile, LOL |
| Forum: MS SQL 1 Day Ago |
| Replies: 3 Views: 99 Re: SQL SUM problem
hi,
there are some discrepancies:
1. What are PD.REFNO, PH1.BGROUP, PS1.REFNO ?
2. Is there a self-join: LEFT JOIN TableC LEFT JOIN TableC C ???
3. TableC of first left join doesn't... |
| Forum: MS SQL 2 Days Ago |
| Replies: 4 Views: 232 Re: Using UNION ALL to combine several queries
hello,
in union clause the column which should be ordered cannot be denoted by column name. Column to be ordered must be specified by its position number like in:
select a, b, c from... |
| Forum: MS SQL 4 Days Ago |
| Replies: 3 Views: 183 Re: Select Previous Row Values
Hello dmmckelv,
When Edgar Frank Codd invited relational databases his primary idea was to found it on
logic algebra and set theory. The rows of relational tables (aka relations) are sets.... |
| Forum: MySQL 4 Days Ago |
| Replies: 1 Views: 193 Re: select from multiple tables please help
Hi Finau,
If both following statements are true
1. Each table has a column named region_id of compatible data type
2. At least one of those tables has primary key region_id AND all other
tables... |
| Forum: Database Design 8 Days Ago |
| Replies: 5 Views: 333 |
| Forum: Database Design 9 Days Ago |
| Replies: 5 Views: 333 Re: Relational Database design question...
Hello,
in tbl_poems exists a transitive dependency poem-ID -> Author-ID -> Book-ID. Therefore, this table does not satisfy 3NF. fk Author-ID should be removed and inserted into tbl_Book. The result... |
| Forum: MySQL 10 Days Ago |
| Replies: 1 Views: 152 Re: SHA1 encription
So you want to decipher a 160 bit binary HSA1 string? Impossible! (except for hiring some Roadrunner doing brute-force decryption.) |
| Forum: MySQL 10 Days Ago |
| Replies: 1 Views: 324 Re: One-To-Many Relationship (adding data)
Hi
There is a function LAST_INSERT_ID() what returns the last-created auto-increment value. So first insert parent data what creates a new auto-increment ID. Then insert row in child table where... |
| Forum: MySQL 10 Days Ago |
| Replies: 4 Views: 378 Re: recursive query, category and parent_category
Hi jakesee
For better handling you need one root only. This can easily be done by defining a master root where all other roots can be formally connected to. Only this master root will not have a... |
| Forum: Database Design 11 Days Ago |
| Replies: 2 Views: 370 Re: Different DataBases for a Single Project
Hi rich_m
>>> My team( all freshers) are developing a project that will involve many Modules.
You must be "sophos ke moros" to carry out such database design successfully, which is every project's... |
| Forum: MySQL 11 Days Ago |
| Replies: 4 Views: 378 |
| Forum: MySQL 11 Days Ago |
| Replies: 11 Views: 627 Re: IF THEN statement would not work
hello kvdd,
there must be at least one space between END and IF in ENDIF: END IF;
If you omit the else part, you will get NULL , if condition is not satisfied.
I have checked your picture and... |
| Forum: MySQL 11 Days Ago |
| Replies: 1 Views: 325 Re: problem with group by (?) clause
Hello,
1. how come that in
>>> select temp.start, temp.end, temp.gene_name, min(temp.distance) as
>>> minimum_distance from (select start_bindsite, end_bindsite, gene_name,
>>>... |
| Forum: Oracle 11 Days Ago |
| Replies: 1 Views: 270 Re: DB Design Issues
Hi varun077,
Most of your questions including your several performance and maintenance issues will simply get solved if you (re-)design a true relational datamodel based on correct relationships... |
| Forum: MS SQL 12 Days Ago |
| Replies: 1 Views: 292 Re: How To get the 5th row from a table.
Hello guptaalok12,
When Edgar Frank Codd invited relational databases his primary idea was to found it on logic algebra and set theory. The Rows of relational tables (aka relations) are sets.... |
| Forum: MS SQL 12 Days Ago |
| Replies: 2 Views: 296 Re: Update the null values of a particular column
first do you first update, then:
update whattable set price = 5 where price IS NULL
From now onwards, all goods without price before will now cost 5 yourPriceUnit. Is this really correct?
krs,
tesu |
| Forum: MySQL 12 Days Ago |
| Replies: 4 Views: 351 Re: How can I speed up multi select query?
Hello elliaw,
Actually, this query is wrong! It should not work! Because of * (the sign of slackers) more than one column will be selected. Therefore, GROUP BY clause must contain more than as... |
| Forum: MS SQL 13 Days Ago |
| Replies: 4 Views: 218 Re: multiselecting UNLIKE values
hello,
You want to select some data from three tables. This will be done by two inner joins. If you don't tell which columns of the involved tables should be joined together the result will be... |
| Forum: MySQL 14 Days Ago |
| Replies: 3 Views: 222 |
| Forum: C++ 14 Days Ago |
| Replies: 1 Views: 111 Re: Binomial Queue Help
yeah, aaaaaand the ardently demanding question is what does that only mean:
>> merge function is not working at all ?
Any error message, divide by zero, memory fault, endless loops, computer on... |
| Forum: MySQL 14 Days Ago |
| Replies: 3 Views: 222 |
| Forum: C++ 15 Days Ago |
| Replies: 13 Views: 304 |
| Forum: MySQL 15 Days Ago |
| Replies: 11 Views: 627 Re: IF THEN statement would not work
Dear kvdd
Your IF - statement is again WRONG. Pls, look at syntax in post #6 again.
>> 2) returns:
2008-05-19 09:00:00
09:00:00
21:00:00
-12:00:00
.. and here more of course |
| Forum: Database Design 15 Days Ago |
| Replies: 3 Views: 289 |
| Forum: MySQL 15 Days Ago |
| Replies: 11 Views: 627 Re: IF THEN statement would not work
hi kvdd,
if statement is correct, also your case statement seams to be correct. You can put an else part to it to assign a value instead of getting NULL if if condition evaluates false. Two reasons... |
| Forum: MySQL 16 Days Ago |
| Replies: 11 Views: 627 |
| Forum: MS SQL 16 Days Ago |
| Replies: 1 Views: 262 Re: SQL Stumper
Hi qdaddyo
you may try this statement:
with
modi (tn, moda) as
(select ticket_number, min(modified_date) from tictac
where assignee <> 'NONE' group by ticket_number) , |
| Forum: Database Design 17 Days Ago |
| Replies: 8 Views: 600 Re: Database schema for a store
Hi Mad Pat
In the past all database engines of mysql didn't support any referential integrity by foreign keys. Today, only innodb is able to handle foreign keys correctly (of a kind). Yet my isam db... |
| Forum: MS SQL 18 Days Ago |
| Replies: 4 Views: 435 Re: Joining Tables Problem
Hello saisankar_p
Just another solution:
select s.SiteID, SiteName, s.StateID, PostCode, Phone1, StateName,
1 as canDelete
from tbl_site s, tbl_state a, tbl_user_site u, tbl_trial_site t
where... |
| Forum: MS SQL 18 Days Ago |
| Replies: 4 Views: 435 Re: Joining Tables Problem
Hello saisankar_p
Because of not having completely read your perfectly written post from begin to end, I presumed canDelete would already be part of one of your tables. I have to apologize to you... |
| Forum: Database Design 18 Days Ago |
| Replies: 8 Views: 600 Re: Database schema for a store
Hi Mad Pat
I am back again. It's really great that you are using open-office db. You know it's hsqldb, that famous pure Java database system what follows official SQL standard nearly completely. You... |
| Forum: Database Design 19 Days Ago |
| Replies: 8 Views: 600 Re: Database schema for a store
Hi,
sales and salesitems must be improved: Primary key of salesitems is and only is: (productID, salesID) and nothing else! productID is the primary key of products (you named it ID there),... |
| Forum: Database Design 19 Days Ago |
| Replies: 8 Views: 600 Re: Database schema for a store
Hello mad pat
You need a further table, name it salesitems, where its primary key must be formed from salesID and productID because of many-to-many relationship. Both are also foreign keys. Here... |
| Forum: MySQL 20 Days Ago |
| Replies: 3 Views: 618 Re: need help
Hi rupak
Stay your ground! Knowing as less as possible from that database protects one from becoming infested with badly base database concepts. Try to learn db2, firebird, oracle, postgresql, ms... |
| Forum: C++ 20 Days Ago |
| Replies: 4 Views: 232 |
| Forum: MS SQL 20 Days Ago |
| Replies: 4 Views: 435 Re: Joining Tables Problem
Hello
If your tables are properly designed simple inner joins will solve your problem:
select * tbl_site join tbl_state join tbl_trial_site join tbl_user_site.
Ok, this result set will contain... |
| Forum: Database Design 20 Days Ago |
| Replies: 1 Views: 294 Re: Help Understanding Constraints
Hi dakoris73
A constraint is kind of restriction usually to the range of values of a variable.
Given the following create-table statement we can detect several constraints:
create table raint(id... |
| Forum: MS SQL 21 Days Ago |
| Replies: 7 Views: 403 Re: Reverse lookup
Hello
That is true, because the IN list is kind of set, all records will be fetched that contain one of the list's element. So you can say the records are "ored" together in result set.
I assume... |
| Forum: C++ 22 Days Ago |
| Replies: 3 Views: 179 Re: Help with Data structures: Hash tables
Hello
depending on how many "grams" will be processed, that is eliminating duplicates, comparing two sets of "grams", hashing method is best method, it is of O(1). And compared with other searching... |
