pclfw

I have about 6 books on PHP, all used while learning and using PHP for web development. Two sitting at my right hand now are "SAMS - PHP5 Unleashed" (£35.99) and "Advanced PHP Programming" (36.50) I also use the online PHP manual though I found the books better for picking …

Now that is quite a good question. Does the data about the stock belong (totally) to the book itself? Or is the concept of STOCK a seperate item? The data could go in a number of places, but how and when is it going to be used. The NUMBER_IN_STOCK is …

Normalization is actually fairly simple. To convert data from one form to another you apply a single, simple, rule to that data. To move to the next level of normalization apply the next rule etc. etc. See [url]http://en.wikipedia.org/wiki/Database_normalization[/url]. So examine your data and see if it conforms to these rules. …

Originally I thought that this was in the wrong forum. But I was wrong. Your query regarding the foreign key violations should be fairly trivial if you trace back through all of the tables ensuring that the correct data is in place BEFORE you try to insert the CAR row. …

To answer a quick question, I cannot understand why you think that you need to de-normalise the data. An ERD is (or should be) created BEFORE the database. The DB definitions are based upon the ERD and thus the original ERD (or a very close approximation thereof) can be logically …

Let me get this straight. You're a TECHNOPHOBE doing a DEGREE course with a large COMPUTING involvement and you want US (who are TECHNOPHILES and [mostly] have finished our degrees) to do this work for you. Is that correct? If the answer to the above is YES and this is …

I agree with Ramy. The way your question is worded the only answer we can give is MAYBE. :)

I don't think that you've actually asked the right question. The answer to the question that you have asked is "What ever you want to."

I think that it needs to be pointed out here that the MASTER database should NEVER be used to hold user entities. Niether sould ANY of the other SYSTEM databases (MSDB, TEMPDB). MS often changes items within the system databases and would not hesitate to overwrite (or more likely crash …

Ramy, I tried this and it does not run. You cannot just concatonate local variables and literals and expect them to combine into another literal. The best that you could do is to set a char / varchar variable to the whole sql string that you want to run and …

I can see why there is confusion about what you want from your data and precisely what is in the tables. Possibly a different way of looking at the data could be - [code=sql] SELECT SOURCE.BG_ERROR_ID, SOURCE.BG_USER_03 AS HardwareID, count (SOURCE.CY_RUN_ID) AS NumAffected, sum (SOURCE.Passed) AS Passed, sum (SOURCE.Failed) AS …

You might like to have a look at MSSQLs MAKEWEBTASK function. Using this you can create the whole MySQL insert code for each table. It could save you the bother of having to reprocess the data from CSV tables.

No DON'T do it! Become a plumber instead. Then your customers will be pleased to see you, the pay is better and the dirtiest things that you have to deal with come crawling out of the sewers. MUCH cleaner & more honest than a career in IT. I cannot remember …

tuukie, The syntax for the update statement is incorrect. Have a look in BOL to find the correct statement syntax. You have the right idea with the [DB_Name].[dbo].table_name. I have used this technique a number of times.

There are a number of areas to look at here. 1) Check the execution time of the SQL code in a query window. If the time is large look at providing indexes to speed up the query. 2) When you have optimised the SQL then check if the PHP code …

This is going to be very difficult to do as you do not give any user requirements. MS Access has sample templates which, I believe, provide an attendance monitoring DB and a material (asset?) management DB.

And have a word with the company solicitor with regard to prosecuting the previous database manager under the computer misuse act.

From a SQL client point of view there is very little difference. The management side is completely changed. The Data Transformation Service (DTS) system has been replaces by the SQL System Integration Service (SSIS). The GUI management system is much more integrated now with the functionality of both Enterprise Manager …

Off hand I am not sure that you should be doing this type of data passing with javascript source files. However [B]IF[/B] this works then the changes below should help. You need to pass the required variable data in the URL as you are already doing with the 'P' variable. …

While this technique is cheating I have used it to good advantage a number of times. Create a table html layout for the page image that you want. Do NOT use CSS inline style commands are OK. Save the innerHTML of the table created in a file with a '.xls' …

American Football - NO! The cheerleaders though WTF! Tack a bunch of barely dressed school / college girls from MIAMI (where the locals freeze when the temperature falls below 70F), then bring them to LONDON (where the locals die of heat exhaustion when water melts). It's a wonder that they …

RFID tags sound great until you have a look at their weak points. Current tags, 1sqm in size are great, get a metalic plastic bag and they sit inside waiting to be activated as you walk through the detectors. Has happened here in the UK. Future tags well think of …

Isn't that how we all started off? :cheesy:

Well where to start. Your query may work but it is dificult to check without all of the other stuff around it (tables, data, stuff like that). To check the code I expanded it to use a UNION ALL and split the command into a query that deals with the …

Well you are going to have fun with this one. 1) Only use NOT NULL when there MUST be an entry in a field. People are not yet forced to have email addresses, even in the USA. 2) You don't need a foreign key reference on the job title table. …

In cases like this I find that having a look at the SQL code generated for the table will often turn up some remarkable facts about the table / column in question. To get this code go into enterprise manager, open the relevant database, open the table list, right click …

Sounds like work for a stored procedure. The problem being that the easiest way to do this is to have a sub-query select the documents grouped on the parentfolder and documentnumber, and use a 'TOP X' qualifier. Then have the main select query use the output of the subquery with …

This query depends upon the format that the time is stored in. MS SQL doesn't have a TIME data type.The DATETIME format can store both dates and times (obviously). The next point is that you cannot just subtract one DATETIME from another. You have to use DATEDIFF. So, asuming that …