Excellent! thanks for your help with this.

My Select works fine, but when i added hte update to it, it updates the DomainRoot with the same value for all records. I am missing something but not...

Select CD.*

From ClientDomains as CD , DomainShortList as CD2

Where Substring(CD2.DomainName, Charindex(CD2.DomainName,CD.DomainName),100) IN (Select DomainName From DomainshortList )

This is not working for me... Can someone help me...

thanks! that worked

Yes, that worked! thanks. Now I have another issue related to this.

I have my main form called: F_workspacePP

Then I have a Tab control called: TabMain

I then created...

my version is 2010

Same path. The db's remain in the same location.

thanks but this is good for an existing server instance and not a new one with db's that are unattached. There is no history in the master db of...

It talks more about the masterdb. I cannot try the suggested cmd's because the instance does not start.

I think you are right. SQL may not have rights to the C: root drive. How do I change the location of the tempdb in sql server if...

Cannot connect to servername

Additional information:

A network-related or instance-specific error occured while establishing a connection to SQL server. The server was not found or was not accessible.....

Thanks!

that fixed my problem.

Ok, I think I found the issue, but don't know how to change this to fix it.

The problem seems to be with this code:

Select S1.*, S2.Cnt , rn = ROW_NUMBER()...

Here's the full code. I don't think the rest of it would affect the results, but you tell me?

Select S1.*, S2.Cnt, Cast(Null as Integer) as rn

Into AS_Workspace.dbo.StdPmt_InvAmt_SUM7...

I figured out the query that works for me:

Select S1.*

Into AS_Workspace.dbo.StdPmt_InvAmt_SUM_Removed

From FSW_NZ_JDE_Apr05_Sep12_C.dbo.StdPmt as S1

Inner join ( Select VndNbr, InvNbr, Sum(InvAmt) as InvAmt_Sum

From FSW_NZ_JDE_Apr05_Sep12_C.dbo.StdPmt

Group By...