The view is returning data when i query it. Please advice, how do i do finer checks?

I modified this code:

SELECT * FROM [dbo].[fn_GetSummaryReport] (

<@pStartDate, date,>

,<@pEndDate, date,>)

to

SELECT * FROM [dbo].[fn_GetSummaryReport] (

'2022-0628','2022-07-28') ?

It returned nothing, no matter how far back i changed the date.

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

@JeffModenI What is the correct way in testing a view? did post the view's code

/****** Object:  UserDefinedFunction [dbo].[fn_GetSummaryReport]    Script Date: 2022/08/02 17:34:57 ******/SET...

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

I tried the code you gave:

/****** Script for SelectTopNRows command from SSMS  ******/
CREATE VIEW [dbo].[vw_UsageReportCached]
AS 
SELECT *
  FROM [dbo].[cacheUsageLogbook]
WHERE 
1=1
AND RegNumber NOT IN (SELECT le.RegNumber
...

I tested the view and found that the columns in question does not contain any data, no matter what date range i choose. I also found that table 'auditLevyBreakdown' contains...

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

CREATE VIEW [dbo].[vw_UsageReport]
AS

SELECT r.TransactionDateTime,
       r.ReceivedFromStorageUnitNumber,
       r.QuantityReceived,
       r.TypeOfVehicle,
  ...

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

Account Owner &  Type would be the columns in the Master Data i compare with my other data.

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

Will Cast or Convert only convert for the query or update my data types?

🙂 Yes, it did work. I was just looking at the column that i want the change to be in. Didn't see a new column was created.

Thank you.

It does not work.

I would like to split Event column based on data type as shown in Data type column.

USE [IT]

GO

/****** Object: Table [dbo].[Journey_Event_Value$] Script Date: 2022/03/28 21:15:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE...

Can an aggregate column serve as a primary key?

They are not unique.

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

one -to-many or one-to-one?

I consider my CM Data table to be my fact table. What would my relationship cardinality be for Store detail and Zip code to Fact table?