Home Forums SQL Server 2008 T-SQL (SS2K8) Importing only rows with column data in specific columns. RE: Importing only rows with column data in specific columns.

  • September 7, 2012 at 9:48 am

    #1535146

    Phil Parkin (9/7/2012)

    Lynn's solution is the way to go.

    In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised data is being selected.

    If you wanted to do the entire thing in SSIS, that is also possible, though quite advanced, through the use of an asynchronous Script Component. Advanced ... and slower - but possible.

    Should read:

    In her his solution, basedata is a CTE - effectively a subquery in this case - from which the normalised data is being selected.

    Not a biggie, happens rather frequently.