How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
COURSE of the MONTH
11 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
sql return 0 / null values
Posted on 2011-03-05
when running this stored procedure -- its keeps crashing the web-page.
I suspect its because the value is zero -- how do I prevent this from happening (via SQL)
I suspect its because the value is zero -- how do I prevent this from happening (via SQL)
@COSID int,
@StartDateTime datetime,
@FinishDateTime datetime
AS
DECLARE @table1Value int
SELECT @table1Value = (
SELECT SUM(ChargeableAmount)
FROM [TDRData]
WHERE (TransactionKey = 6) AND (COSID =@COSID)
AND (TransactionTime BETWEEN @StartDateTime AND @FinishDateTime))
SELECT TotalValue = @table1Value
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
0 is not the same as null
if its returning null, do "SELECT TotalValue = isnull(@table1Value, 0)"
there's nothing wrong with the code itself from what has been provided. you can always change it to have an output parameter rather than simply selecting a value at the end
Then, when you call the proc, include an "@TotalValue out" parameter
if its returning null, do "SELECT TotalValue = isnull(@table1Value, 0)"
there's nothing wrong with the code itself from what has been provided. you can always change it to have an output parameter rather than simply selecting a value at the end
@COSID int,
@StartDateTime datetime,
@FinishDateTime datetime,
@TotalValue decimal(19,5) output
AS
DECLARE @table1Value int
SELECT @table1Value = (
SELECT SUM(ChargeableAmount)
FROM [TDRData]
WHERE (TransactionKey = 6) AND (COSID =@COSID)
AND (TransactionTime BETWEEN @StartDateTime AND @FinishDateTime))
SELECT @TotalValue = isnull(@table1Value, 0)
Then, when you call the proc, include an "@TotalValue out" parameter
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month11 days, 10 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.