Appreciate that IIF is new in 2012, just with it being in a 2008 forum, I automatically assumed IIF = SSRS IIF not a SQL IIF.

Hence why it is always...

The stairways section, goes from basic up to detailed information on SSIS http://www.sqlservercentral.com/stairway/72494/

What you want seems pretty basic.

You need 2 connection managers, 1 Excel which points to the xls file,...

CASE Rank WHEN 1 THEN 'Gold' WHEN 2 THEN 'Silver' ELSE 'Bronze' END AS RankColour

So your after something like the above?

IIF wont work in SQL as its not a SQL...

Then I would ask that you post the table definition, some sample data and what the expected outcome should look like on the report.

The same way you would run it via SSMS

SQLCMD -S server -E "EXEC dbo.CreateDatabase @DBName = 'DatabaseName', @DataPath = 'C:\data\Databasename.mdf', @LogPath = 'C:\log\Databasename.ldf'"

Lokesh Vij (1/29/2013)

---

As rightly pointed about Anthony, this is bit tricky as there is no identifier on the rows. Here is another way of deleting duplicate records using CTE:

WITH DelDup

...

In an expression you need to refer to the column as a Field using Fields! then you give it the field name so Fields!Rank then you get the property, in...

Look at cast or convert using a date style http://msdn.microsoft.com/en-us/library/ms187928.aspx, style 100 or 109 may be the ones to go for.

no longer applicable

Expected behaviour of SQL

Read the following article http://msdn.microsoft.com/en-us/library/ms187928.aspx, especially the Truncating and Rounding Results section

Inserting a 4 digit INT into a 3 character length string, returns * detailing result length...

You need to qualify what Rank is, if its a field in a Data Set then you need to do something like the below.

=IIF(Fields!Rank.Value =1,'Gold', IIF(Fields!Rank.Value =2, 'Silver', 'Bronze'))

You may want to look at alternatives like a SMARTboard, or a AcitvBoard by Promethean (disclosure, I work for them) which you can just hook a PC into.

Bit tricky as you have no identifer on the rows

SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2 ORDER BY Col1, Col2) AS RowNumber,

Col1, Col2

INTO #TEMP

FROM

DuplicateRcordTable

TRUNCATE TABLE DuplicateRcordTable

INSERT INTO DuplicateRcordTable (Col1, Col2)

SELECT...

Perry Whittle (1/29/2013)

---

anthony.green (1/29/2013)

---

Many thanks for that, as I have not worked with mount points before (well not to my better knowledge) I was un aware of that, added to...

Its just a table we have in our monitoring database which contains the list of email addresses for different alerts.

So you just need to replace it with the email addresses...