You can use you're own custom style sheets.

This article explains how:

http://msdn.microsoft.com/en-us/library/ms345247.aspx

Here's a good article which might help you:

http://blogs.msdn.com/b/kenobonn/archive/2013/05/15/code-snippets-in-sql-server-2012-for-greater-team-productivity.aspx

You might also want to check out the Snippets generator utility

http://snippetsgen.codeplex.com

Yes you can use one dataset for several items (tablix, charts, sparklines etc.) in a report.

If you're using SSRS 2008 R2 or 2012 you can also create a shared...

Looks like you're using a maintenance plan for your backups. In that case check the maintenance plan history or the maintenance plan logfile for the exact error details.

Hi Jason,

nice work.

Not sure if I understand your requirement correctly but I think this should work:

SELECT

CASE WHEN DATEDIFF(hh,[WalkinTime],[Validated AppointmentContactEnded]) < 4

THEN 1

ELSE 0

END

Just use the COLLATE function.

http://msdn.microsoft.com/en-us/library/ms184391(v=sql.105).aspx

deebabat (4/19/2012)

---

BEGIN CATCH

insert into tblDownload_Import

(Description) values ('error: ' + ERROR_Number() + ' msg: ' + ERROR_Message())

...

Yes, I think it's still a little bit early for some books.

But if you're interested in getting an overview aboout the new features in 2012, this might be interesting...

Select the "SeriesProperties" for your chart, Go to "Fill"

Under "Pick color" enter an expression similar to this:

=Switch(Fields!InstanceStatus.Value="Failes", "Red", Fields!InstanceStatus.Value="Pending", "Yellow", Fields!InstanceStatus.Value="Pass", "Green")

This script might help

http://www.sqlservercentral.com/scripts/Administration/61219/

Yes it is possible and if you search around on the internet or the script seection of this site, you should find lots of examples.

As I said, it was something "similar". My need was to find...

I agree with Sean, you could do this using dynamic SQL. In fact I myself just wrote something very similar today.

But there might be another, smarter way of doing...

First of all then you right-click on...