NO you don't but it may be easier to maintain

In any case if you don't want to create the table just use:

declare

  @start...

David's Solution is OK as long as you have CONSECUTIVES Ids . If you don't then you can:

DECLARE @strLPriceName varchar(100)

SELECT  @strLPriceName = ''

UPDATE PriceName

SET @strLPriceName = PriceName = CASE...

That data IS written to disk. It goes to the Transaction Log. When you commit it is moved to the database file (at checkpoint time) when you roll it back...

Tables per select: 256

For a comprenhensive list look for :Maximum Capacity Specifications in BOL

HTH

Hansje 

Can 1 expect a similar situation with Access, Word? ASCII's? Oracle(shivver)?

That situation is particular for the jet Engine(Microsoft.Jet 4.0.OLEDB ). If you...

Stefan.

I had some problems like those a long time ago. It's a shame I can't remember what was the solution.

What I meant by using another field is:

Suppose you can...

select A.*

from TableA A LEFT JOIN TableB B

ON A.ID = B.ID

Where B.ID IS NULL And (A.CDate BETWEEN date1 and date2)

Jack,

You  got the Idea

Ok, I am assuming you want to let a login who is not part of sysadmin view the job history.

First you must configure the proxy account for the SQL Sever...

when you use variables the plan can vary a lot depending on the number of records returned. If for example the query is very selective (very few rows)  you may end...

DELETE from [SYSTEM].[INSTANCE_REF] WHERE INSTANCE_ID = @nINSTANCE_ID OR PARENT_INSTANCE_ID = @nINSTANCE_ID

I am assuming this is a Self referenced table, Right?

if the answer to the above question is yes READ...

OR If you can live with undocummented functions

DECLARE @str char(32) , @int int, @backToChar char(32)

SET @str ='10100101101001011010010110100101'

select  @int = fn_replbitstringtoint(@str)

select @backToChar = fn_replinttobitstring(@int)

SELECT @backToChar ,@str ,@int

DECLARE @str char(31) , @int int, @backToChar char(31)

SET @str ='1010010110100101101001011010010' -- Only 31 Bits

-- To Int

SELECT @int = ISNULL(@int,0) + CASE WHEN Substring(@str,number,1)...

I don't have sql 7 here but I thought that information_schema.* where views that extracted system tables information.

Are you saying that if  I upgrade a db from 7 to...

This may give you a little more than what you asked for but it is simple and easy to use: 

DBCC SHOWCONTIG WITH TABLERESULTS , ALL_INDEXES