Hi

Exactly same tables and data. But instead of having 'week1', 'week2' etc as columns I would like to have dates for example '01.04.2013', '02.04.2013', etc. I need to be able...

What about if I want same scenario between 1.4.2013 and 14.42013? So each day within this date range is displayed as column?

Brilliant!!

That's what i needed.

Thanks a lot!

all fixed

used temp tables in stored procedure

Hi

Thank you for your reply

It is nearly exactly how I wanted.

Where should I put WHERE clause to be able to add SupplierID parameter? I need to get exactly same output...

i dont need supplier id sorry ignore it pls

dont need supplier id guid sorry, ignore it

I need count of impressions and clicks for supplier(only one supplier at the time) grouped by Month/Year (fromSupplierImpressionDate/SupplierClickDate)

SupplierId will not be in output, it is parameter (where clause i think)

CREATE TABLE [dbo].[tbl_supplier_impressions](

[SupplierImpressionId] [int] IDENTITY(1,1) NOT NULL,

[SupplierId] [uniqueidentifier] NOT NULL,

[ImpressionDate] [datetime] NOT NULL,

CONSTRAINT [PK_tbl_supplier_impressions] PRIMARY KEY CLUSTERED

(

[SupplierImpressionId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =...

sorry, jusr red article

table_impressions

CREATE TABLE [dbo].[tbl_supplier_impressions](

[SupplierImpressionId] [int] IDENTITY(1,1) NOT NULL,

[SupplierId] [uniqueidentifier] NOT NULL,

[ImpressionDate] [datetime] NOT NULL,

CONSTRAINT [PK_tbl_supplier_impressions] PRIMARY KEY CLUSTERED

(

[SupplierImpressionId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Hi

I am trying something like this http://demos.telerik.com/aspnet-ajax/chart/examples/databinding/database/defaultcs.aspx

top chart.

I havent got anything written yet, quite new to sql

table_impressions

impressionid | SupplierID | ImpressionDate

1 | 1 | 2012-01-01

2 | 1 |...