Nice question, thank you. It's nice to see questions on reporting services, too.

Regards,

Iulian

I am using this query when I need to inventory the subscriptions:

SELECT

Catalog.ItemID,

Catalog.Path,

Catalog.Name,

Catalog.ParentID,

Catalog.Type,

Catalog.[Content],

Catalog.Intermediate,

Catalog.SnapshotDataID,

Catalog.LinkSourceID,

Catalog.Property,

Catalog.Description,

Catalog.Hidden,

Catalog.CreatedByID,

Catalog.CreationDate,...

Stewart is right,

You can get an overview for XML support from here too.

Regards,

Iulian

It is not clear to me what MANIPULATE means, could you please define.

Iulian

Nice question, thank you.

Regards,

Iulian

Thanks for the question

Regards,

Iulian

Data_God (8/3/2011)

---

Whoo.Hooo..

2nd comment on this QOTD. Haven't been able to do that in quite a while. Thanks for the good question. I got it right as I just recently had...

John Mitchell-245523 (8/3/2011)

---

I would advise against doing that, since it would make...

Hi, You can try something like:

SELECT

ISNULL([column1], '') AS A

, ISNULL([column1], 0) AS B

, ISNULL([column3], '') AS C

, CASE WHEN ISNULL([Column 1],'') = '' ...

or instead of :

ARRIVAL_SCHEDULE_DT <= dateadd(mm, 3, getdate())

you can use this condition too:

datediff(mm, ARRIVAL_SCHEDULE_DT, getdate()) <= 3

Iulian

Well..., it is not very clear, could you please use but I think you can start working with this:

SELECT *

FROM table_name

WHERE

-- PORT_CD = 'BEZEE' AND

ARRIVAL_SCHEDULE_DT...

I am interested in this subject too, could you please post a code sample.

Thank you,

Iulian

You can trace the execution of a T-SQL statemen using SQL Server Profiler.

Regards,

Iulian

Nice question, thank you

Regards,

Iulian

Good point, looking at wiki:

Ramp up is a term used in economics and business to describe an increase in firm production...