Browse by Tags

• datetime
• function
• iif
• ISDATE()
• query
• report builder
• reporting services
• storage

Dynamic formatting within the reports using TSQL?
03 October 07 02:56 AM | SQL Master | 2 Comments   

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking the dynamic reporting within the Reporting Services. Here it goes, the task is to change/highlight the color of a row, based on its value. Therefore, Read More...

Filed under: tsql, sql server, results, report builder, reporting services, storage, iif

Handle ISDATE() with care
24 September 07 07:09 AM | Madhivanan | 2 Comments   

Now-a-days it became common practice for newbies to varchar datatype to store dates. My first advise is to use proper DATETIME datatype. Sometimes it is preferred to use varchar when importing dates from other systems(to avoid any errors if the source Read More...

Filed under: function, tsql, sql server, query, ISDATE(), results, datetime