I started to reformat your code so I could read it better, and unfortunately you have some logic errors in WHERE clauses. I'm going to leave it as an...

A seat of the pants change I'd make would be the clustered index on this table:

CREATE TABLE [dbo].[tbl_ProviderCoverage](

[tpcID] [numeric](18, 0) IDENTITY(1,1) NOT NULL ,--PRIMARY KEY but non clustered

[tpcGCProviderID] [numeric](18,...

GSquared (4/28/2009)

---

Will something like this do what you need:

;with T2 as

(select row_number() over (partition by Table1Key order by EventDate desc) as Row,

Table1Key,

EventDate,

EventText

from dbo.Table2)

select *

from dbo.Table1

left outer join T2

on Table1.ID...

Just to add, don't hesitate to ask for help. Just be sure to give us all the information we need to be of help when the time comes.

tpepin (4/28/2009)

---

Peter's explaination has already convinced me that set operations would be better. In my case, it wasn't...

Because you are using the MAX aggregate in the select statement you need a group by clause, try the following:

SELECT

C.ID AS client_eng_id,

...

I see several broken guantlets on the ground. As I asked for before, give us requirements, DDL for the staging tables and destination tables, processing rules for the data,...

You can drop your current function dbo.tvfGetNumbers and replace it with this:

create function dbo.tvfGetNumbers

(

@startnum tinyint

)

RETURNS TABLE

AS

return

(select @startnum as number union

select @startnum...

LMeyer (4/28/2009)

---

I want to add another table to an existing select statement in order to pull an additional field.

The field I want to add is ClientBuckets.Cinvlastinv (Last date of Invoice...

Were there any changes in the recovery model used by the databases during that time? If there was a change from FULL to SIMPLE and back to FULL, then...

I'm slightly confused, what are you trying to accomplish with this code?

I can't help you with winscp as I haven't used that particular product. You might try a search on SSC for winscp as i do remember seeing a few...

jo.owens (4/28/2009)

---

I don't think you can use the FTP task for SFTP files. I know there are 3rd party apps out there, I am just not allowed to use...

Kurt W. Zimmerman (4/28/2009)

---

My approach is quite simple. Often times I am passing in a date range into a sproc for selection criteria. What I do is the...

Jeff,

I knew you'd have a bit to say here when you read it. I modifed his table def for RawData to match the def in his cursor routine.

Scott,

Yes, your...