Goran

Posts authored by Goran
Bookmark and Share
Calculating minutes between two points in SQL
Rated 5.00, 1 vote(s). 
In today's article, I'll post a very interesting function. It calculates the number of minutes between two points in time. Did I hear you say "Lame, I can use DATEDIFF function for that!!!"? Well, what my little function does, other than calculating minutes between two points in time, is that it works for a given "time window" and DATEDIFF in it's default form is not enough for that.
Bookmark and Share
SQL Server 2008 – Date&Time tips and tricks
Rated 5.00, 2 vote(s). 
In this article, I will show you a couple of SQL code snippets related to Date&Time in SQL Server 2008, including date formatting and comparison scripts. I hope you will find them useful. 
Bookmark and Share
Drill down in SQL Server Reporting Services 2008
Rated 5.00, 3 vote(s). 
SQL Server Reporting Services offers a lot of functionality out-of-the-box. There are times, however, when you need to understand some of the subtleties of the report designer to get the right results. This time we will learn how to implement a drill down feature to navigate through large chunks of data.
Bookmark and Share
Parsing a delimited string in SQL Server
Rated 5.00, 1 vote(s). 
This tutorial will teach you how to write a custom SQL Server function for parsing delimited strings. It is particullary useful if you are passing a parameter that contains multiple string values to be used as a filter for “IN” expression in SQL.