Paginación en SQL Server 2005 o superior

select

Resultado.*

from

(

select

[tradeName],

[rfc],

ROW_NUMBER() over (order by m.[tradeName], m.[rfc]) as RowNum

from

[vwCompany] m

)

Resultado

where

RowNum between 10 and 20

order by

[tradeName], [rfc]

donde 10 y 20 se refieren a los registros que se quieren de vuelta.

Parallels no corre en Lion

Ejecutar estas lineas en una terminal y listo

sudo kextutil "/Library/Parallels/Parallels Service.app/Contents/Kexts/10.6/prl_hypervisor.kext"

sudo kextutil "/Library/Parallels/Parallels Service.app/Contents/Kexts/10.6/prl_hid_hook.kext"

sudo kextutil "/Library/Parallels/Parallels Service.app/Contents/Kexts/10.6/prl_usb_connect.kext"

sudo kextutil "/Library/Parallels/Parallels Service.app/Contents/Kexts/10.6/prl_netbridge.kext"

sudo kextutil "/Library/Parallels/Parallels Service.app/Contents/Kexts/10.6/prl_vnic.kext"

Generación de certificado para server y cliente

makecert -pe -n "CN=SSLTest Root Auth" -ss my -sr LocalMachine -a sha1 -sky signature -r "SSLTestRootAuth.cer"

certmgr -add -all -c "SSLTestRootAuth.cer" -s -r LocalMachine Root

makecert -pe -n "CN=localhost" -ss my -sr LocalMachine -a sha1 -sky exchange -eku 1.3.6.1.5.5.7.3.1 -in "SSLTest Root Auth" -is my -ir LocalMachine -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12 localhost.cer

makecert -pe -n "CN=Axayacatl, O=SSLTest Cliente, OU=Desarrollo, E=jaraujo@advantagesecurity.com, C=MX" -ss my -sr CurrentUser -a sha1 -sky exchange -eku 1.3.6.1.5.5.7.3.2 -in "SSLTest Root Auth" -is Root -ir LocalMachine -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12 -# 25000000 Axayacatl.cer