In this particular case, I don't believe a cursor is a bad solution to go with. What you are doing isn't really set based to start with.

That...

I'm not familiar with logparser, so I may be off base, but it seems like your error here at this point is trying to use SELECT INTO repeatedly....

When I select this:

SELECT CAST('30-12-2099' as datetime)

I receive this:

Server: Msg 242, Level 16, State 3, Line 1

The conversion of a char data type to a datetime data type resulted...

Ok, now I get what you're trying to do. Amazing how much more sense it made as soon as you put the lines in between your groups...

What I still don't understand:

What you are grouping by to establish those "dense ranks" that you've given in your original data. The positions are all over the...

I doubt I'm going to be the only one bewildered by this request.

According to wikipedia:

Dense ranking ("1223" ranking)

In dense ranking, items that compare equal receive the same ranking number, and...

You can reference the main database by name in your from clause.

FROM MainDb.dbo.DF_Claim

You can do that from your own database. If you want to insert the results...

That said, I went ahead and wrote a script to do this, mainly because it interested me.

The following script assumes several things. One is that there is no other...

Please reference the post in my signature for how to post data on this forum.

Not sure if this would work as I haven't done much cross version stuff yet, but couldn't you select the data you need into a temp table on your SQL...

Correct. And for the record, I do the same thing that Gail and Lynn do with the formatting. A lot of the SP's in our db declare variables...

If your goal is to make your procedures more easily readable and maintain proper formatting... why wouldn't you upcase all the key words rather than lower case them? This...

If you could post your query, or failing that, the line that you reference your view in, it'd help.

Any reason something like this wouldn't work?

UPDATE Table1

SET organizationid = t.organizationid ,

contactid = t.contactid

FROM tempTable AS t join Table1 AS t1 ON t.contractorID = t1.contractorID

Nice, a new function(REVERSE) to play with. Thanks Steve.