SQL Archive
-
T-SQL Tuesday (Date/Time Tricks) – Project Time Reporting Hack in SSRS
A HOW TO illustrating a method to display project time data in SQL Reporting Services. While there is no native GANTT chart control in SSRS 2005/2008, you can still do this with a little creativity and determination. -
Advanced String Building Expressions in SharePoint Workflows with SQL
Building a Dynamic String in a SharePoint workflow is severely limiting. You can only use placeholders, and forget about expressions like LEFT(), RIGHT(), REPLACE() or SUBSTRING(). It’s almost worthless. Not anymore. Not only can we do that now, but we can apply any T-SQL script or procedure in a SharePoint workflow.
