Sean Lange (4/10/2012)

---

And yet another way to skin this cat...

create table #Address

(

id int,

addr1 varchar(25),

addr2 varchar(25),

addr3 varchar(25)

)

insert #Address

select 1, '123', NULL, 'Main St.'

union all select 2, NULL, NULL, NULL

union all select...

opc.three (4/10/2012)

---

That's the ticket, but only one...

This will probably end up being a regular operation.

Yes, that's my ultimate goal. I'm just trying to think of ways I can accomplish that. For example, I could probably use a combination of ISNULL() with concatenation with a...

It's not that I mind using three case statements. It's that I don't think they'll be that simple. How about with concatenation?

Thanks, guys.

@GSquared -- yes, that's exactly what I was talking about, and I think the DB name "Common" is a good way to represent all of that information.

Nevermind, I think I was thinking of IS_MEMBER.

Thanks anyway,

Mike

Thanks guys, very helpful! I have one more question. Is there any way make it so that if there's a remainder, it's at the beginning instead of at the end?

For...

No, I do not.

-Mike

Under which user context would the CLR function be run?

As far as I know, you only have two options:

1) Create a new table with the correct column collations, load the data from the original table into it, and replace...

wizard_froto (11/14/2011)

---

An example would be:

mytable

State City Sales Qty

CA ...

Can you provide an example?

This will get you there:

SELECT [State],

City,

AVG(NUMBER) AS Median

FROM (SELECT [State],

...

cljolly (11/14/2011)

---

For example, I have several table drops to make and the top of my program is getting cluttered which is where I put all of my table drop code....