Search results for query: *

Thanks you both for your input. SQLSister: My SQL knowledge is limited, so please let me know if I am missing something; but the problem here is I would end up with a limited number of records in total, wouldn't I? - say 5 for the whole query return. What I need is 5 records returned for each...

Hi I am developing a SQL database that will sync with handhelds used to collect data in the field. This will be a two way sync, as I want all handhelds to hold previous data, so the handhelds can run statistical analysis on new data, before excepting. This is ok, but I want to limit the data...

Thanks Ibass, I worked out the problem though, the crosstab was originally targeting the VALUE stored as a TEXT column, rather than the identical value from the NUMERICAL column. (i don't know if this is a normal way to design a large database, but it is what i have to work with). So, I...

Hi, Does anyone know how to change the decial point place, for crosstabs? By defult all values that are whole do not have any decimal place, but we need to change this to two. Example (current): ID CH4% 1 2.1 2 0 3 6.73 Example (needed): ID CH4% 1 2.10 2 0.00 3 6.73...

Hello This is my first time using this site, so apologies for any ignorance. I have been set the task of updating a report that links to an sql database. The table i link to has a 'comments' field, that has to hold an array of 'comment IDs' I need to link this array of 'comment IDs' to a...