Tag Archive: CROSS APPLY

Get_That_Free_Profile_Data_Into_Your_Database

Get that Free Profile Data Into Your Database

so you can report off of it. Note: I actually profile my Databases completely different than what is presented here, but this information might be useful to someone else. If you have Microsoft SSIS, then you can take advantage of… (READ MORE)

Data Management

, , , , , , , , , , , ,

data-integration-sql-xml-cross-apply

Transformation Pattern with SQL, XML and CROSS APPLY

You don’t have to live with the repeated pain of transforming xml to rowset values when you need data from xml data stores. You also don’t need to transform and copy the data to relational database┬átables in MS SQL Server… (READ MORE)

Data Management, Most Popular

, , , , , , , , , , , , ,