This is even cleaner to me:

SELECT EmployeeName, EmployeeNo,

SUM(CASE WHEN DATEPART(dw,DateEnt)=1 THEN RegHours ELSE 0 END) AS SunRegHours,

SUM(CASE WHEN DATEPART(dw,DateEnt)=2 THEN RegHours ELSE 0 END) AS...

I'll give that link a look... I have...

Lowell (12/9/2008)

---

the x is an alias; when you have a select in parenthesis, you need an alias in order to reference it;if you change the "x" to "mySubQuery" it makes...

This was suggested by someone which works:

SELECT EmployeeName, EmployeeNo,

SUM(CASE WHEN dw=1 THEN RegHours ELSE 0 END) AS Sun_RegHours,

SUM(CASE WHEN dw=2 THEN RegHours ELSE 0 END) AS Mon_RegHours,

SUM(CASE WHEN dw=3 THEN...

Thanks for all the replies... I am testing both methods and trying to decide which way to go. Marshall, I had originally done it this way and wasn't sure...

Ok... I have the script.

Could you expand upon this example to where there are 2 search fields and it is possible for one or both to be selected.

I am trying...

Paul,

I can't locate the script you are speaking of. Could you give me a link to it or post it here?

To all of you out there,

There have got to...

We are running on SQL7 with the latest service pack, but we plan to go to SQL2000 in a couple of months. There are about 23 fields in the...

Thanks for your time and input!

Test... couldn't see my last post on the 2nd page of of posts... so placing another post to see if it will make it show up.

I think you write just fine... I am simply a very detail oriented person and try to not leave any guess work when I write technical documents... only because I...

Your going to hate me.

You didn't say how to get the DTS into a script format. How do you get that out?

Do you also generate...

Oh... I forgot... do you include Generate Drop Object in your scripts.

I might have not been clear enough in my original post... I am at the point before even getting to in-flight or branching. I am still trying to figure...

Steve, thanks for the article. I have been looking for a way to track changes and this may just work for us. However I would like a little...