Hello Kevin

First thanks for your advise.

My invoice line have this 2 articles

REF DESIGN QTT ECUSTO

A ...

Hello Chris and Luis

Thanks for your interest and help.

also i agree with you when you say that we must always thinking to develop a solution that is the most...

Hello Chris

Thanks for your reply.

In my case the query run fast enough.

Also, can you rewrite my select using the suggestion on the 2 post to see what changes to be...

Hello Chris

I solve the problem like this:

1. Create the function

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[CSVToTable] (@InStr VARCHAR(MAX))

RETURNS @TempTab TABLE

(id int not null)

AS

BEGIN

;--...

Hello comunity

I solve the problem.

Many thanks

Luis Santos

Hello Sowbhari

regarding the Split function is not exactly what i need , i will try to explain

i need to passed several integer values separate with ',' comma

ex: 8,9,10

to run...

Hello Sowbhari

Thanks for your reply, also where i can found this Split function.

Many thanks

Luis Santos

Hello Sean and Luis

Sean and Luis , i try your scripts and they return what i need.

Many thanks,

Best regards,

Luis SAntos

Hello comunity

Nobody could give me a ideia or solution ?

I see several tread , and someone of them talk about permission on TEMP folder !?

What i need to do, on...

Hello Sean

Thanks for your reply, also i solve like this:

DECLARE @meubanco CHAR(10)

SET @meubanco = '1'

SELECT

cast(replace(@meubanco,'',' ')as char(10)) + conta

FROM bl

Maybe, that´s make no sense, but...

Hello

I explain better why i need to preserve whitespaces.

I have one field that keep my bank C(10) + codbank C(15), like this:

Select bank + codbank from tblbanks

B010 ...

Many thanks for all of you

Best regards

Luis Santos

Hello Eugene

work good, if i want to try like this without using FROM TABLE clause or CTE:

DECLARE @ref AS CHAR(18)

SET @ref = '8982214567.9999-Q199999999'

do you please send my how changes to...

Hello Eirikur

Thanks for your reply, but when i run your script on Adventureworks2012 database, i dont see the xml output, i see only the message:

Command complete sucessfully

Also, i need the...

Hello Eirikur

Thanks for your Reply, i will go to try understand them and try.

also i solve the problema like this:

SELECT top 1 c.fdata,

c.fno,

...