Sean Lange (8/13/2013)

---

You do know that this violates the agreement for the exam right? Your page discusses exam content with things like the percentages of questions...

Good to know,...

You can check the syntax for IDENTITY INSERT here:

SET IDENTITY_INSERT (Transact-SQL)

I'd like to add that most of your issues can easily be solved by just reading the relevant pages on...

It works in SSRS 2008R2, so I would be suprised if they killed that "feature".

Did you try using the properties?

Script out all the stored procedures to .sql files, and then use a decent text editor to replace the database names.

1) Do you have some sort of company ID. There's no way for SQL Server to tell if Wiley Company and The Wiley Co. are actually the same. (you'd have...

I think it's usually around October-November. Last year it was in the beginning of November.

Never went myself though. Someday... 🙂

I can. What version of SSRS are you using?

Can you change it using the properties?

You can select multiple cells by holding ctrl or shift while selecting them.

You can only use that syntax once. The first time it will create the table.

The second time it already exists, so you will get an error.

For the 2nd till 4th...

Take a look at the PIVOT function.

Using PIVOT and UNPIVOT

karim.boulahfa (8/13/2013)

---

What I want. In the picture you see the 2 column 1 with a letter and other with number. I want to combine those to so if it is...

What is the result you expect?

--> Format(Fields!incident_ref.Value,"00000")

Are you sure the format function is OK? Is "00000" the formatting you need?

Ville Lucander (8/13/2013)

---

Ok, sounds reasonable. SSDT is 32 bit... but what does the project setting 'Run64BitRuntime' do then...? It affects somehow because Excel loads does not work if that is...

This is not possible.

Either you join the data sets into one data set, or you use the LOOKUP function.

More info in this thread:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/53c5d2b1-36e4-4ef8-9bea-48adbf0475b4/multiple-datasets-in-a-single-chart