Yup[^] :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

SQL Ed wrote: Please don't respond to my questions anymore I could promise now, but would probably forget your name in a week. SQL Ed wrote: i didn't post a question for some punk kid to use profane language. The "friggin" was superfluous. It was partly an emotional response, something that simply seems to happen whenever I meet a 'solution' without a problem. As is, the requirement does not add value, on the contrary, it makes things more complex and error-prone. SQL Ed wrote: Because we are using the code in a 3rd party application,the requirements call for keeping all the code in a single stored proc. As hard as it may sound, but IMO that's where the error is. Unless there's a very good justification (besides the remark that it's a requirement), I'd still suggest fixing the problem at it's root. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

A case when clause can only return values, not conditions. Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions

SQL Ed wrote: I keep getting a syntax error On which line? I suggest you comment out blocks of sql, until you have a working version. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

I was not denigrating the fact that you are trying, just the fact that experience is just that, experience and cannot be transferred, you can however learn from the experienced which is what you are trying to do. Your problem is finding an experienced person with the spare time to teach and transfer that knowledge. Never underestimate the power of human stupidity RAH

It is possible especially if the DBs are on the same server, if they are not then the hassle of linked servers is irritating. Investigate doing the join in code in the report. You can throw the values into variables an manipulte the vars. Never underestimate the power of human stupidity RAH

Well I'm guessing that the emailed report is identical, so it must be something changed in the client config or the Exchange server. Have you been through the various Outlook options relating to encoding? Also it seems like your mid upgrade too, maybe somebody changed something on the Exchange side? As a test could you send an report to a completely different address (i.e. gmail).

You can link[^] servers within SSMS. Once set up, you can query both servers in a single statement, by prefixing the server-name before the database-name. Bastard Programmer from Hell :suss:

Try yo convert float Excel column into text and then import in SQL Table. I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.

It is better to backup your entire existing databases and uninstall the expired version. Then install the new one with the licence key. Wonde Tadesse MCTS

I'd probably do it like this. The main difference is making each [xx-yy] field a subquery, and using BETWEEN rather than doubling up the datediff's. select SUM(ARO.TOTALAMOUNT) AS SUM_OF_TOTALAMOUNT, [0-30 days] = (select sum(SUM_OF_TOTALAMOUNT) from <your table joins> where datediff(dd, CLM.SHIP_DT_CH,getdate()) <= 30), [31-60 days] = (select sum(SUM_OF_TOTALAMOUNT) from <your table joins> where datediff(dd, CLM.SHIP_DT_CH,getdate()) between 31 and 60), [61-90 days] = (select sum(SUM_OF_TOTALAMOUNT) from <your table joins> where datediff(dd, CLM.SHIP_DT_CH,getdate()) between 61 and 90), [91-180 days] = (select sum(SUM_OF_TOTALAMOUNT) from <your table joins> where datediff(dd, CLM.SHIP_DT_CH,getdate()) between 91 and 180), [181-360 days] = (select sum(SUM_OF_TOTALAMOUNT) from <your table joins> where datediff(dd, CLM.SHIP_DT_CH,getdate()) between 181 and 360), [over 360 days] = (select sum(SUM_OF_TOTALAMOUNT) from <your table joins> where datediff(dd, CLM.SHIP_DT_CH,getdate()) >= 361) from <your table joins> group by <your grouping> order by <your ordering> desc modified on Tuesday, June 21, 2011 3:23 PM