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...

First, you probably don't need a cursor. Just based on your original post, however, there isn't much we can do to help.

First, I'd like to suggest that you read...

I'm sorry, but I really can't follow what your are asking or what you are trying to accomplish. Nothing in your post really makes any sense to me. ...

Flo...

Since there was no production problem I had, after this input I could show my chief some really great new things and it causes that some parts of our applications...

twdavis (4/27/2009)

---

First it does not matter if this is peoplesoft are not we are not writing this in peoplesoft query.

what I am looking for.

each load(LOAD_ID) has multiple stops (TMS_EXT_REF_ID) now...

JJ B (4/27/2009)

---

the vendor has designed their application to force a row-by-row approach because they don't know any better. So as you say, you don't really have a choice other...