Recently I have read a lot of Blog posts on how to export files in different formats. But I use a custom procedure which exports text files in Pipe Delimited format using BCP.This procedure can be used in other processes for Output and Error Handling. Here is the Script for the procedure.You can modify the [...]
Sep
23
2009
23
2009
Sep
17
2009
17
2009
Reporting Services Date Format
Many Clients have varied Requirements for Dates. You can do the conversions in Date format using T-SQL from the following link in MSDN. In reporting services you can convert datetime using the customs visual basic datetime formats using Expressions. Here are the following links on MSDN for Visual Basic Datetime Formats Predefined DateTime Formats Using [...]
Sep
8
2009
8
2009
Report Server Names for Instances
If the sql server reporting services is configured on the server called “SQLBOX” then the URL is http://SQLbox/reports. If there is a named instance like SQLBOX\VIVEK then the reporting server URL is http://SQLBOX/reports_vivek
Sep
8
2009
8
2009
Problem with SQL Server numeric data : Error converting data type varchar to numeric.
Today I stuck with an interesting problem of converting number data in Varchar fields to numeric datatypes. I have created the following sample data The data in the table contains Decimal and scientific values in varchar format as shown in the figure below. Now when I tried to convert the above values to numeric as [...]
Sep
8
2009
8
2009
Twitter Accounts of BI Experts
Here are the list of Industry BI Experts and their Twitter User accounts http://spreadsheets.google.com/ccc?key=ppfitTGNfaCuf1l9u4Au4JQ
