Skip to main content

Return to Answer

Post Timeline

(its = possessive, it's = "it is" or "it has".)
Source Link
Peter Mortensen
Peter Mortensen
  • 31.2k
  • 22
  • 110
  • 134

I would pass a table type parameter (since its 2008it's SQL Server 2008), and do a where existswhere exists, or inner join. You may also use XML, using sp_xml_preparedocumentsp_xml_preparedocument, and then even index that temptemporary table.

I would pass a table type parameter (since its 2008), and do a where exists, or inner join. You may also use XML, using sp_xml_preparedocument, and then even index that temp table.

I would pass a table type parameter (since it's SQL Server 2008), and do a where exists, or inner join. You may also use XML, using sp_xml_preparedocument, and then even index that temporary table.

Source Link
eulerfx
eulerfx
  • 37.8k
  • 7
  • 64
  • 85

I would pass a table type parameter (since its 2008), and do a where exists, or inner join. You may also use XML, using sp_xml_preparedocument, and then even index that temp table.