CREATE TABLE [dbo].[Product_Table](

[Product Id] [char](10) NULL,

[IsPrimary] [int] NULL,

[Quantity] [numeric](18, 0) NULL

) ON [PRIMARY]

INSERT INTO Product_Table ([Product Id], IsPrimary, Quantity) VALUES ('P001', 1, 0)

INSERT INTO Product_Table ([Product...

Sorry for the inconvenience.

Since my table did not got pasted properly, i have attached screen shot in below link

please help

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ac200b96-4d36-4832-bd86-250cd3b1c1a0/display-last-row-in-subgroup-and-calcuate-dynamically?forum=sqlreportingservices

Thanks.. its working !

can you let me know why you have used

HAVING COUNT(*) = 4

CREATE TABLE [dbo].[fact_sales](

[sales_id] [bigint] IDENTITY(1,1) NOT NULL,

[Product_ID] [bigint] NOT NULL,

[agent_id] [int] NOT NULL,

[product_code] [varchar](50) NULL,

[created_by] [int] NULL,

[created_date] [datetime] NOT NULL,

[modified_by] [int] NULL,

[modified_date] [datetime] NULL,

CONSTRAINT [PK_answer] PRIMARY KEY CLUSTERED

(

[sales_id]...

when i run the below query i get error

Conversion failed when converting the varchar value ' | | |0|0|0' to data type int.

-- alternative version

SELECT Product_ID

FROM (

SELECT f.Product_ID, agent_id,...

Getting error :

Conversion failed when converting the varchar value ' | | |0|0|0' to data type int.

ChrisM@Work (3/20/2013)

---

Depending upon existing indexes, this could be a significant improvement:

DROP TABLE #fact_sales

CREATE TABLE...

i got the soln.. by using filespec

thanks

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181108

just look this site

http://www.codeproject.com/KB/database/IndexIn2005.aspx

Respected Mr. Newbie

Same Error .... Pls help... the verion in server is 8.0 my pc is server 7.0

may this be the reason?

 

exec sp_attach_single_file_db @dbname = 'Envnew',

 @physname =...