Oh dear, you have 2016 – STRING_AGG() does not work there, apologies.

Note also that your original code does not run – the column widths are not of sufficient size.

Possibly something like this:

SELECT *
FROM #CommaSeparatedString css;

WITH ordered
AS (SELECT css.ID
          ,NewValue = STRING_AGG(ss.value, ',') WITHIN GROUP(ORDER BY ss.value)
...

Our plan was not to store the ISPAC's, but I wasn't sure if they were like exe's.  I know I generally exclude the entire BIN and OBJ folder for C#...

Can you show us the schema of the table you wish to INSERT to?

Do you wish to insert all of the output into a single XML column? Or are you...

My own practices are mostly in line with Tim's.

But don't put ISPACs in source control, for the same reasons you don't put EXEs in source control ... it's a waste...

It's just XML. Try renaming to .txt and uploading again.

Edit: or .XML.

• This reply was modified 5 years, 7 months ago by Phil Parkin.
• This reply was modified 5 years, 7 months ago by Phil Parkin.

Which execution plan?

If you want a set of data to be processed by a stored procedure, could you simply load it into a staging table, then run the stored procedure to...

Do you understand why there would be a difference between the execution plans for

CREATE Proc x AS

Select * from tab1

and

Select * from tab1

? The first is pretty much useless, it's...

Well, that's unexpected ... but I have a solution for you. If you first REPLACE all instances of "" with " " (a single space) before using TOKEN, things seem...

My solution depends on there being the same number of quotation marks (") in every string which is split.

If an 'empty' column appears as "", the solution should still work....

Thom, this is great. Thank you for taking the time to write it out so clearly.

but I'm always surprised more people don't use it

Almost all of my development is done...

This can be done, if you think laterally: make " your delimiter and your formulas become:

TOKEN( SourceRecord,"\"",1)
TOKEN( SourceRecord,"\"",3)
TOKEN( SourceRecord,"\"",5)
TOKEN( SourceRecord,"\"",7)
TOKEN( SourceRecord,"\"",9)

Having said that, Frederico's suggestion is better,...

Years later - if someone stumbles over this: WITH(NOLOCK) can get locks for non-SELECT statements, for example, it will get locks if it is part of an UPDATE statement....

In this i want to add condition if @frdate Month = 3 and Date = 31 ...