Mawwiage.....

There is no need to do a cursor. All you have to do is specify the operation(s) you want to perform to the entire set of rows....

Good to know, I suppose, but why are you declaring the variables inside a loop? That seems like an odd practice to me, and I just wondered about...

I was assuming that it would be acceptable to just generate a new table from the old rather than do a series of updates using the result set. ...

The following code will work, assuming the company name is consistent between all rows. For future reference, please include the declare statement and the inserts when you are...

Doesn't Newfoundland have it's own time zone?

It's 27.5 minutes ahead of Nova Scotia or something like that.

"Newbies?"

I thought he said "Newfies".... and was talking about Alvin! 😛

By the way, Steve, I ready the journey/destination reply and thought it was brilliant.

At least he put it in the Hardware section of the Forums....

I'm not a number, I'm a free man !!!

Spam emails: The preferred method of getting your questions moved to the head of the line when URGENT isn't working for you. I'm not even the target...

"FELLOW experts???"

We should test that:

SET STATISTICS TIME ON;

SELECT "Urgent! Please hurry!"

SET STATISTICS TIME OFF;

Hmmmm.... on my laptop it reduces...

Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉

I thought it was Lloyd Bridges.

Bru: Lynn is correct.

If I post something that seems odd, assume that...

No.... that's just what they'll be expecting us to do..... :smooooth: