Your data does not match so that even after constructing a query with valid joins you will not return any results.

The func_name column in the tbl_PI_Functions Table does not match...

I would suggest that you look into the JOIN Statement.

SELECT tbl_PI_Data.Date, tbl_PI_Data.Assoc_Name, tbl_PI_Associates.MgrName, tbl_PI_Data.Func_Name, tbl_PI_Data.Total_Proc, tbl_PI_Data.Prod_Hrs, tbl_PI_Data.Paid_Hrs, [Total_Proc]/[Prod_Hrs] AS PPH, tbl_PI_Functions.PPH_Goal, [Prod_Hrs]/[Paid_Hrs] AS PTP, tbl_PI_Functions.PTP_Goal

FROM tbl_PI_Functions INNER JOIN (tbl_PI_Associates INNER...

I do not use the wizard.

If you do it manually and you know what you are doing you can do it quickly,you know what you are doing and you can...

sqlquest2575 (7/11/2011)

---

Thank you Corgi. As suggested below please find the table script and the Access Query .

Table Create Script and Insert Data Script--

CREATE TABLE [dbo].[tbl_PI_Associates](

[Assoc_Name] [nvarchar](50) NOT NULL,

[MgrName]...

It's getting kinda late but could you please elaborate on that?

Thanks!

Digs (7/11/2011)

---

I use the same code structure above, I have only 3.5 million records. So it takes about a 1 second. I can live with that.

The base table has an...

I did not mean to create a stir but if you have 20+ Network Admins & multiple service account with Admin Privileges and you are told to lock SQL Server...

kramaswamy (7/11/2011)

---

What might be an option for you though, is to wrap your function call into a stored procedure. Have the stored procedure run the function, and have the stored...

You can't use the UPDATE statement inside a function unless the UPDATE statement is directed to a table variable local to the function.

GSquared (7/11/2011)

---

They probably have a contract with Microsoft. That kind of...

Very impressive articles authored by you as usual. 😎

sqlquest2575 (7/11/2011)

---

Thanks Corgi. I am just trying to understand your question here.. I have not created any proc to do this migration. I used SQL Server Migration Assistance for this...

I believe that there are additional actions that can be take to improve the performance than when I suggested.

You might want to find...

How large is your dataset?

Non Clustered Indexes?

Edit: I add my indexes after I load the Data.

GilaMonster (7/10/2011)

---

Welsh Corgi (7/10/2011)

---

I was wondering how you can prevent a member of the db_owner from from disabling or altering...