Search results for query: *

I have a table with some duplicate records and I would like to convert it into a table with unique records. The table stores employee history in the company. There is one record for each position that an employee held in the company. The records aren't technically duplicate. The office address...

Is there a way to programmatically change a table name in all the stored procedures without having to change it one-by-one? We have a few dozen stored procedures and would like to change reference to particular table. Say table1 to be changed to table2 everywhere. Any ideas? Thanks,

Thanks, guys, for your inputs. I know I need to fix the DB design. Its high on my list.

Here is a search query I would like to optimize. The database is de-normalized to store 6 StaffIDs in the Applications table. We need to lookup applicaitons by employee names. Currently it takes a loooong time. SELECT * FROM Applications a LEFT OUTER JOIN Employee e ON m.StaffID = e.StaffID...

I have an update trigger on one of my SQL tables. In the adp client there is a form that is bound to the table. Now since adding the trigger, the form gives me a "Write Conflict" error whenever I try to update any information on the form. If I remove the trigger all works fine. The trigger makes...

What are the relevant columns in the two tables (nameid & employees)?

Use the SQL query to add the prefix. example: SELECT ('212-'+ Phone)As AreaCodePhone FROM Employees You can use a similar statement for UPDATE/INSERT

I am working on .adp with SQL Server back-end. Cannot define the field type in access. It is a varchar in sql server. Resizing doesn't help. It surely has to be some access setting becoz I can see all the data in sql server.

I have an access textbox displaying a sql server field (varchar, 8000). My problem is that the form would only show 4000 characters and truncate the rest. It saves all the comments but displays only 4000. Any ideas? Thanks,

Try this. You can add more conditions in the CASE statement. SELECT tblItem.TrackingNumber AS [Track #], tblItem.ItemID AS [Item ID], OrderNumber= CASE Status WHEN '1' THEN 'STK' WHEN '3' THEN 'Warranty' ELSE qrySalesTrack.OrderNumber END, tblItem.Location, tblItem.Status FROM tblItem LEFT...

I have an access textbox displaying a sql server field (varchar, 8000). My problem is that the form would only show 4000 characters and truncate the rest. It saves all the comments but displays only 4000. Any ideas? Thanks,

Upload files without using DLLs. Check this out: http://www.tek-tips.com/faqs.cfm?spid=329&newpid=329&sfid=1869 I am using it and its pretty cool!

I am facing this weired problem which I belive wasn't there before. I am developing an Access Project DB. When I try to add a new record to a form based on multiple tables, I get a "Write Conflict" error: "This record has been changed by another user since you started editing...

I have a calculated field on a Continous Form that I want to do a running sum on. I cannot use DSum because that field is a caluculated one and not a part of any Table in the database. The field calculation is complicated enough to eliminate the use of a SQL query. Any ideas???? Thanks!

I have tried this in many different ways (Thanks to the responses I got from this board)but I keep hitting dead ends. Here is what I want now...... I got three tables: Application, ApplicationDetails and Employees Application Table has ApplicationID & EmployeeID as a composite primary key...

I am developing a database solution using Access Project. My backend DB is in SQL Server. I have questions about securing the DB. I would like to hide all the tables when the user open the DB using Access Project, so that they donot make any design changes. So in the object explorer window I...

I am developing a database solution using Access Project. My backend DB is in SQL Server. I have questions about securing the DB. I would like to hide all the tables when the user open the DB using Access Project, so that they donot make any design changes. So in the object explorer window I...

Thanks Terry, it worked fine. I had to use two Outer Joins. I understand why MAX should not be used as a Table or Column Name. That was a silly mistake on my part.

I am looking for some suggestions to optimize the query below. Currently it takes till eternity to display the output and the users won't like it. The reason is quite obvious: I have used subqueries in loop. There are three tables involved Max, Employee and Departments. Max table has fields...

Terry, Did I tell your that I you are a genius? Your query worked like a magic!! Thanks so much. I must confess I could not fully understand the logic behind it. But I am working on it. I have another question for you: When I enter data in a SQL Server table (directly or by importing)and...