X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> A Way To Produce A View That Will Return A Value Even With Empty Table, Any Versions    
post Jul 17 2019, 11:21 AM

Posts: 1,184
Joined: 11-August 03
From: Denver - CO

Hi all

I want to utilize a view that will return a value to a field, even if the table (a worktable in this case) is empty.

When the table has a record, I can return one of the fields, no problem. Let's say I use this SQL to return 1 field :
SELECT MAX(serviceVal) as serviceVal FROM dbo.twkServiceTable

When there are no records in the table, I get nothing. Understood.

Now I want to use this view as a derived table in another view, but I want to return a 0 for serviceVal if there is nothing returned. Possible? Or is there another way to get to this resulting output (serviceVal if there is a record, 0 if not)

"Effort only fully releases its reward after a person refuses to quit."
- Napolean Hill, author
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    5th July 2020 - 03:26 PM