That is the problem, i just cant find that DML.

• This reply was modified 2 years, 4 months ago by  yrstruly.

You mean the DDL like it is, see attached?

Where do you suggest i start?

Im not sure about Static/Dynamic. I requested what it is, and was informed it is Static(or so this person guess).

Your feedback is in contractdiction of what i have been told in terms of comparing production with qa. It stems from this issue:

https://www.sqlservercentral.com/forums/topic/sys-object/page/2

• This reply was modified 2 years, 4 months ago by  yrstruly.

I queried the QA database and found different results, see attached. I used the Compare tool in SSIS and it sates the schema's are the same. Pls assist?

• This reply was modified 2 years, 4 months ago by  yrstruly.

This view brings back data:

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP (10) [TransactionDateTime]
      ,[ReceivedFromStorageUnitNumber]
     ...

By QA environment, do you mean my live data?

My tables/views reverse engineered done with SSIS.

• This reply was modified 2 years, 5 months ago by  yrstruly.

Tables [cacheUsageLogbook] and [lstEquipment] contains data. I got your code to work, accept for the last one.

/****** Object:  Table [dbo].[cacheUsageLogbook]...

        CREATE FUNCTION [dbo].[fn_GetSummaryReport]  (   @pStartDate     DATE,   @pEndDate   ...

• This reply was modified 2 years, 5 months ago by  yrstruly.
• This reply was modified 2 years, 5 months ago by  yrstruly.
• This reply was modified 2 years, 5 months ago by  yrstruly.

I did the reverse engineering with SSIS as suggested. I only found these code with a relation to the empty table.

Could it be that the insert code can be saved...

• This reply was modified 2 years, 5 months ago by  yrstruly.

Does not seem like it.

Like Jeff said, we dont know how the table was created or being populated. I ran your code and got this: