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.

  • Why not start with something like this to build your query or inserts around...?

    SELECT name,addy,ph,subject,grade

    FROM #test CROSS APPLY (VALUES('subject 1',grade1),('subject 2',grade2),('subject 3',grade3),('subject 4',grade4),('subject 5',grade5)) AS x(subject,grade)