Hi,

I'm using float, and performing some computing operation with T-sql using TEMP tables.

Syntax similar to this one :

SELECTALIMENTER_ID,SUM(BILAN)

INTO #TOTAUX

FROMECRITURES

GROUP BY ALIMENTER_ID

BILAN is a float column.

I don't know maybe...

Hi everyone !!

like I've said I opted for a CLR solution, even if we do prefer a sql one. it was basically because I was short in time. but right...

Thx everyone I would never hoped for this number of solutions, I will shrotly post the results.

Well the solution If we use a While or a cursor is obvious, I could post this if you want. but I figured out that a hybrid solution .Net &...

You'r right Jeff, I will need an auto-increment column to ensure the order. But let's presume that's the case.

I tried to simplify the problem because it's a little difficult for...

Hi

About the collate section :

+ CASE

WHEN collation IS NULL ...

Thanks Zach, Great Article,

But I wonder if selecting the hole "new_purchase" table each loop, would decrease the performance.

Am I wrong ?

Thanks for answering.

domo arigato

Moadh.

thanks a lot, this is what i was looking for 😀

thanks Flo

but just forget about the match column,

if we take the 3 lines where mv1 = 1 we will get

1 with 2,

1 with 6,

1 with 8

and because...