What's very important for that exam is the order in which you do things.

E.g.:

* what are the steps to set-up mirroring

* what are the steps to set-up always-on

* what are...

SAP is still a major vendor and SAP people tend to get paid OK.

So it's not necessarily a bad idea to learn the BI products of SAP.

Besides, it is still...

The easiest solution is that you have a column in your time dimension that indicates the last month. Then you can simply filter on that column.

shield_21 (10/27/2014)

---

Got job opportunity for SSIS Developer. Also have another for Database Developer but haven't started the process. With SSIS Developer, salary will be lower than the DB Developer.

Which one...

If the unique index is not a filtered index 😉

Easy question, thanks!

On second thought: the CSV option is the text file. But it has the .csv extension of course, but you can change this yourself in the "Save As" menu.

If you...

Check the configuration file of SSRS to see if it is enabled.

How to show/hide rendering extensions (export formats)

Did you run IE as administrator?

Maybe some explanation what you are trying to do is needed.

Preferably in the form of table DDL, sample data and desired output.

See the link in my signature about asking questions.

mohammedaala (10/27/2014)

---

Yes I have installed Sql Server 2008 R2 and also SP3 and SSRS is working fine but SSIS package coming errors. I have already posted with attachments. But still...

Tony Bater (10/27/2014)

---

Thanks Koen,

I followed your link and used the steps there...

1. Restart SQL Server in single user mode

2. Start SSMS as administrator

3. Connect to SQL Server using object explorer

It...

CREATE PROCEDURE (Transact-SQL)

There are examples at the bottom.

I did it on my previous laptop without...

I would insert the result sets from both SPs in temporary tables and then simply join them together.

INSERT INTO #temp1

EXEC SP1;

INSERT INTO #temp2

EXEC SP2;

SELECT *

FROM #temp1

JOIN #temp2 ON ...