I guess I'm an iconoclast here, but, if these types of property are fundamentally different (as land and cars certainly are), I would not have a "tblProperty" at all, but...

select CAST(e.EmpID AS varchar(8)) + '/' +

RIGHT('000' + CAST(

(SELECT COUNT(*)

FROM Cars

WHERE EmpID = e.EmpID AND CarNumber <= c.CarNumber)

AS varchar(3)),3) ECarID,

e.EmpName, c.CarNumber

FROM Employees e JOIN Cars...

Use the Client Network Utility. In the Alias screen, add an alias using the TCP/IP network library. Put the server's name in the "Server alias:" textbox and type 127.0.0.1...

Don't know Crystal, but, assuming this can be done in scope, use your front-end to insert the vendor numbers into a temporary table. Then have your SP use that...

CREATE TABLE Days(doy smallint)

declare @i smallint

set @i = 0

while @i < 366 begin

insert Days

values(@i)

set @i = @i + 1 end

DECLARE @StartDate datetime

SET @StartDate = '20030922'

SELECT @StartDate + d.doy Date, SUM(ISNULL(No_of_Items_Sold,0))

FROM...

quote:

---

To know the amount of statistics '_WA_', I use :

select o.name as Nom_Table, i.name as Nom_Index, i.indid, i.dpages * 8 as Volume_Ko

from...

quote:

---

Thanks for the quick response.

It works. ( but I need to comment out the last line, otherwise it gives error about SalesAmount).