I have solved my problem, but added in the defaults to make it work...thanks for the reply..

Thanks for the Input...I'll check this method out also... 🙂

Cheers..!!

Alright steady on...

I've actually done that in the time it's taken for a reply... 😉 so Job is a good en!!

UPDATE TableX

SET SEQ = TB1.SEQ

FROM TableX

INNER JOIN

(SELECT CustomerNumber, Date, RANK()...

Thanks for the reply...

How could i now take that script but update a new column in my database to show the sequence.

At the moment that seq column is blank but...

I think i have sorted my previous question using your original example to work in my favour...going to try and build on it further now!

I have a question for you...just moving on slightly....

I have a table that holds counts based on different criteria..example

001: Number of customers

002: Customers from Wales

The way it would appear in...

Okay thanks for the reply...I will check this way out as well. I have been using the last example you posted and that seems to work a treat. ...

This works perfectly...thanks for your help. I'm going to try and break the code up and now and understand what's happening at each stage.

Thanks

Thanks for that...

i'll take this away and have a play around with it...i'll let you know how i get on!! :O)

Thanks for the fast reply yesterday in regards to my query.

Now that i have the result values stored in a variable, is there another way that i could put these...

Thank you so much...

i've never seen anything like this before, but it seems to be working a treat. I'm going to mess around with it further now, but thanks...

Thanks for your reply...The response you put is the method i originally looked at, but i am just wondering "if" there might have been a more efficient way or a...