Hans is right, jthill. This is not something you really should be doing with T-SQL.

Why don't you take a step back, describe what it is you want to achieve (i.e....

Hi Richard,

I'm guessing this isn't as easy as...

select sum(hours), sum(cost), sum(esthours), sum(estcost) from yourview

...but I don't see why not from your description of your problem.

Please post some sample data and...

Pieter,

I can't get my head around it without some sample data, but surely if you use a full outer join and no where clause, nothing will be left out? Is...

Pieter - Why would you do that rather than simply a left outer join?

Hi jthill,

That's as clear as mud to me.

If you post an example of what you're trying to do (i.e. table structure, sample data,...

Hi Kavita,

I don't know if the link gave you what you needed (there's a lot there!), but I've had a stab...

--data

declare @t table (i int identity(1,...

Here's some info on the ISNUMERIC function, and a work-around...

http://aspfaq.com/show.asp?id=2390

Hi Ben,

Try using 'left outer join' instead of 'inner join'...

The answer is probably yes, but it does depend on what 'sproc' does.

If you post an example with the table structure, some sample data, and the expected output, you'll get...

Hi Ashok,

If you post an example with your table structure, some sample data and the result you would like to get based on that sample data, you'll get an answer...

Hi Darin,

The case method is more efficient, and I'd normally recommend using that. If you need to group/rollup numbers, you can always use the select containing the cases as a...

I can't find the article by Itzik Ben Gan - can someone please post a link.

Any idea when he 'came up with' the algorithm? I ask because it is suspiciously...

Hi Karthik,

It's hard to understand what you're asking for, but maybe it's this...

--data

declare @t table (words varchar(100))

insert @t

          select 'hello, thanks, movies, tickets'

union all select 'abc,...

I suspect this is not what you want, but it does do what you asked...

April 12, 2006 at 4:40 am