I'm no guru...but check this out, based on Adventure works

here is raw data for sales for every combo of customer and month

CalendarHierachy is my own user defined 3 level hiearchy...

David,

This series is absolutely top draw and this internal index stuff is great. As they say a picture is worth a thousand words, these diagrams and walkthrough you give explains...

Thx guys

I was caught cold on it. Someone throwing a curved ball my way...may be getting me to think out the box. At least its not an answer from the...

Hi George/Gazareth,

Thx for the prompt reply...point taken George...its just that it was so closely related...

will do next time

Hi Guys,

Mind if i jump in on this...its bit of a learning curve for and its a question for

both of you and its sort of related and since you seem...

hi Koen,

Just read yr post (many congrats on passing the exam by the way).

You and Jayant have convinced me now this is the way to go...

have took note of it...

hi Mohammed/Jayant

thx for getting back so quick

Mohammed - remotely meant doing it by myself.. doing self study and eventually sitting the exam

Jayant -.Out of interest did you do it this...

hi All

FYI... created an sp that you immediately call after you set yr job off.

it returns 0 or -1 on whether the job was successful or failed.

It basically waits in...

if its a migration you want to do ...why not go into the access mdb itself and do an export to Sql Server...much easier...why use an ssis package ?

I seem...

Phil,

many thx, I'll give it a go ...just wanted to know i wasn't going totally off piste on this by doing it this way...

forget the above post...i caught the post trail on page 5 thinkg it was the last post ...look as if its been fixed...chow for now....

hi Robert,

we all started as novices..now to business ...do one thing first... the script i sent works out of the tin...can you create a c:\development_support\images directory and add 10 files...

Listen,..10 or 10000 the script now works.....i couldn't care if it took all day ....its a one of insert ....just helping robert out...as usual its a hack...once its working...

hi Robert ..xmas come early for you ..here is complete code ...insert only works if the image exists...

i have only 7 images in my images directory...check it out....

-=====================================================

DECLARE @counter AS...

hi Robert

a tip to add single quotes..create a varchar and use it as wrapper...before and after what you want to double up

declare @single_quote varchar(1) , @fullname varchar(255)

SET @single_quote =...