Well I'm trying to convert an Oracle PLSQL into SQLServer TSQL, and the logic for this particular Stored Procedure is the one i mentioned in my first post..

Declare @MyError int, @MyRowcount int

Update S

 SET NAME = REPLICATE(  CHAR(65 + (Sc.Counter *2) )  ,4) 

   from T_STOCKS S

 inner join (Select S1.ITEM_NO, count(*) as Counter

   from T_STOCKS S1

   Inner...

BTW, alzdba  your TSQL is really cool.. I would never have thought about that.. up till now I'm still figuring it out.....

what's wrong with cursors then?

Yup I guess you're right... hmmm... but its not by choice you know

Now I'm having a problem with reading files in T-SQL.. I was...

Well the oracle code is written in this way (an sp is called within the function... )

and well I can't just suggest ways...

I guess so, but there are some codes in Oracle that is in Oracle only so that's where the trouble comes from.

... As for the debug type, I don't have...

See if I have understood this correctly

('cause It's not easy to practice this here.. the environment is in japanese so I get into trouble a lot.

Thanks for the reply.. yup yo got it right but if I'm to request for a business logic that might take a...

Moreover, I had the idea of creating another table but I did not design this database so I'm not sure If I'm allowed to create on though... a global temporary...

You gave me an idea there, but actually I'm converting an Oracle PL SQL into SQLServer T-SQL, then the columns will be outputted to a csv file, although the data...

Thanks, the links did a great help... It gave me some tips. on the stored procedure part.

I figured.

Well I just want some confirmation. There's this client who want's the oracle plsql to be converted to SQLServer T-SQL and I...