Search results for query: *

Thanks and that is helpful. Personal blog: The Code Blog

Golom, Thanks. Do you have a link to a good description and usage examples of 'OR' with parentheses? This is a bit of a confusing one and I want to make sure this is very clear in my SQL post. Personal blog: The Code Blog

Also in Oracle SQL you can do a similar table creation like this: CREATE TABLE newTable AS SELECT column_list FROM table; Personal blog: The Code Blog

Golom, Thanks for the corrections. I fixed these now. Personal blog: The Code Blog

SELECT * INTO sometable FROM someothertable works in SQL Server as well as MS Access SQL view. Doesn't work in Oracle SQL though where you must create the table before inserting records into it. Personal blog: The Code Blog

Golom, thanks for the detailed tips and I fixed these points in my blog! Personal blog: The Code Blog

After researching this a bit further I found out that the cause of the database file not shrinking was due to having another computer with an open SQL Query window open. Having open connections to the database prevented the database action from being performed. Personal blog: The Code Blog

Ok, so I've freed up 50GB of space in my database and even after running dbcc shrinkfile (dbname,30000) the database file still does not shrink! In properties of the database in Enterprise Mgr it shows I have these 50GB of unused space. How do I get the DB to actually shrink so I can back it...

I have an MDF file that is 109GB. I only have 89GB of free disk space. My attempted backup fails with a "not enough disk space" error. Does anyone now what the average disk space required for a backup is? That is what percentage of the MDF file? 100%, 75%, etc. I am struggling to make...

Ahh...I see what you mean --- GROUP BY does not the COUNT keyword. Thanks for the correction. I fixed this on the Blog post. Personal blog: The Code Blog

Check this out: SELECT column1, COUNT(1) FROM table WHERE criteria GROUP BY column1 HAVING COUNT(1) > 5; Give that a try... Personal blog: The Code Blog

If you need to freshen up your basics on SQL or if you need to train a new employee on a gradient approach to SQL, here is a good introduction and tutorial. An SQL Introduction Personal blog: The Code Blog

Thanks Zameer. I tried going to view/Sorting and Grouping and found that I had a "held down 7" - there was a hard coded sort set up on the report, so any freshly coded sorts being added to the Order By property were being overrided by this Sort Setting.

I've spent several hours trying to debug an Access Report that is set with VBA to sort the records based on a combo box from another form. The Report's "Order By" Property does get updated but the displayed data is not sorted. The "Order By On" property is set to "Yes". The Record Source is a...