Primary server:

Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0...

Sorry, I wasn't trying to invade the space. I've been scolded before for asking a question which has already been answered and didn't want to muddy up the site....

I'm also interested in this setup. We have agent jobs performing a full backup every 24 hours and transaction logs every hour (both to local folders). The last step...

there was an "sa" local login with the Impersonate box checked. This makes sense because that login obviously exists on the linked server. There was also my windows...

when I run this:

select CustomerNumber, [year], TotalYears

from sfidata.dbo.tblCustomerHistory

where CustomerNumber in (1001, 1002, 1005)

order by CustomerNumber, [YEAR]

I get this:

CustomerNumberyearTotalYears

100119861

100119872

100119943

100219931

100219952

100219973

100519841

100519902

100519913

100520004

100520066

100520076

100520108

100520118 which shows you the data I'm working...

Try this:

select dbPatCnt, dbSchTypeCnt, dbSchDate

from dbo.SchDetail

where dbSchDate = (select MAX(dbSchDate) from SchDetail sd

where sd.dbSchTyhpeCnt = dbSchTypeCnt)

do you mean you want to insert data into a SQL table from another SQL table on the same database?

if so:

Insert table#1 (field1, field2)

select field1, field2 from table#2

BCP or Bulk...

this query:

create table #orders (ordernumber int, orderdate datetime)

insert #orders

select ordernumber, orderdatetime

from tblOrderHeader

where CatalogYear = 2013

inserted 134,057 rows in 1 second from SSMS. Does it need to be much faster...

Yes, I have the source code and am aware that learning C# is not the focus of this topic. I've needed the C# to begin re-writes of custom VB6...

Very timely for me. Another programmer deployed a CLR function about a year ago and I don't know anything about it. I've been saying I was going to...

Well stated, Old Hand. Thanx!

I'm a relative novice. How can I use this?

Wow! you folks have been busy! I'm just reading this at 2:pm EDT and by time I got to the end, I forgot what the original purpose was....

Thanx Rudy! I see this as being helpful for us. I've been troubleshooting some timing-out errors lately. We're in our peak sales period so our system is...

I'm not in the same league with you guys as far as what this all means. I apologize for any dumb questions, but is this reporting CURRENT activities or...