Using LEFT(@date,3) gets you a 3 character abbreviation for the month name, or you could create a table

to look up up the name to go with the number returned by...

Okay Barry, reading about your hospital stay reminds me that I truly have no problems and should quit my bitching. I will say a little prayer for your...

*POUND*

*POUND*

*POUND*

Ow, my head.... where the @#$%# is that spare keyboard!!! :crazy:

I didn't lose any sleep over it, but please remember it for the future. There are lots of new and improved techniques between 2005 and 2000. ...

O Lynn, merciful patron Saint of Patience, tell us where we have failed.

Have we not asked the OP for data?

Have we not shown the OP the link to Jeff's article...

Hi again Trudye. What we have here is failure to communicate. The abbreviated schema you sent earlier were fine. ...

You gotta love it. He passes out a solution that performs faster AND (to me) reads simpler. But no, they still want him to rewrite...

But Jeff ... What if they'd said "Pretty please, with sugar on top" ?? 😛

For what it's worth, I saw no difference in the execution plan for your example whether or not a SET or a SELECT is used. Apparently...

Listen to the little green master. Wise he is in the ways of the Forum...

I love your new avatar too, Lynn. It radiates awesomeness.

Got it. I was looking at the difference in execution plans, and you example has a compute scalar... which obviously calculates a single value. I...

Hey Jeffery, thanks for joining in. 🙂

I will confess to totally overlooking the null set as you illustrated. So let me ask you this question:

Why does...

Schema are good to have as a start. Now how about some values in those fields, like this?

declare @A table (id int, name varchar(5))

insert into @A

select 1,...

NULL is the absence of a value in a column for a given row (or a variable), not the absence of a row.

@@ROWCOUNT is the count of rows returned or...

Hey Trudye 🙂

Could you please supply us with a little sample data to work with? It really isn't clear from the code you've posted, and would be...