:satisfied:

In addition to Dixie's reply I'd like to mention that this is also a programming (not just SQL) lesson. :smooooth:

Thanks!

No problem. I appreciate and thank you for your time and efforts! I'll keep thinking about this and let you know about any progress.

Sorry but it's not done yet 🙁

do this

truncate table newp

insert into NewP

select * from

(

select 5 id, 'E' name, 2 sort

Union all

select 11 id, 'K' name, 3 sort

Union...

No, I won't have more than 30 rows.

In fact, the newP table will be a temp/variable table and I know it's not recommended to store more than 100 records.

YES!

That's what I'm looking for.

THANKS!!!!

I was thinking about a similar solution ... but you gave it before me 🙂

Why did you use coalesce instead of isnull because there...

Yes

You're right.

thanks!

Imagine that you have a webpage where you can see the list and decide to move the products (re-sort them). So when you press "SAVE" button: E is on position...

Hi

Let's consider next case:

Tables: Sales 1<--> m Products 1<-->1 Country

Select *

FROM

Sales s

inner join Products p on s.ProductId = p.ProductId

inner join Country...

Hi,

Sorry, I should have used

Sales s

INNER JOINProducts p on c.ProductId = p.ProductId

not CustomerId ...

Thanks,

Luigi

Hi DavidP-340734,

Did you ever try your solution?

I've tested on a table with more the 3 mil records and my solution is more faster than yours.

Good luck!

Hi Lynn,

Yes, I saw you used Jeff's split method.

Hi,

You're right, using the Tally table is faster:

using this parameter:

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = REPLICATE('Element01,Element02,Element03,Element04,Element05,',159)

So I got next execution times (running the same script several...

Hi Mike1024,

"how do I display 5000"? ... well in my example I display 54977 .. maybe I should have written 54977 instead of 5000.

I hope you got the idea.

Hi gorr-688214,

In...