Thanks Guys

It works well now :):-P

Hey Thanks a lot guys. Just tested the query and it runs fine! 🙂

And thanks to everyone for pointing me to the right direction of posting the ddls for my...

Yes thats right.

I need to rank it on totalcost

Hi Friends

Here is the ddl

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [#temp11](

[test_name] [nvarchar](50) NULL,

[Calendar_year] [int] NULL,

[Calendar_quarter] [int] NULL,

[TotalCost] [money] NULL

) ON [PRIMARY]

INSERT INTO #temp11

(test_name, calendar_year, calendar_quarter,totalcost)

SELECT 'test1',2008,1,3444.20 UNION...

I am not sure what you mean by the 'coded answer'

But I will surely post the ddl shortly

Hi

Thanks for ur query.

I apologise I did not make it very clear the first time...

I dont want to calculatethe percentage by highest and lowest values...

I want to do it...

Hi

When I try to import an access database using import/export wizard in management studio and try to browse the location of the database, sql does not recognize the access...

This query works fine.

There were some issues in my database.

Thanks

Hi

Thanks for your reply.

I tried your query but there are still few patient IDs appearing in the result who have been on both type of Drugs..

Here is the sample data

USE [main table]

GO

INSERT INTO [main table]([Drug name],

[calendar year],[calendar month],[quarter],[patient id])

SELECT 'typeA' ,2000,1,'q1','ac1'

UNION ALL

SELECT 'typeA' ,2001,2,'q1','qwe2'

UNION ALL

SELECT 'typeB' ,2000,1,'q1','ac1'

UNION ALL

SELECT 'typeB' ,2005,12,'q4','bgresd'

UNION ALL

SELECT 'typeB',2001,2,'q1','qwe2'

GO

Here is the...

Hi Here is the actual DDL:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Main Table](

[Drug name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Calendar year] [int] NULL,

[Calendar month] [int] NULL,

[Quarter] [nchar](10) COLLATE...

Table A

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[DrugA]

AS

SELECT year1, month1, Quarter,[Patient No.]

FROM MainTable AS a

WHERE ...

Hi

Thanks for replying.

I tried adding a border on the body of the report using properties but that border is not visible when I preview it

The code works fine in the Management studio.

But when I use the same code in the reporting services, it gives the error for the 'CTE'.

The error says 'CTE is not...

Hi Guys

SOrry I did not send you the actual script in my post:

Here it is

USE [DATA]

GO

/****** Object: Table [dbo].[MainTable] Script Date: 06/15/2009 14:07:06 ******/

SET ANSI_NULLS ON

GO

SET...