If you backed up your databases before doing this, you could just restore over the bloated ones and be done with it. If not, you may have to use...

Tried working with the data you provided and it's a mess. Could you please post table definitions and insert statements for your data? Then those trying to help will...

.

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...