I figured this one out by using the && operator. Thanks

Thanks, that was perfect

Thanks for the reply. Got it.

Thanks, worked great!

Thank you for your replies. Do I add this in the custom code area?

What I mean is to convert a date from julian to gregorian. Example would be ; Julian - 112074 convert to 03/14/2012 thanks

Thanks, I figured that out. Upgraded to Enterprise and all is well

Thanks for your responses. I used the excel method with creating a new column and using the following;

="'"& A2 & "'"&","

This worked well and was a classic case of as...

OK, here is the code stripped down. I do have an ODBC conn to the AS-400.

SELECT cwsispak.softpreg.regname, ARWFCA.CUST.CCMPNY, CWSISPAK.SOFTPREG.CCNAME, SUM(CASE WHEN ARWFCA.CUST.CSTRDT >= 20120101 AND...

How would you like to see some sample data? What format etc?

I will reformat the code....sorry!

OK, here is my query now....are you all suggesting I make additional changes to enhance performance? Thanks

SELECT a1.timestamp, a1.Computer_Name, a1.Packet_Type, a1.User_Name, a1.Client_IP_Address,

...

Thank you all for your responses! I used the query that "sqlknowitall" reworked for me and it is much more efficient. Thanks to all that responded.

Got it...sorted in row groups....now everything is PERFECT. Thanks for your response.

I do not have an order by in the statement by design