Comments by SyedMHussaini (Top 2 by date)

SyedMHussaini 31-May-13 6:23am View

Changed my query to Create Temp table and it worked fine.

CREATE TABLE #Orders (
orderid INT NOT NULL,orderdate DATETIME NOT NULL,
empid INT NOT NULL,custid VARCHAR(5) NOT NULL,
qty INT NOT NULL,salesprice MONEY NOT NULL,
CONSTRAINT PK_Orders PRIMARY KEY(orderid)
);

ALTER TABLE #orders ADD
TotalSales AS (Salesprice * qty) PERSISTED

SyedMHussaini 23-May-13 6:28am View

The query just pulls inforamtion from only table. On the report the data gets displayed on page 1 and on page 2 the same data is again displayed.

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid