Oh God!!!

I really dont believe this..My message has been read more than 650 times and there is still no comment or solution :):):)

I should enter getdate() (or another date value) as an input parameter. The sub-process final dates will vary based on this input parameter.And there should be a recursion in this...

Yessssss...You are EXACTLY right...

It works like a machine..

Thank you very much for your PERFECT solution

You can see your query result at the file you sent 🙁

I am not an SQL expert but I really wonder is this really so difficult case?

Thanks for your reply..Bu there are still duplicate values on same rows 🙁

Thank you very much

Hello Again,

How can I prevent duplicate values on a row without using Primary keys?

For example you can easily see that Sales price2 and sales price3 are same.How can I prevent...

Thank you very much...It work perfect...

🙂

Good cooking....)

USE [TEST]

GO

/****** Object: Table [dbo].[tblSales] Script Date: 02/17/2008 18:13:39 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblSales](

[SalesDate] [smalldatetime] NULL,

[StockCode] [nvarchar](50) COLLATE Turkish_CI_AS NULL,

[costPrice] [int] NULL,

[SalesPrice] [int] NULL,

[SalesAmount]...

Thank you

🙁

Ok...You are exactly right...

I have attached a text file.This is my SELECT query results.

My purpose is to create another table that holds Sales Price value changes..(I will follow just 5...

Thank you very much for your replies...At least, you replied this question 🙂

My final data report should include just six columns:

StockCode

SalesPrice1

SalesPrice2

.

.

SalesPrice5

That's all..

Hi Again,

Finally I have found a stored procedure that dynamically creates a crosstab report.SP is like this:

CREATE procedure sp_CrossTab

@tablename ...

ok?

is it ok now?