ben.brugman (4/16/2013)

---

But here is a direct question (this is my main problem with Access):

Use case:

A user is inserting a row in Table A, table A has a relation with...

Have you thought of an alternate solution like SQL replication, infacts merge replication is good way to go. create publisher/subscriber, then schedule it to synchonize once a week?

How about this... create a function from this code supply a year, a week number you want. DayNumber would be=7 for Saturday.

declare @YearNum int,

@WeekNum int,

@DayNum int,

@FirstDayYear As Date

...

I tend to agree which what you...

David McKinney (4/5/2013)

---

I would tend to agree.

Do you have the option of creating a copy of the stored procedure with the variable declared as an int, and running...

or if you are lazy to list the column name do this.

SELECT NEWID() AS [NewID], * INTO NewTable

FROM ExistingTable;

ALT_R TABLE NewTable DR_P COLUMN OldID

*fill in...

without any test data, or specific line that the error occurs I dont think anyone here will be able to pin point you exactly where your exception occurs. My suggestion...

You may want to provide more detail I dont really...

Here you go. l leave the easy part (eliminate unwanted rows) for you to solve the tough part can be done this way:

CREATE TABLE #DATA (ManagerID INT, EmployeeID VARCHAR(50));

;WITH TEMPTE(ManagerID,EmployeeID)...

I see what look like you were doing VBA on MS Access. I have not heard of database application name ADP, what is it?

ScottPletcher (3/20/2013)

---

FYI, a FILLFACTOR of 80 is wasting space in many tables and perhaps even still have too little freespace in others.

You need to determine the best FILLFACTOR for each...

Gail

On my machine I have...

Thanks again Gail!

Thanks Gail,

So Reorganize will work for SQL 2000 and newer?

Thanks!

I was aware of...