Ahh, yes the table does have a full text definition.  It's just not finding   A00J010002158.  If I do like '%A00J010002158', it finds it.  But that is very slow....

Ah, apologies.  I'd camped out too long on this post and didn't refresh before answering and so missed the fact that Mr. Burrows already posted the correct and for...

As already stated this is normally done in presentation layer.

However if you wish to do it in T-SQL and the datatype is MONEY you can do it this way

            
July 17, 2019 at 12:32 pm
            
#3663719

            
            
                                                
        

I don't know...

As for SSIS...I don't care for it either (I don't actually care for any of this drag'n'drop stuff because it turns out that's usually not all that's necessary) but...

... but SSIS can call a stored procedure for a data source, and write the output to a text file.  That may make more sense than trying to format...

Now, that would be scary :-/

Due to the fact the COUNT...

• This reply was modified 6 years, 3 months ago by David Burrows.

CREATE TABLE #output (TypeNo int,Line varchar(255));

INSERT #output (TypeNoLine)
SELECT 1,'HEADER|"'+CONVERT(char(8),GETDATE(),112))+'|"'+REPLACE(CONVERT(char(6),GETDATE(),108),':','') FROM #output;

INSERT #output (TypeNo,Line)
SELECT 2,CAST(id as varchar(20))+'|"'+CAST(empid as varchar(20))+'|"'+[text]
FROM [sometable];

INSERT #output (TypeNo,Line)
SELECT 3,'COUNT|"'+CAST(COUNT(*)+1 as varchar(20)) FROM #output;

SELECT Line
FROM...

Best to ignore the post and everyone else do likewise 🙂

It worked out well because, when people ask me why their code had performance issues, I could tell them, "Well, if you had used the fn Tally function like...

While it's not my job to judge, I do "follow" you on these forums for a reason... you're posts over the last more than a decade have always been...

• This reply was modified 6 years, 3 months ago by David Burrows.

They do...

Add a new row at the end of the table outside of any groups

Add text and format the row

Change the row visibility to hide the row if the dataset contains rows

Not sure of your exact requirement but

UPDATE #table SET num = -(num + 1) WHERE num >= 5;
UPDATE #table SET num = 5 WHERE num = 0;
UPDATE...