Then you need a dynamic sql:

use tempdb

CREATE TABLE #Temp

(

PropRef INT,

AttributeName VARCHAR(50),

AttributeValue VARCHAR(50)

)

INSERT INTO #Temp (Propref, AttributeName, AttributeValue)

SELECT...

Is the problem that there are so many values for AttributeName, or you don't know up front which AttributeNames need to be in the result?

Hi Matt,

sorry, I'm not clear on what you need here. Are you having trouble with the query for creating the intermediate table or getting that table into Crystal Report?

If...

Hi Mat,

yeah, a little clearer.

DECLARE @Temp TABLE

(

PropRef INT,

AttributeName VARCHAR(50),

AttributeValue VARCHAR(50)

)

INSERT INTO @Temp (Propref, AttributeName, AttributeValue)

SELECT 100058, 'Heating...

Dupe post, please see http://www.sqlservercentral.com/Forums/Topic804758-1291-1.aspx

Any chance you could post some table definitions and sample data please?

It'll be a lot easier to try and help!

See following article how to do that http://www.sqlservercentral.com/articles/Best+Practices/61537/

Hi Jeff,

many thanks for taking the time to research, write and post this eagerly anticipated article!

Just tried running some of the code and have noticed missing whitespace from figures 2,...

Hi,

had a closer look at this, basically I see two main solutions, compute the shift name with a case statement, which is fine when the shift patterns never change, or...

do you mean?

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'EMAIL REMOVED',

@subject = 'Something Important',

@query = 'select * from TableName where Source = 1 and (name like '%I%' or name like '%O%')',

@attach_query_result_as_file = 1,

@profile_name =...

You didn't provide any test data, here's some courtesy of Jeff:

--===== Create and populate a 1,000,000 row test table.

-- Column "RowNum" has a range of...

hey, try http://msdn.microsoft.com/en-us/library/ms162802.aspx

Do you have duplicate values of delegate_name?

You may consider flattering your MD's business acumen by suggesting that when he leads the company from strength to strength — entering new markets, acquiring competitors, diversifying your product...

Sorry Lynn, had that posted before I saw your's.

Absolutely agreed, DDLs etc. would be very helpful!

USE TEMPDB

DECLARE @temp TABLE (Country VARCHAR(20), Sales INT)

INSERT INTO @temp

SELECT 'Sweden', 7777 UNION ALL

SELECT 'Denmark', 10000 UNION ALL

SELECT 'Russia', 9999 UNION ALL

SELECT 'Country1', 1 UNION ALL

SELECT 'Country2', 1 UNION ALL

SELECT...