Search results for query: *

Does anyone know if moving directories and files from a JFS file system to a JFS2 file system and back is safe? Using AIX 5.1.0.3.

Just wondering if anyone has ever had this problem...I've been using Groupwise for several years and have always had my meetings and appointments give me a dialog box reminder prior to the meeting. For some reason, this has suddenly just stopped. I have checked all my options and anything...

I just figured this out today. Try this: INSERT INTO OPENQUERY(rftest1, 'SELECT field1, field2, fieldN FROM aqua.aqua.itin) SELECT field1, field2, fieldN FROM sqlTable WHERE ...continue WHERE clause....

I am currently using Crystal Reports 9.2.0 I have set up a report to use an OLE DB for SQL Server Connection. I cannot seem to get it to save the password. Thus, everytime I want to run the report, it prompts for a password. In Crystal 8.5, in the Database Connection SetUp Dialog Box, there...

The first index on a view must be unique and clustered.

I have a view into a single table in which I've added some fields to the view that are derived from combinations of other fields. That's the reason why I created the view. Most of these derived fields are caclulated financial data, but one field is just an identifier that is manipulated...

OK, figured it out. You get an 'Arithmetic overflow' error.

wee what happens?

I haven't been able to find this answer in books, but what would happen if you tried to insert into a table that has an identity field and the field is at max integer?

Thank-you r937. I take it that "foo" is just some arbitray name that TSQL needs to execute the command?

I want to be able to retrieve the number of distinct rows in a table using multiple fields as the criteria for the Distinct keyword. SELECT DISTINCT field1, field2, field3 FROM Table1 ...gives a row listing of each distinct combination of field1, field2, and field3. But what I want is just...

I am having trouble figuring out how to group by only a subset of the fields in a SELECT statement. Given this table: PersonID Dept EmplType Location Bonus 1 IT Manager A 10,000 5 HR Admin B 20,000 9 HR...