Hi, Today one of my colleagues in company faced a problem, He wants to split a text field by a delimiter character. This motivate me to write a Split function for my own use and put it here for help others. Suppose that our Primary Data is like this image and delimited by single slash Read more about T-SQL Split Function : Split Field By a Delimiter[…]
There are lots of times which you need a "Gregorian to Persian ( Shamsi ) Converter" in t-sql. below code will convert gregorian date string for example 2011-08-25 to persian or shamsi date string for example 1390-06-03 . just note this code will work on sql server 2005 or above because I used the Floor Read more about T-SQL Gregorian To Persian Converter[…]
Using dynamic t-sql is one of the good abilities in SQL Server, and there are times which you need to do this in SSIS. Suppose you have a data stream in SSIS Data flow task and you want to run a dynamic t-sql query per each data row values, probably your first stop is OLE Read more about How To Run Dynamic T-SQL In SSIS OLE DB Command[…]
I encounter a question today which was about using a Stored procedure inside a Data flow task, and use result of stored procedure which returned by output parameter beside other columns in Data Stream. Solution with sample: Suppose your stored procedure has an input parameter and output parameter. I show you a simple stored procedure Read more about Output Parameter of Stored Procedure In OLE DB Command – SSIS[…]