Search results for query: *

I am a newbie in Oracle. I just want to do a simple sql script, but it drives me insane. Can someone help me? I have two tasks for this stored procedure: 1) My purpose for the Oracle sp procedure is to create a column that is exact same as the column, "as_of" in SQL version which is a...

Hi, I need two tables for the result. I can do it in three queries in Access, but I really don't know what should I do in SQL Server. I hope someone can guide me since I have so many queries that I need to convert from Access to SQL. Thank You. TableA Name|Subject|Course|Sort|Mark Row1...

Hi, I current have a request from users that they want to see when and who was the last updated on a record(s) on a table (I used Access form to display data for users). The database is in SQL Server 2005 and I am using Access the front end. I have no clue what should I do to show who/when...

Hi, I have a table, tbl_A Column1,Column2,Column3 AA 100 0 BB 100 0 CC 0 0 DD 0 100 EE 100 0 EE 0 500 In Access, I can use IIF to figure this out by using this syntax, Column_Sum: SUM(IIF(tbl_A.Column2 <> 0 ,1...

Hi, I found the following codes online for disable/enable the Shift Key in Access. The Command Button works great with the right password. However, the module doesn't work which mean when I press and hold down Shift Key, I can still see the Start-Up options. Can anyone help me to solve this...

Hi, I hope someone can help me to solve the problem about the Language bar in Access forms. I recently take over an international project that needs to data entry other language beside English. Therefore, I turned on the Language bar with the IME on so I can start using hand recognition...

Hi, I set up the Transactional Replication on a database that is between two physical servers. Server A (SQL Server 2005) is the distributer and a Publisher. Server B (SQL Server 2000) is the Subscriber. I only set up the articles in "Tables" which I understand the "View" is not capable in...

Hi, I have an Access 2003 form(s) that tide to Sql Server 2005's tables. I would like to know is there possible for an user who open the form and typed in the User ID & Password, then either Microsoft Access or SQL Server can automatically identify the user's corresponding data only. I have...

I beleive this is the problem for the server(s) but it only happens to the Sql 2000 & the distributer Sql 2005 server which I think it is interesting and I would like to share this and hopefully an expert can solve this problem for me. I have 3 servers, A: Win2003, SQL Server 2005...

The SQL Server 2005/Window Server 2003 server box has hard drive failure, so I ended up buying a new hard drive to replace. I have daily backup tape using the 3rd party backup application ~ Novastor in the old box with No Errors. I restored the whole backup tape into the SQL Server 2005...

Hi, I followed all the steps from the MSDN book to do the replication in SQL Server 2005 I had no problem created the Publications. I checked the Launch Replication Monitor, the Agent History said the Status is completed. Therefore, I followed the instruction and continued creating the New...

Hi, The box is running Win 2003 and SQL Server 2005. I have a transaction log file in a disk D and the main data is in disk C. I had the Data (Primary in 160MB, by 1MB, unrestricted growth in path C; Log, 25 MB, by 10 percent, restricted growth in path D) I tried to use DBCC Shrinkfile and...

Hi, I created a custom toolbar that is filtering record(s) for a particular form in Access 2007 database that included Filter By Selection, Advanced Filter/Sort, Apply Filter/Sort, Remove Filter/Sort. Some of the users can use the toolbar 100% in the form but some can not. For instance...

Hi, I don't know is it possible or not. My users always lie to me about the database is not working and bla bla. They always claim the database didn't save their works, so they lost data. I am speechless because I can't find the evident. I would like to know is there method(s)in the SQL...

Hi, I have the SQL SERVE 2005 Standard Edition installed in my Window Server 2003 box. I started to learn the new SSIS project. However, when I follow this, All Programs/SQL Server 2005/Select Business Intelligent Development Studio THEN File/New/New Project Option, I don't see the option...

Hi, I have a query in Access and I am trying to put it into the View in SQL 2005, is it workable? Access, SELECT Field1, Field2, IIF(Field3>Field4,Field3, Field4) As Field5 FROM TableName1 Group BY Field1, Field2, IIF(Field3>Field4), Field3, Field4) In SQL, it keeps having an error. SELECT...

Hi, I have a DTS in SQL Server 2000 that truncated the table in SQL 2000 and Select * from a table in Access then import into the table. It works no problem in the DTS section. However, when I schedule the DTS that run every night, it had an error and said it couldn't find the Access table...

We recently convert 2 different boxes's SQL Server from SQL 2000 to 2005 standard version with Window 2003. I tried to do the Replication from one box to another. However, I don't see any movement from one box to another, but I see the snapshot folder created. I had the Local Publication...

I used DataSource to retrieve data from SQL Store Procedure, I had no problem viewing the data, but when I tried to edit the data, it said the "Updating is not supported by ObjectDataSource unless the UpdateMethod is specified". I specified it manually in the source code. I don't know what's...

Hi, I am working on a page A that has 2 drop down lists and a gridview and another page B with the detail information. This is what I want to show on page A; when a user choose drop down list 1, the drop down list 2 will show the correspond information from drop down list 1. Then, the...