I am a huge fan of SQLShare.com. The site publishes SQL server related videos. Easily go from ‘Zero to Hero’ with this site. Most videos range from 2-3 minutes. Topics range from advanced to beginners. The. It is easy to learn SSIS, SSAS, performance tuning, administration and other skills from top-tier presenters like Brian Knight, Andy Warren, Jessica Moss, Grant Fritchey and Devin Knight.
The complete searchable list of videos is here. The ‘Watch It later’ playlist is great. I would suggest subscribing to the site’s RSS feed for the latest videos. If you want to do more than watch, they have an open call for video authors. Submissions are reviewed prior to posting. If accepted, they will pay for the material. WIN!
Categories: Programming, Reporting/BI, SQL Server, SSRS, t-sql, Video Tags: Free, Learning, SQLServer, ssas, SSMS, SSRS, training, Video
Found this reference … JUST IN TIME!
Thanks Thavash
http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!155.entry
April 10
Working with Dates in Reporting Services
As with any other technology ( eg. SQL , C# ), you always find people running into problems with processing of dates. I was asked today by a colleague “How to I format dates when using the Date Picker and sending it through to a stored procedure” ? Let’s have a look ….
1) The FormatDateTime command
This is pretty easy to use, but maybe a bit limiting. You can specify 1 of 4 formats using the command arguments. Let’s say we have selected a date such as 10th April 2007 , our results will be as follows :
| Command |
Result |
| FormatDateTime(Parameters!Date.Value,1) |
Tuesday, April 10, 2007 |
| FormatDateTime(Parameters!Date.Value,2) |
4/10/2007 |
| FormatDateTime(Parameters!Date.Value,3) |
12:00:00 AM |
| FormatDateTime(Parameters!Date.Value,4) |
00:00 |
…but the better way to do it would be to use …
2) The Format command and specify the exact format you require. For example…
| Command |
Result |
| Format(Parameters!Date.Value,”dd-MM-yyyy”) |
10-04-2007 |
| Format(Parameters!Date.Value,”dd/MM/yyyy”) |
10/04/2007 |
| Format(Parameters!Date.Value,”MMM-dd-yyyy”) |
Apr-10-2007 |
| Format(Parameters!Date.Value,”MMM-dd-yy”) |
Apr-10-07 |
So 3 M’s give you “Apr” ….anyway this is quite useful if you’re looking for Day/Month/Year , since the system will default to MM/DD/YYYY.
Using this you should be able to display the date format you want , or send through a particular format to a Stored Proc.
EDITED 22/08/2007 : If the Format Command doesn’t work , try converting the value to a date , eg.
| Format(Cdate(Parameters!Date.Value),”dd-MM-yyyy”) |
Categories: DotNetNuke, OS, Programming, Reporting/BI, SQL Server, SSRS, t-sql Tags: Date format, DEVELOPER, How-to, Learning, SSRS