Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag math Rss

   Items 1 to 5 of 5   
 

Integer left and right shift

3 functions that implement the left (<<), right (>>) and unsigned right (>>>) shift operators, commonly found in C-style languages.  Read more...
By Ioannis Tsakpinis 2012/02/15 | Source: SQLServerCentral.com | Category: math
Rating: |  Discuss |   Briefcase | 714 reads

Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2

Joining tables is a crucial concept to understanding data relationships in a relational database. When you are working with your SQL Server data, you will often need to join tables to produce the results your application requires. Having a good understanding of set theory, and the mathematical operators available and how they are used to join tables will make it easier for you to retrieve the data you need from SQL Server.  Read more...
By Gregory Larsen 2011/11/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,499 reads

Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1

A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.  Read more...
By Gregory Larsen 2011/11/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,965 reads

Linear Regression Forecast

Calculates the same formula as MS Excel Forecast function  Read more...
By msdevpro 2010/05/12 | Source: SQLServerCentral.com | Category: forecast
Rating: |  Discuss |   Briefcase | 2,214 reads

Linear Regression Forecast

Calculates the same formula as MS Excel Forecast function  Read more...
By msdevpro 2010/05/12 | Source: SQLServerCentral.com | Category: forecast
Rating: |  Discuss |   Briefcase | 2,214 reads
   Items 1 to 5 of 5   
 
Tags
stairway series (2)    
t-sql (2)    
bit-wise (1)    
forecast (1)    
join (1)    
left (1)    
linear (1)    
regression (1)    
right (1)    
shift (1)    
trend (1)