Database

set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Thabo
-- Create date: 18.02.2011
-- Description:	TEST XML
-- =============================================
CREATE PROCEDURE [dbo].[sppassingStoredProcedue]
AS
DECLARE @x XML 
BEGIN

	SET NOCOUNT ON;
	SET @x=(SELECT PramryKeyForThisTable,AutoNumberColumn,Data1,Data2,Data3 FROM tblInsertTableForAutoNumber FOR XML AUTO,ROOT('MYROOT'))

INSERT INTO CopyOftblInserTableForAutonumber 
SELECT
	R.Tab.value('@PramryKeyForThisTable [1]','SMALLINT') AS PramryKeyForThisTable,
	R.Tab.value('@AutoNumberColumn [1]','SMALLINT')AS AutoNumberColumn,
	R.Tab.value('@Data1 [1]','VARCHAR(50)') AS Data1,
	R.Tab.value('@Data2 [1]','VARCHAR(50)') AS Data2,
	R.Tab.value('@Data3 [1]','VARCHAR(50)') AS Data3
FROM @x.nodes('//MYROOT/tblInsertTableForAutoNumber')AS R(Tab)
	
	
END 

select * 
from  orders a
where a.customer = 'A'
and ( a.id in (select top(2) id
	       from  orders b
               where b.customer = a.customer
               and   b.id       < 26
               order by b.id desc)
   or
      a.id in (select top(3) id
	       from  orders b
               where b.customer = a.customer
               and   b.id       >= 26
               order by b.id asc))

Brady Kelly wrote:

but insanely undocumented.

SELECT * FROM sysColumns WHERE id = (select id from sysObjects where name = 'myTable');

where file in ('%pdf', '%rtf', '%doc')