Is it possible to make a query to have a counter which would have
a sequential number of each record in the query starting with 1?
Thanks,
Michael

We're trying to dump our remaining v7 SQL server and update to 2000.
We're having trouble with a trigger updating some tables.
At the beginning, it has this statement:
COMMIT TRANSACTION  --This unlocks the Lot table so I can update UDAs,

Hi, I'd like to create a SP like this:
SP_Table1_LOAD
Update Table1 set... (alter existing rows)
Insert Into Table1... (insert new rows)

I can't figure out why i have a bookmark lookup cost on ValidVendorPackages
on the below proc:
Select PriceViewHotelPrice.price as Totalprice, PriceViewHotelPrice.Docid
from price_view PriceViewHotelPrice Inner Join

I have a table as follows:
Code       Quantity      Status
ACC1       50            Dispatched
ACC2       31            Dispatched

I have a proc that can specify a price range if its passed in.
my and where clause looks like this:
where ((PriceViewHotelPrice.price  + PriceViewAirPrice.price)between 500 and
600) or(NULL = NULL))

I am having a table ,
acct   dramt      cr_amt
101      5
103       5