be brave. Test it. On a DEV machine.

set statistics io on;

set statistics time on;

-- execute your query here

select *

from dbo.V_OnlineSalesOrder

WHERE IncomeGroup = 'Moderate';

set statistics io off;

set statistics time...

Sounds to me like you should do the whole thing in a stored procedure. If vacation hours is completely dependent on hours worked (so, a timesheet entry), then why...

"giving me errors" is just means it doesn't work. How about providing the error message?

It worked when I based the report on this T-SQL statement:

SELECT field1,

field2,

field3,

field4,

field5,

COALESCE(Field1 + CHAR(10) + CHAR(13),'') + COALESCE(Field2 + CHAR(10) + CHAR(13),'') + COALESCE(Field3 + CHAR(10) + CHAR(13),'') +...

Is there any way to convert this rows to columns.

Yep. PIVOT or use a report with a matrix

Not enough information. Please post your table definition(s).

How do you calculate health? (Or does it matter?)

I think you can create a stored procedure to join the two tables and flatten the data and then just group by...

use STUFF for the concatenated list and SUM with GROUP BY the result of the concatenation

If you want some robust logic, how about a robust explanation of how to get from your sample data to your result?

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