A customer can have more than one vehicle

A vehicle can have more than one customer (husband and wife, change of owner..)

(you may need another table here to cross reference owners...

Why DONT you want to build a DW? apart from a pretty steep learning curve, I don't think there is any licencing issue with R2

you can build pivots for...

just to be clear.

What you want is a pivot table with months across the top (columns), days down the side (31 rows, include rows with no logins) and #logins as...

@celko

You see that bit of text on the left, under the username - It says Forum Newbie.

stop shouting at people who are inexperienced and making them feel like...

I don't think you can generate a file with a row terminator of empty string. syntactically, if you opened the file in notepad or a text editor, how you...

consitency is the important thing here.

I prefer the PK to be called ID.

TABLE.ID refers to this tables PK

TABLE.SOMETABLE_ID refers to the related tables PK and infers a single field FK

I...

Celko is not necessarily wrong in his answers, bu this attitude stinks. we all had to start somewhere and make the Newbie errors.

As for IDs in tables, I (nearly)...

That is because you still havn't fixed the error 😀

In the second line of the WHERE clause you have said to calculate getdate() less 30 days, but you have not...

WHERE datetoquery >= dateadd(d,-3,getdate())

If datetoquery is a dateTIME stamp you may need to also strip the time off the getdate()

couldn't agree more!

😉

1.Find Application Id of related ‘Cancellation - Top Ups’ or ‘Not Taken Up - Top Ups’ application:

Select S_OPTY.NAME where S_OPTY.PAR_OPTY_ID = [Original Application Id] and S_OPTY.X_SALES_METHOD_ID identifies S_SALES_METHOD.NAME = either...

If you created this database structure, please read up on database normalisation and correct the structure before you go any further down this design.

If someone else created it and they...

which bit are you struggling with?

working backwards...

Can you create the second query with a variable

Can you create the second query with a fixed value.

Can you assign a value to the...

With the data you have provided, you will get 'duplicates' because there are different ways to end up at 603 from 602. Some paths use 2 steps, some 3...

you could get the sp to create a #temptable from the string of years passed in and then use this in either the JOIN or WHERE criteria, depending on what...