Hi, thanks for the notes; much appreciated! I don't know why the READ Uncommited was added. I inherited the maintenance of these stored procs from someone else. ...

Yes! This is what I've been trying and it works, but it takes a really long time; which I believe is due to the OR condition. I didn't...

Thanks for the info on performance. I'm inheriting these stored procedures from another team and I'll pass this on to my boss to see if he wants to look...

I got it to work! Thanks for the advice, it did the trick.

Here's my code:

ALTER PROCEDURE [dbo].[proc_Usage]

@custNumber CHAR(10),

@polNumber CHAR(7) = NULL,

@fromDate DATETIME = '1900/01/01',

@toDate DATETIME =...

Thanks for all the help! Here's what I came up with for my January 1 date field:

CASE WHEN month(getdate()) = 1 THEN DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) - 1, 0)...

Thanks for the reply! How can I get a 1/1 date for the current year that will return 1/1 of the prior year when I use it in January?

Hi, I saw this post and am interested in the topic. I 'm a newbie to SSRS and am exploring how I can dynamically change the connection string. ...

I used your code and it works! However....when I go into Query Designer and add in my parameter names in the WHERE clause, it doesn't like the ampersand, (@)...

Can you clarify what you mean please? I'm sure this is a very elementary concept but I don't know what you're asking. I understand what you mean when...

OK. I'll let you know how it goes. Thanks again for all the help!

Ah, good point; I didn't see that. It was set to text but I just changed it now to Date/Time. I did a Build, but I'm still...

The date/time value shows up in the parameter boxes. (not the report)

Whoops, I spoke a little soon. The dateserial coding works, (doing the right dates) but the dateserial code is doing "MM/DD/YYYY : time". When I run the reports...

Ah, there we go, now it's working. Thanks again!!!

You did, a lot. One thing....I'm trying to get the last day of last month and not getting it. I keep getting May 30. The formula I...