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 10, 2012 at 9:57 am

    #1535790

    Phil Parkin (9/10/2012)

    Lynn Pettis (9/7/2012)

    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.

    Eek, I apologise for this!:blush:

    Like I said, not a problem. It happens regularly with me, in fact it happened this weekend before a soccer game I was officiating. One of the other refs though we were waiting for a lady to join us while the third official was working the game before ours.