Jeff, a little issue with the Date used for weekly data

The daily data can be nasty.

For example I can get data for a week like these three cases:

1) Tue, Wed,...

Thanks Jeff,

1) Yes week and month is the same logic, just that the [Date] used is different

a) Weekly mut be a friday

b) month is last...

HI Jeff,

Max records : 40000

Average : 6000

My confusion comes, from the fact that I have posted many threads with BULK INSERT of data setups, with no troubles at all.

But i take your point, easier is...

..."Please provide ready to use sample data as described in the first link in my signature."..

But I have, I dont know what you mean, please be specific ?:w00t:

Thanks

The CTE1 and CTE2

Are you sure you have the order round the correct way, that is the 01/04/2000 record is divided by the 01/03/2000, that is new date divided by...

Roger that !, Thanks !:-)

Question

This code

ALTER TABLE #tempSumIndex

ADD PRIMARY KEY CLUSTERED (Date) WITH FILLFACTOR = 100

The FILLFACTOR = 100

My data could get into the 1000s of records,...

Thanks, I am all good. Thanks for help !:-D:-):-D

Thanks..

I did make changes

I changed the date from YYYYMMDD and INT field to a DATETIME field..

ALL seam to work ok, and YES I can read and understand TSQL.

So can I...

Thanks got it working...

Cheers dude !

The test data you use has DATE like this YYYYMMDD and is an INT

My real data has DATE like normal MSSQL date in a DateTime field ( like 23-07-2010 00:00:00,...

.."Do you want the "setup values" to be hard coded or should they be stored in a "setup" table somewhere? '..

The result set should be

SELECT Date,Value FROM @temp

NO need to...

Thanks for a response..

.." The .xls file appears to have only the "ADV" data. "

Sorry, more info for you to clear things up...in the XLS

B field is ADV: The number...

Is this all thats need?

GRANT EXECUTE ON [dbo].[MyProc] TO [MyRole]