This is a slightly long approach.....but this is one way you can do it :

;With CTE

As

(

Select 1 As Number Union Select 2Union Select 3 Union Select 4

),...

May be this is what you are looking for:

;With CTE

As

(

SELECT DISTINCT 'International' Campus,28 'Weeks-2013',0 'Weeks-2012',2 'Student-2013',0 'Student-2012',0 StudentPrevYrTotal

UNION

SELECT DISTINCT 'International' Campus,32 'Weeks-2013',0 'Weeks-2012',1 'Student-2013',0 'Student-2012',0 StudentPrevYrTotal

UNION

SELECT DISTINCT 'International'...

Jeff Moden (3/30/2013)

---

vinu512 (3/28/2013)

---

This is how you can transform Mickey's query into a Dynamic Cross tab:

Declare @sql Varchar(MAX)

-- Set up some test data

Create table product(ProductId Int, ProductName Varchar(30),CategoryID...

This is how you can transform Mickey's query into a Dynamic Cross tab:

Declare @sql Varchar(MAX)

-- Set up some test data

Create table product(ProductId Int, ProductName Varchar(30),CategoryID Int)

Create table category(CategoryID...

mickyT (3/25/2013)

---

You could do something like the following, if you will always have 2 product prices, with 1 that has a quantity of 1.

select ProductID, ProductName, CategoryID, CategoryName, pp1.ProductQuantity, pp1.ProductCost,...

Cab you please be more precise on the logic behind the ordering.....If you simply want to

then there can be a no....

Good job with the DDL and the required output, we are only missing the sample data now.....take your time and make a dummy sample data set that looks like or...

The option is wrong....it is not necessary to have an Order By clause if Top is specified in a query.....it should be other way round.....Order By can only be specified...

Brad Marsh (3/7/2013)

---

Thanks Lynn I can appreciate what your saying but the reason I gave you that dummy data is because the data is confidential, I can not simply throw...

Let me get this right....from what i understood....a user may have umpteen no. of comments and the comments could all b different so you cant group using the comments column....

Brad Marsh (3/6/2013)

---

Thanks all, I really should have been clearer. The data is very much dynamic I can't predict what to expect from the comments. I was giving you a...

Oh shoot!!!...so much for typing so much 😀

Lynn posted while I was typing....

Hello,

Since you have 20 points, I assume that you are not new here have a relative idea about posting data on forums. If you don't then there is a...

Thanks Jason and Grant.

I did have a look at Sql Server Internals and even placed an order for it with Amazon. 😉

Till then I downloaded the ebook of...

I am pretty much...