Yes, thats exactly what I needed. You make it look so simple

Thank you very much, this was extremly helpful

steve kinnaman

Thank you Wayne. Thanks to you I even figured out how to retain the space in the swedish zip by adapting your script like this:

select

[ZIP]...

What I need is the sum of the ytd_stat for each GAC.

that means one GAC per customer. The problem was to sum up (ydt_stat) for each GAC since some...

Whats wrong with this query (your [brilliant]suggestion):

select

Custn

, max(convert(int,Prod))as prod

, max(pers) as pers

, gac

, sum(cast(YTD_stat as float)) as ytd_stat

from dbo.YTD_nni

group by Custn, gac

The results below seem to be exactly...

I think you did it! This query seems to do the trick:

select

custn

, max(convert(int,Prod))as prod

, max(pers) as pers

, gac

, sum(cast(YTD_stat as float)) as ytd_stat

from dbo.YTD_nni

group by Custn, gac

order by...

It would be the first occurring value.

Each prod will be unique when summed up.

the pers will be the same for each custn

To allistair

The aggregate function for prod and pers is a problem for me.

the pers will always be the same for each [custn].

I need to group each [prod]

but I don't know...

Gsquared, your tip works perfectly

I tried below but just get an error, obviously wrong syntax. I tried also putting dbo.sasimp.enddate inside ( but same error. this is my problem, i can't...

And the solution is!:

select textinfo from ovriga

where

(DATALENGTH(dbo.OVRIGA.textinfo) between 2047 and 4092)

What I'm trying to do is get an output with column headears Ovr_id, textinfo, and adr_id, but I maximun size of the textinfo is 2046 characters.  The results will be...

I don't quite get it.  the columns I'm interested in extracting chunks of text from is textinfo.  the following statement gives the answer to the select statement and an answer...