apologies for the <bump>....any ideas any one?

think we need bit more of your original data

does this help?

USE [TEMPDB]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id =...

Jeff Moden (8/5/2010)

---

Jeff....I have found that I prefer to read articles from...

http://www.sqlservercentral.com/articles/T-SQL/68467/

have also corrected link in my original post.

TheSQLGuru (8/3/2010)

---

Hmm, I thought the quirky update WAS primarily a performance tool since it can solve problems where you need a triangular join or actual TSQL cursor to get the...

select

dateadd(dd,14,dateadd(mm, datediff(mm, 0, GetDate()) - 1, 0)),

dateadd(dd,13,dateadd(mm, datediff(mm, 0, GetDate()), 0))

got me thinking about some of my own reports....this is...

some useful ideas here to get you started

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

fair enough ....possibly the following article...

Just a thought...but what happens when

COMPANYNAME, NUM_USERS

company A, 300

company B, 2500

COMPANYNAME, NUM_USERS, USERS

company A, 3, [442, 443, 446................................................................]

company B, 2, [532, 456.....................

will "modulo" help ? (see BOL)

select 10.25 % 1

select 10.00 % 1

bteraberry (7/27/2010)

---

Wasn't trying to be overly critical ... just pointing out that the quirky update method isn't used for it's efficiency, it's used for when a regular set based approach...

ssis learner__ (7/27/2010)

---

Great code Gah...works like a charm........

Thanks a lot for your reply ...

I tried just now for about 4 million and it worked fine...

I will be trying on more...

bteraberry (7/27/2010)

---

You wouldn't want the quirky update method for this because it's not needed and therefore the performance hit would be unwarranted. It's a fairly simple join, but there...

out of interest...what excactly did the update statement update?

Hi

hopefully this along the lines of what you want to do.....

I strongly recommend you read the following article by Jeff Moden on this "quirky update".....and to follow all the rules...