You can't put a list (2011, 2012) into an int!

If you want to select multiple years, you will need to look at changing your stored proc to accept a varchar...

What I want to do to compile the data, is to import the results of Table A, up until a cutoff point of December 4th, 2008. This is where the...

Thanks everyone, the report is working and I appreciate all your help.

Thanks Lynn, I apologise if I am going about this all wrong, please bear with me.

Here is the Create table query:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[#mytable](

[Sector] [nvarchar](255) NULL,

[Region] [nvarchar](255)...

Thank you for your help, as it stands I have never tried the Self Join as of yet, much appreciated.

I apologise if I didn't make myself clearer before, but what...

Thanks for your help, but all the data is in one table.

Is there another way to script it without using joins?

Here is another sample of the table, what I need to know is how to script the query for the percentage change of current month from previous month, i.e. Jan...

Attached is the table, I am trying to get a comparison of each month % changes from 2010 to 2010.

Although, since it is only January, I can only do this...

Thank you so much, I was also trying the ISNULL function, but couldn't get it in the right spot!

where specifically in the query should i use the Collate function?

I already have it in the middle part of the query.

There are two databases called OCC and OCC_ARCHIVES.

OCC has the collation setting Latin1_General_CI_AS

- tables MCommOpenOrders, tbl_R15OrdersToday and Zones are under this database

OCC_ARCHIVES has the collation setting Latin1_General_CI_AI

- table tbl_R15_analysis...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ZONES](

[ZoneProfile] [varchar](20) COLLATE Latin1_General_CI_AS NULL,

[Dispatchareas] [varchar](20) COLLATE Latin1_General_CI_AS NULL,

[Dispatchregions] [varchar](20) COLLATE Latin1_General_CI_AS NULL,

[Sector] [varchar](20) COLLATE Latin1_General_CI_AS NULL,

[TierC_Group] [varchar](10) COLLATE Latin1_General_CI_AS NULL

) ON...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[MCommOpenOrders](

[JOBID] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SERVICEORDERNUM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[DUEDATE] [datetime] NULL,

[ORIGINALDUEDATE] [datetime] NULL,

[JOBSTATUS] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[DISPATCHUNITID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[STATUSUPDATEDBY] [varchar](15)...

Hi,

It's actually a View, not a table.

I don't think it has restricted rights, I am logging in throught Management Studio as well.

Hope this helps.