Picture alignment in SQL Reporting Services

Posted on 8 CommentsPosted in Database, Development, Reporting Services

Ever wondered how to dynamic align pictures in SQL Server Reporting Services? I have for sure needed it often. Untill now I’ve allways answered no to requests for this. The solution can be used when creating reports in SQL Server Reporting Services with dynamic pictures in different sizes based on variables inside the report. In this article the pictures will be aligned right and these are stored in a FileTable on a SQL 2012 instance – you can also do this with other types of picture storage in Reporting Services. Well here it goes: For starters you’ll need a parameter to hold […]

Will not get stuck in date formatting again

Posted on Leave a commentPosted in Database, Development, T-SQL

You’ve all been there, you’ve all banged your head against the monitor just because you could not remember that code for the specific date-format you needed. I know I have. I SQL 2012 this is no longer such a headake to remember all those codes – JAY! Ex. from SQL 2008 R2 and older: SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY] –Italian SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY] –German SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] –USA And with the codes specific for each country format needed.   Now in SQL 2012 we are all free to try to memorize those codes […]