Steve Jones - Editor (6/1/2010)

---

I'll only disagree on one part. I think that government can create jobs. Not by spending our tax dollars, but with tax incentives, especially a reduction...

Actually, it's better for everyone in...

I believe in free markets. I believe we'll all be better off the less government is involved in our lives with very specific exceptions where government oversight or control...

Please don't re-post the same question in different places.

Original post here.

Please don't re-post the same question in different places.

Original post here.

This is one way you can run it without using as much overhead. I'm sure there are ways to do it better but at least you'll avoid cursors and...

From a T-SQL standpoint you can do something like this:

update myTable

set Column1 = case Column1 when '' then null end,

Column2 = case Column2 when '' then null end,

Column3 = case...

Take a look at PIVOT in Books Online.

You didn't really provide much helpful information about what exactly you're trying to do, but if it's a simple string concatenation with a space between each field then it would...

Maybe I'm not understanding what...

Not sure what you mean by repeated queries.

If you need something more inline you can also just do something like this:

select rxno,

patient,

location,

filldate

from loadit l

where l.filldate =

(

select max(sq.filldate)

from loadit sq

where sq.rxno = l.rxno

)

A CLR would definitely work, but I don't think it's necessary here.

I used a table variable instead of temp table for my own reasons but you can do whatever on...

select LEFT(Name1, CHARINDEX(',', Name1) - 1) as NameLast,

STUFF(Name1, 1, CHARINDEX(',', Name1), '') as NameFirst

from UBMAST

Couple of things:

SET NOCOUNT ON;

BEGIN

This needs to be at the beginning before you declare your variables.

Also, you're passing a string into xp_cmdshell that has "@PriorMonthStart" and "@PriorMonthEnd". You need...