Databases
StackOverflow2013
Postsdbo
POVariable Declarations utilizing the WHERE clause
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVariable Declarations utilizing the WHERE clause
    primarykey
    data
    text
    <p>So I am relatively new to Microsoft's TSQL, and I am trying to write a simple script that bases an IF statement on whether the summation of column TransactionTotal is greater than or less than the summation of RepairCost for the prior 7 days.</p> <pre><code>USE MyBusinessDatabase DECLARE @TotalSales money DECLARE @TotalServices money DECLARE @WeekPast date SELECT @WeekPast = DATEADD(day, -7, GetDate()) </code></pre> <p>Now, the following Select/Where statements are where my problem is. The Select statements, which define my TotalSales and TotalServices variables, work fine until I add the Where statements. These LOOK right to me from what I've learned, but my IF statement ceases to work when I add them to the code.</p> <pre><code>SELECT @TotalSales = SUM(TransactionTotal) FROM Sales WHERE TransactionDate &lt;&gt; NULL AND PaymentDate &gt; @WeekPast SELECT @TotalServices = SUM(PaymentTotal) FROM ServiceInvoices WHERE PaymentDate &lt;&gt; NULL AND PaymentDate &gt; @WeekPast IF @TotalSales &gt; @TotalServices PRINT 'Total Sales &gt; Total Services' IF @TotalSales &lt; @TotalServices PRINT 'Total Sales &lt; Total Services' IF @TotalSales = @TotalServices PRINT 'Total Sales = Total Services' </code></pre> <p>Thanks a LOT and let me know if I can help clarify anything! PS As a big fan of my data structures C/C++ classes I find this SQL database class horribly redundant and boring and I am glad to get rid of it! I feel like I could enjoy it, but I really struggled with the class due to it being an afterthought with my algorithm and math courses eating my time.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USabatishchev
    1. USinsomniac
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POVariable Declarations utilizing the WHERE clause
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POVariable Declarations utilizing the WHERE clause
      1. This table or related slice is empty.
      1. VTUpMod
    1. COUse `IS NOT NULL` not `<>`
      singulars
      1. POVariable Declarations utilizing the WHERE clause
      1. USJonH
    2. COany luck with my comments below ?
      singulars
      1. POVariable Declarations utilizing the WHERE clause
      1. USJonH
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload