Does anybody know if it is possible to create indexes on TABLE variables?
(Using SQL Server 2000)
If so, can it be done with a simple CREATE INDEX statement or am I limited to the constraints available when declaring the variable?
Thanks in advance,
Ben
Ben Sugden
"Remember to enjoy hunting - and that means relishing the search for the product that has never been advertised or placed handily at the front of the shop; Life begins on the uppermost shelf, avoid guide books and top 10's like the plague." - Ramsey Dukes
