i think this is has to do with what we use in the FROM portion of the TABLE being pivoted -->"@BookSales" . In this case its BookType,Type,BookSales,SalesYear

Do you happen to have any xml unfriendly characters in the column [mk]. Such as &<>.

These are likely to cause issues. So would need to do a...

I made use of the following technique described in stackoverflow.
https://stackoverflow.com/questions/13873701/convert-comma-separated-column-value-to-rows

CREATE TABLE MyTable ([Address] varchar(100), [MD] VARCHAR(100), [MK] VARCHAR(100));
INSERT INTO MyTable ([Address],[MD], [MK])

So i tried to make use of straight SQL to solve these kind of problems, ie( without the If-else logic) in T-SQL.
What i did is a left join...

I am joining the two tables on the basis of the number of days spent in the hospital with the range that it lies between in the payments tables. 

For DML kind of statements an approach i follow is to insert records which do not already exist in the target table. Rather than hard coding which can create unique...

Did that solve your issue?

I think you would only need to match by ID from the target table. I assume that your target table would be having id as a unique field?. (Edit: i...

I think there isn't a GREATEST and LEAST function equivalent in sql server. So you would need to make use of CASE statements to mimick the functions. Eg
[code...

How is the link established between School 3 and District 1. Do you have a column such as parent_district in the table?