I've a data in the following format  -
cust_name , month, isAccountActive
A, jan-15, 1
A, feb-15, 1
A, mar-15, 0
A, apr-15 , 1
A,  may-15, 0
B, jan -15, 0
B, feb-15,1
B, mar-15,1
B, apr-15, 1
 
My output should look like follows-

Hi All,
I'm getting an error regarding non aggregate values when using sum over partition function. Basically, my goal is to get the total of a measured column for a particular descriptive column. i.e. 
 

SELECT

A.Dateid

A.Product Type,

A.Region,

sum(B.Revenue),

Dear All, Need help with below situation....
Data
id        date
100   6/6/2015
100   8/1/2015
100   9/30/2015
200   8/11/2015
300   7/18/2015
300   1/10/2015
300   3/5/2015
300   6/15/2015

Hi, 
So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.

Hi,
 
I'm trying to write an SQL statement based on this example data (just the first 3 columns)
 
OUTLET_ID DATE_ID      QUALITY_FLAG Count
799              01.06.2014   1            
799              02.06.2014   1

I am coding a SQL ( and I know a solution which is working). However I want to fix an alternative code. The code intents to find the first monday after the last friday of the last month( Here I have taken  sample date of last day of 2013, otherwise it is a generic query and you can replace the '2013-12-31' by date)

Hi!
I am trying to calculate moving sums and row counts in a query, to do further arithmetic on the said values. For a range of 3 days, for example, I would sum the values given in the rows for those 3 days, and then divide them by the amount of rows in that same time period.
In Oracle, the syntax would be:

I've run into an issue with a rollup I am trying to do and was wondering if anyone has any ideas on how to do it in as few steps as possible.
I have used several olap functions to build a table that has the following data:

Following is the data I currently have

 DateTime                User                   Number

Hi,
I have a table with Columns A, B below but I want to create Column C

Column C is explained as follows: Ordering by Column A ASC I want to replicate the value od Column B for all succeeding rows until a Non-Null value is met, then start again.

I am trying to create a view that returns aggregate results using OLAP functions. My intention is for the view to return the aggregates based on the data included in the where clause within the select statement that queries the view. However, what I am finding is that the aggregates are computed using all rows in the tables and not based on the Where clause in the Select statement. Here’s a quick test:
create table dev_eis_t.jlee80_agg_test
( id integer not null
, groupid char(1) not null
, selectionid char(1) not null
, qty integer not null
)
primary index (id)
;

Hi,

I have a SQL problem that I have solved using an OLAP function but I am wondering if there is a better way to do it - more elegant with potentially better performance. Here is the essence of the problem. Each person must take a test once per day over a specified period of time. They may take the test more than once per day, but must take the test at least once. During the course of the day they can also move around to different rooms. The data would look something like this for one person:

Person_Name Location Test_Date Test_Time

I need to do a conditional count on a number of assessments. It needs to be a distinct count over person and date. My raw data looks something like this:

Name Date Assessment Type Assessment Time
Chuck Smith 6/7/2010 1 6/7/10 1:00
Chuck Smith 6/7/2010 2 6/7/10 1:00
Chuck Smith 6/7/2010 3 6/7/10 1:00
Chuck Smith 6/8/2010 1 6/8/10 1:00
Chuck Smith 6/8/2010 1 6/8/10 2:00
Chuck Smith 6/8/2010 1 6/8/10 3:00
Chuck Smith 6/8/2010 2 6/8/10 1:00
Chuck Smith 6/8/2010 2 6/8/10 2:00
Chuck Smith 6/9/2010 2 6/9/10 3:00
Chuck Smith 6/9/2010 3 6/9/10 14:00

I have a pretty complex query that pulls the following "Insured IDs" from a table specified in the coalesce statement. The problem is that there are duplicate records with the exception of two letters in a string. I want to be able to only bring in the record with the "RT" In the string. I realize i might have to use a substring of sorts to accomplish this as well as a subquery? Perhaps an IF statement?

This is what the data looks like:

42078 00561070 610000000 06042129 Smith Joe 00561000000000000EE19470123F

Business Intelligence Architect
Position Type: Full-Time, Permanent
Company Name: HSGI Inc.
Location: Atlanta, GA
Primary Skills: BI, Architect, Data Modeling, Data Analysis, SQL, Data Warehouse, Data Mart, Dashboards

Urgent Job Opportunity!
Only Serious Candidates Need to Apply! We can set up interviews for you immediately!
Please reply with ALL of the following information:
• An updated copy of your resume in a Word (.doc) Document
• Current and expected compensation
• A brief introduction type paragraph outlining your skills and experience relative to the Job Description