Also - don't sort the data in SQL Server, and depending on the report(s) you want you may consider just returning detail data from the stored procedure without any grouping...

You should convert your 'script' to a stored procedure with parameters.  Then in Report Builder you will use the stored procedure as the source for your data and build report...

There is no default sa username/password - and if the vendor did not enable SQL logins when they installed, then it wouldn't be available anyways.

By default SQL Express enables only...

Happy to help - glad to see you have something that is working now.

I know this won't be extremely fast but it is workable.  To get something much faster you...

Back in the old days, we attend lookup tables for this kind of stuff. Since SQL is designed for looking up data in tables, instead of doing recursive loops...

Hi Jeffrey, thanks a lot. But the problem is that the data for the previous months exists. But I don't need them. I need data from the beginning of...

• This reply was modified 4 years, 7 months ago by Jeffrey Williams.

You don't need dynamic SQL to do this - you can build the table reference using FOR XML and if there are no values for specified months they won't be...

• This reply was modified 4 years, 7 months ago by Jeffrey Williams. Reason: Removed extra single-quote causing display issues

I am confused by the requirement - it appears you want to be able to grant a user the ability to change the database schema, but that same user who...

If you are interested - SQL generates the following code for Jason's original version:

[Expr1056] = Scalar Operator(CASE WHEN [@npy]<=(12) THEN dateadd(month,CONVERT_IMPLICIT(int,CONVERT_IMPLICIT(bigint,(12)/[@npy],0)*([Expr1050]-(1)),0),[@beg_dt]) ELSE CASE WHEN [@npy]=(26) THEN dateadd(week,CONVERT_IMPLICIT(int,(2)*([Expr1050]-(1)),0),[@beg_dt])...

• This reply was modified 4 years, 7 months ago by Jeffrey Williams.

I found from personal experience that function performs better than CTE.

Probably,...

HI Jeff,

I apricate your wanting to know I did not want to bother you with it, but I would like to get the SSIS  to work. As I said...

It really isn't clear what problem you are having - but I am assuming the issue is that you are getting duplicates.  If that is the case it is because...

Just one thought - you can simplify the calculations.  I used 'generic' names - which you probably want to change to what they actually represent...but something like this:

And...

Just one thought - you can simplify the calculations.  I used 'generic' names - which you probably want to change to what they actually represent...but something like this:

            
March 25, 2021 at 8:08 pm
            
#3862156

            
            
                                                
        

As long as you are careful in how much...