Search results for query: *

Great, it works great after I copy and paste the exact code below. I didn't know I need to include the "/" at the end. Thanks for Garani AND Andrzejek CREATE OR REPLACE PROCEDURE SP_TEST IS BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE EMP'; END; / Beilstwh, I will take a look of the link...

Hi all, Garani ~ I tried the line, EXECUTE IMMEDIATE 'TRUNCATE TABLE tablexx'. it doesn't allow me to do anything. Andrzejek ~ Is there anyway you can help me to put a code inside the stored procedure to create the csv file? I created the csv file in the c drive, and I don't know how to write...

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...

Thanks everyone. I guess I have a clue on how to write the query based on all of your examples. I'll check tomorrow and I will let you guys know the result. Thanks a lot.

Hi, I still can not figure out what should I do in my original question. It keeps having error message. Is there anyway you can help me for my origianl question? Thanks

Hi, I ended up using this stored procedure/nested query in asp.net with parameter. That's why I think I need this to be build as a nested query in stored procedure. I will try your example. Thank

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...

Thanks Bob. It solved my problem after using the 1st solution. I am going to try the 2nd solution this afternoon. I am wondering how it goes in asp.net 4.0 because I am trying to convert some of the Access forms to web base (again, base on the users requests). May be I am in the wrong...

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...

Yes, it makes more sense now. Thank you very much, Gmmastros

Hi, I wonder what's the different if I have the "Count" word? SELECT Column 1 COUNT(CASE WHEN Column2 <> 0 THEN 1 WHEN Column3 <> 0 THEN 1 END) AS Column_Sum FROM tbl_A GROUP BY Column1 Also, Gmmastros, why I need two "End" at the end of before the "As" word? Again...

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 added your code into the same module, but when I press and click the Shift key, I can still see the Start-up options. Users can still use the Shift key to see the design of queries, tables, and reports. I wonder what did I do wrong? Thank you.

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...

Thank you for your replied. The database is front end in Access and back end in SQL Server. We have so many different databases (same front end and back end), but it seems like the MS office Access application picks up the Language bar no matter in which database. I tried to ask users to...

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...

I tried to create the variable at the Programmability, but it is still not working?

Thank for your quick respond, Daniel Vlas, I did get rid of the spaces in table/field names, and will consider the RoleID foregin key. When I wrote the script in the SQL Server in the View and tried to save it, it has the error code, "Must declare the scalar variable @userid. I don't know what...

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...