.

There's a...

Off the top of my head, something like this would work:

CREATE TABLE Course (

CourseID INT IDENTITY(1,1)

,CourseName VARCHAR(20) NOT NULL

);

GO

INSERT INTO Course (CourseName) VALUES ('Physics'),('Chemistry'),('Maths'),('Biology'),('SocialScience')

,('Craft'),('ValueEducation'),('Yoga'),('Games'),('ComputerScience'),('Science'),('Hindi');

/*

MondayTuesdayWednesdayThursdayFridaySaturday

07:00PhysicsChemistryMathsBiologySocialScienceCraft

08:00MathsValueEducationChemistry EnglishBiologyYoga

09:00GamesComputerScience ScienceChemistry HindiMaths

*/

CREATE TABLE Schedule (

DayNumber...

post your table or query definition. Adding time works exactly the same as adding days.

https://msdn.microsoft.com/en-us/library/ms186819.aspx

I was looking for an explanation of a rule or something. Is there a pattern here I'm supposed to use to do this? If so, what is it? ...

Srinivasan,

Here's the create table and insert scripts:

CREATE TABLE MyData(

CustomerID INT,

MonthIDINT,

RSCIDINT,

Flag1BIT,

Flag2BIT,

Flag3BIT);

GO

INSERT INTO MyData(CustomerID, MonthID, RSCID, Flag1, Flag2, Flag3)

VALUES(123,294,3456,0,0,0),

(123, 300, 1234,0,1,1),

(123,303, 3542,0,1,0),

(123,303,2345,1,1,1),

(123,304,3542,0,1,0),

(123,304,2345,1,1,1),

(123,305,3542,0,1,0),

(123,305,2345,1,1,1),

(123,306,2345,1,1,1),

(123,306,3542,0,1,0),

(123,307,2345,1,1,1),

(123,307,3542,0,1,0),

(123,308,3542,0,1,0),

(123,309,3542,0,1,0);

Could you give an example of your expected result?

Without sample data, it's hard to see what you mean exactly. If you have a table of tasks or jobs, and then a child table of status updates, then...

I'm not reporting on a cube, but if you use a number for the month (or better a date column) in your report instead of a string, SSRS will see...

You may need to force the existence of all dates in the range. (This would probably be better with a CTE to generate dates in a range, but anyway...)

--...

=DATEADD("n",150,Fields!orderdate.Value)

n = Minutes (because M is months)

h = hours

s = seconds

Since he's new, I did part of it... Here are the create table statements:

-- seems there's a table missing. Parent of the other 4 tables.

CREATE TABLE Customer (

CustomerAcct CHAR(10)

CONSTRAINT...

I have not seen it, but I've watched some of his presentations. He knows his stuff, for sure. There aren't many SQL Server Masters, and he is one -...

I agree. Cool solution Eirikur... I just cheated on the ASCII part... and ROW_NUMBER() was a handy surrogate.

Why the "not using ROW_NUMBER()" restriction? It works!!

Table scripts:

CREATE TABLE A (num1 TINYINT PRIMARY KEY);

GO

INSERT INTO A(num1) VALUES (1),(2),(3),(4),(5);

CREATE TABLE B(ltr CHAR PRIMARY KEY);

GO

INSERT INTO B(ltr) VALUES('a'),('b'),('c');

SQL:

SELECT num1, x.ltr...

Since you're new, we'll try to be gentle... no guarantees though. Help yourself by reading Jeff's article "Forum Etiquette: How to post data/code on a forum to get the...

To do what you want, you need a Calendar table with all the Months/Years you want, and then outer join that to your Invoices table.

Something like...

SELECT c.Year, c.MonthNumber, SUM(i.InvoiceAmount) AS...