Microsoft SQL Server blog of Ritesh Shah. Mainly focuses on query tuning & optimizing, set based T-SQL, stored procedures, Functio..
| Home | My Account | Directories |
For XML PATH ROOT in SQL Server 2008
Published on 2010-08-18 01:25:00
Now and Then I used to observe that when it comes to XML, .NET and SQL Developer start fearing. This is not because of It is VERY DIFFICULT but because of unawareness. Today I am going to show you the use of “FOR XML PATH” clause in SQL Server. Suppose we have ID, FirstName and LastName columns in one of our SQL Server table and we want output something like this:<Employees> <Employee> <ID value="1" /> <FirstName valu
Character Map Transformation task in SSIS 2008
Published on 2010-08-10 05:45:00
When it comes to string formatting in SSIS, “Character Map” transformation task is one of the very useful tasks. It generally used to convert data to Uppercase, lowercase, byte reversal etc. let us see one small demo for the same.Before we start our package development, let us first create one small table in SQL Server and insert some data into it by following TSQL Script.create table Employee( FirstName varchar(10), LastName varcha
Fuzzy lookup in SSIS 2008 to keep data integrity
Published on 2010-08-05 04:08:00
“Human makes mistakes” which is quite obvious. While making a data entry it is possible to make typo but as a database professional, it is our duty to keep data consistent. Fuzzy Lookup is helpful in this case. Before we start making package in SSIS, let us have some pre-preparation for that. We are going to create one source table (it could be any source like excel, csv file etc. but we are making it in SLQ Server), one reference table which is guaranteed to have proper data. Here is
