In the future - please provide sample data in the form of a create statement and insert statement.  That can be done using temp tables or a table variable.  I...

If you are moving SQL across DC's - then you must put in place a method to copy the local native backups to a shared location reachable from both DC's,...

The problem is the loop and the fact that this runs 2400 times per day.  It appears the goal is to delete any rows older than 24 hours (your DATEADD...

I am guessing here - but it looks to be an issue with using float.  Since float is an approximate data type - the value of 3.275 is probably set...

Ah... you're correct.  No pivots required for this problem so no Cross Tab (although the code is nearly identical... just missing a CASE in each sum for the non-CROSSTAB...

The thing above (which you posted) is actually "just" a CROSSTAB (which will have a GROUP BY) with a ROLLUP.  With...

There isn't a correct answer for this - SQL Server 2016 does not have TRIM, it only has...

They have added a new parameter for BULK INSERT named FIELDQUOTE.  Add that to your command and specify the double-quote as the field quote and it should get you past...

I put this together - based on the data you have we can get the results you are looking for with this:

Declare @mockTable Table (
  ...

Since you have this mocked up data - you can use that same data to build out a temp table with the associated data.  Once you have that and posted...

You don't do anything specific to 'accept' a parameter via URL.  You create a parameter in the report - and tie that parameter in the report to the stored procedure...

Okay - these are simple issues to correct, assuming what you want is code for a specific ledger then we can do this:

Declare @ledgerID int = 1222;

...

This is an UNPIVOT - and you could use that operator, but I prefer CROSS APPLY:

 Select sp.MAINJOB
      , m.MappedJob
  ...

This is what I think you want:

   With transactions
     As(
 Select Trans_ID = 0
      , Trans_Type...

• This reply was modified 4 years, 11 months ago by Jeffrey Williams.
• This reply was modified 4 years, 11 months ago by Jeffrey Williams.
• This reply was modified 4 years, 11 months ago by Jeffrey Williams. Reason: Fixed Trans_Remarks - updated image

Remove AST.AppointmentStatusName from the GROUP BY - you are not including it in the select.  If you want to group by 'Call Center' or 'Web' then you need to define...