No Probs 🙂

Its not pretty and there are better ways but without more information it is difficult to provide a solution.

CREATE TABLE #temp

(TextValue VARCHAR (5))

INSERT INTO #temp

SELECT 'efg' UNION ALL

SELECT 'abc' UNION...

Hi

You'll need to nest another IIF, something like this:

=FormatDateTime(IIF(IsNothing(Fields!Planneddate.Value), IIF(IsNothing(Fields!appl_status_date.Value)," " , Fields!ActualDate.Value)))

Andy

Hi

Just a slight amendment to the query posted previously should do the trick for you

SELECT *

FROM #table1

WHERE

(ItemID LIKE 'LGE%' OR ItemID LIKE 'SAM%' OR ItemID LIKE 'HTC%')

OR...

Welcome to my world! I can't tell you how many times I've had to do some funky code to get around some requirements!!

To be honest I'm...

I know whats coming next - why then the company A filter!!

I think I need to have a think how to explain this better!:crazy:

Cadavre (4/3/2012)

---

I may be oversimplifying what you've said but. . .

You said. . .

Andy Hyslop (4/3/2012)

---

every row where CompanyA = 1 and CompanyB = 1 & 3 and where the...

It depends I've seen warehouses where the staging tables are contained within the main DW and also (my...

You can't alter a column and add IDENTITY, You have either create a new table or drop the column and re add with the IDENTITY property

Andy

Koen Verbeeck (4/3/2012)

---

The Kimball books are about design and architecture of a data warehouse.

They are technology independant, so it should be your first read if you really want to go...

You may also find these useful:

http://www.amazon.com/The-Microsoft-Data-Warehouse-Toolkit/dp/0470640383/ref=sr_1_6?s=books&ie=UTF8&qid=1333442957&sr=1-6

http://www.amazon.com/The-Data-Warehouse-Toolkit-Dimensional/dp/0471200247/ref=sr_1_1?s=books&ie=UTF8&qid=1333442957&sr=1-1

Andy

No probs 🙂

I've never had to do this, however the link below may help you (it was interesting looking into it however thanks 🙂 )

http://blog.hoegaerden.be/2011/01/18/ssrs-hideshow-items-dependant-on-export-format/

Its not quite the same as what you...

When you choose to use the SQL Server package configs SSIS...

Hi Anthony

Just a thought as I have only worked with XML configuration files a couple of times but have you tried using the SQL config tables instead of XML...