I wonder why special thanks to me??, I didn't do anything special than others.

I'm glad I'd helped you.

A Little Help Please (4/3/2009)

---

Ok, Iv started again.

Now when I hit "Evaluate Expression" i get the correct result (i.e. the SMTP Server address).

I have done your revised steps but I...

Here is another way to do it....

SELECT id, description,

[JAN A HEADER] AS [A JAN], [JAN B HEADER] AS ,

[FEB A HEADER] AS [A FEB], [FEB B...

You are welcome.., no problem this time but make sure it doesn't happen next time

David (4/2/2009)

---

I would like to display some of the fields of two rows side by side but am struggling! The table is as follows:

CREATE TABLE [dbo].[ForecastPartsD](

[id] [nvarchar](50) NULL,

[description] [nvarchar](60) NULL,

[period]...

You can convert your query to use either derived tables or common table expressions (CTE, available in sql 2005+)

For. e.g.

SELECT MyDerivedColumn

FROM (

...

What errors does it throw? Are you not using SQL Server 2005?

Now I see what is the problem!! It was my bad that I was suggesting to set incorrect property,...

You have add two single quotes within a string in order to read it as a part of the string. For e.g.

EXECUTE ('select * From fn_my_permissions(NULL, ''database'')') AS USER...

Well, let me see the package variables list print screen (Right click...

I'm not sure I've understood what you want, from the look of it, I think you need the last transaction for each component.

With this little information, what I've...

The final expression should look like "SmtpServer=xxx.xxx.xxx.xxx"

Have you checked the Expression Evaluated Value? ...

If you have Tally or Numbers table then you can loop through them to form a dynamic PIVOT clause (or SQL) and execute it using EXECUTE or sp_executesql statements.